DBA Data[Home] [Help]

APPS.DPP_BPEL_SELCUSTCLAIM dependencies on DPP_CUSTOMERCLAIMS_PVT_DPP_C1

Line 101: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C1 IS

97: aPlsqlItem.CUSTOMER_PRICE_TBL := SQL_TO_PL3(aSqlItem.CUSTOMER_PRICE_TBL);
98: RETURN aPlsqlItem;
99: END SQL_TO_PL4;
100: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE)
101: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C1 IS
102: aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1;
103: BEGIN
104: -- initialize the table
105: aSqlItem := DPP_CUSTOMERCLAIMS_PVT_DPP_C1();

Line 102: aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1;

98: RETURN aPlsqlItem;
99: END SQL_TO_PL4;
100: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE)
101: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C1 IS
102: aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1;
103: BEGIN
104: -- initialize the table
105: aSqlItem := DPP_CUSTOMERCLAIMS_PVT_DPP_C1();
106: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 105: aSqlItem := DPP_CUSTOMERCLAIMS_PVT_DPP_C1();

101: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C1 IS
102: aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1;
103: BEGIN
104: -- initialize the table
105: aSqlItem := DPP_CUSTOMERCLAIMS_PVT_DPP_C1();
106: aSqlItem.EXTEND(aPlsqlItem.COUNT);
107: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
108: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL4(aPlsqlItem(I));
109: END LOOP;

Line 112: FUNCTION SQL_TO_PL1(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1)

108: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL4(aPlsqlItem(I));
109: END LOOP;
110: RETURN aSqlItem;
111: END PL_TO_SQL0;
112: FUNCTION SQL_TO_PL1(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C1)
113: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE IS
114: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;
115: BEGIN
116: FOR I IN 1..aSqlItem.COUNT LOOP

Line 124: P_CUSTOMER_TBL IN OUT NOCOPY DPP_CUSTOMERCLAIMS_PVT_DPP_C1) IS

120: END SQL_TO_PL1;
121:
122: PROCEDURE DPP_CUSTOMERCLAIMS_PVT$SELECT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,
123: X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_CUST_HDR_REC DPP_CUSTOMERCLAIMS_PVT_DPP_CU,
124: P_CUSTOMER_TBL IN OUT NOCOPY DPP_CUSTOMERCLAIMS_PVT_DPP_C1) IS
125: P_CUST_HDR_REC_ APPS.DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
126: P_CUSTOMER_TBL_ APPS.DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;
127: BEGIN
128: P_CUST_HDR_REC_ := DPP_BPEL_SELCUSTCLAIM.SQL_TO_PL0(P_CUST_HDR_REC);