Case 1
CREATE OR REPLACE TYPE APPS."XXRCI_CO3_REQUEST_OBJ" as object
(
FRANCHISE_CODE VARCHAR2(100 BYTE),
CHANNEL_ID VARCHAR2(100 BYTE),
TRANSACTION_CODE VARCHAR2(100 BYTE),
PURCHASE_ORDER_NUMBER VARCHAR2(100 BYTE),
ORACLE_MOVE_ORDER_NUMBER VARCHAR2(100 BYTE),
ACTIVITY_CODE VARCHAR2(100 BYTE),
SHIP_FROM_WAREHOUSE VARCHAR2(100 BYTE),
SHIP_FROM_SUBINVENTORY VARCHAR2(100 BYTE),
SHIP_TO_WAREHOUSE VARCHAR2(100 BYTE),
CUST_NO_BILL_TO VARCHAR2(100 BYTE),
BILL_TO_NAME VARCHAR2(100 BYTE),
CUST_NO_SHIP_TO VARCHAR2(100 BYTE),
SHIP_TO_NAME VARCHAR2(100 BYTE),
SHIP_TO_ADDR1 VARCHAR2(100 BYTE),
SHIP_TO_ADDR2 VARCHAR2(100 BYTE),
EMAIL_ADDRESS VARCHAR2(100 BYTE),
SHIP_TO_CITY VARCHAR2(100 BYTE),
SHIP_TO_PROVINCE VARCHAR2(100 BYTE),
SHIP_TO_ZIP VARCHAR2(100 BYTE),
REQUESTED_DATE DATE,
SHIP_TO_PHONE VARCHAR2(100 BYTE),
SHIP_TO_DATE DATE,
REASON_CODE VARCHAR2(100 BYTE),
BAN VARCHAR2(100 BYTE),
WAYBILL_NUMBER VARCHAR2(100 BYTE),
STATUS VARCHAR2(100 BYTE),
COD_IDENTIFIER VARCHAR2(100 BYTE),
TOTAL_CHARGE VARCHAR2(100 BYTE),
CREDIT_CARD_NO VARCHAR2(100 BYTE),
CREDIT_CARD_TYPE VARCHAR2(100 BYTE),
EXPIRE_DATE DATE,
DETAILS XXRCI_CO3_DETAIL_TL
);
CASE 2.
CREATE OR REPLACE TYPE APPS."XXRCI_CO3_DETAIL_TL" AS TABLE OF APPS.XXRCI_CO3_DETAIL_OBJ;
CREATE OR REPLACE TYPE APPS."XXRCI_CO3_DETAIL_OBJ" as object
(
LINE_NUMBER VARCHAR2(100 BYTE),
ITEM_ID VARCHAR2(100 BYTE),
QTY_ORDERED INTEGER,
QTY_SHIPPED INTEGER,
ITEMS_SHIPPED XXRCI_CO3_ITEM_SHIPPED_TL
);
/
CASE 3
CREATE OR REPLACE TYPE APPS."XXRCI_CO3_ITEM_SHIPPED_TL" AS TABLE OF APPS.XXRCI_CO3_ITEM_SHIPPED_OBJ;
CREATE OR REPLACE TYPE APPS."XXRCI_CO3_ITEM_SHIPPED_OBJ" as object
(
CTN_NUMBER VARCHAR2(100 BYTE),
ITEM_TYPE_1 VARCHAR2(100 BYTE),
SERIAL_NUMBER_1 VARCHAR2(100 BYTE)
);
/
I am facing issue while calling this in PL/SQL..
DECLARE
lv_xxrci_co3 xxrci_co3_request_obj;
BEGIN
lv_xxrci_co3 := xxrci_co3_request_obj ('F'
,'CSM'
,'CO3'
,'15016740627'
,'136387941-40627'
,' '
,'857'
,'W Main'
,' '
,'689574135'
,'MANAR ALAFANDI'
,'0000099999'
,'MANAR ALAFANDI'
,'1433 GRANDBROOK CRES'
,' '
,'maandi@gmail.com'
,'MISSISSAUGA'
,'ON'
,'L5V0E1'
,'2019-05-17'
,'6478661444'
,'2019-05-17'
,'HWUP'
,'689574135'
,' '
,' '
,'N'
,'0'
,' '
,' '
,' '
,XXRCI_CO3_DETAIL_OBJ('24','FIDOTRISIM',1,1,XXRCI_CO3_ITEM_SHIPPED_OBJ('6478661444','SIM','89302370323038773521')));
END;
ORA- 06550 Wrong number or type of argument in call to XXRCI_CO3_DETAIL... Any help would be appreciated!!