eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DPP_BPEL_SELCUSTCLAIM dependencies on DPP_CUSTOMERCLAIMS_PVT_DPP_CU

Line 3: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE)

1: PACKAGE BODY DPP_BPEL_SELCUSTCLAIM AS
2: /* $Header: dppvbscb.pls 120.4 2008/02/12 09:47:23 vdewan noship $ */
3: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE)
4: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_CU IS
5: aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU;
6: BEGIN
7: -- initialize the object

Line 4: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_CU IS

1: PACKAGE BODY DPP_BPEL_SELCUSTCLAIM AS
2: /* $Header: dppvbscb.pls 120.4 2008/02/12 09:47:23 vdewan noship $ */
3: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE)
4: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_CU IS
5: aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_CUSTOMERCLAIMS_PVT_DPP_CU(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Line 5: aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU;

1: PACKAGE BODY DPP_BPEL_SELCUSTCLAIM AS
2: /* $Header: dppvbscb.pls 120.4 2008/02/12 09:47:23 vdewan noship $ */
3: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE)
4: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_CU IS
5: aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_CUSTOMERCLAIMS_PVT_DPP_CU(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
9: aSqlItem.TRANSACTION_HEADER_ID := aPlsqlItem.TRANSACTION_HEADER_ID;

Line 8: aSqlItem := DPP_CUSTOMERCLAIMS_PVT_DPP_CU(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

4: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_CU IS
5: aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_CUSTOMERCLAIMS_PVT_DPP_CU(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
9: aSqlItem.TRANSACTION_HEADER_ID := aPlsqlItem.TRANSACTION_HEADER_ID;
10: aSqlItem.EFFECTIVE_START_DATE := aPlsqlItem.EFFECTIVE_START_DATE;
11: aSqlItem.EFFECTIVE_END_DATE := aPlsqlItem.EFFECTIVE_END_DATE;
12: aSqlItem.ORG_ID := aPlsqlItem.ORG_ID;

Line 21: FUNCTION SQL_TO_PL0(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU)

17: aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
18: aSqlItem.CURRENCY_CODE := aPlsqlItem.CURRENCY_CODE;
19: RETURN aSqlItem;
20: END PL_TO_SQL1;
21: FUNCTION SQL_TO_PL0(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU)
22: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE IS
23: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
24: BEGIN
25: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;

Line 22: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE IS

18: aSqlItem.CURRENCY_CODE := aPlsqlItem.CURRENCY_CODE;
19: RETURN aSqlItem;
20: END PL_TO_SQL1;
21: FUNCTION SQL_TO_PL0(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU)
22: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE IS
23: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
24: BEGIN
25: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;
26: aPlsqlItem.EFFECTIVE_START_DATE := aSqlItem.EFFECTIVE_START_DATE;

Line 23: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;

19: RETURN aSqlItem;
20: END PL_TO_SQL1;
21: FUNCTION SQL_TO_PL0(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_CU)
22: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE IS
23: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;
24: BEGIN
25: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;
26: aPlsqlItem.EFFECTIVE_START_DATE := aSqlItem.EFFECTIVE_START_DATE;
27: aPlsqlItem.EFFECTIVE_END_DATE := aSqlItem.EFFECTIVE_END_DATE;

Line 37: FUNCTION PL_TO_SQL2(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE)

33: aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
34: aPlsqlItem.CURRENCY_CODE := aSqlItem.CURRENCY_CODE;
35: RETURN aPlsqlItem;
36: END SQL_TO_PL0;
37: FUNCTION PL_TO_SQL2(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE)
38: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C4 IS
39: aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C4;
40: BEGIN
41: -- initialize the object

Line 49: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE IS

45: aSqlItem.INVOICE_CURRENCY_CODE := aPlsqlItem.INVOICE_CURRENCY_CODE;
46: RETURN aSqlItem;
47: END PL_TO_SQL2;
48: FUNCTION SQL_TO_PL2(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C4)
49: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE IS
50: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE;
51: BEGIN
52: aPlsqlItem.CUST_ACCOUNT_ID := aSqlItem.CUST_ACCOUNT_ID;
53: aPlsqlItem.LAST_PRICE := aSqlItem.LAST_PRICE;

Line 50: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE;

46: RETURN aSqlItem;
47: END PL_TO_SQL2;
48: FUNCTION SQL_TO_PL2(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C4)
49: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE IS
50: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_REC_TYPE;
51: BEGIN
52: aPlsqlItem.CUST_ACCOUNT_ID := aSqlItem.CUST_ACCOUNT_ID;
53: aPlsqlItem.LAST_PRICE := aSqlItem.LAST_PRICE;
54: aPlsqlItem.INVOICE_CURRENCY_CODE := aSqlItem.INVOICE_CURRENCY_CODE;

Line 57: FUNCTION PL_TO_SQL3(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE)

53: aPlsqlItem.LAST_PRICE := aSqlItem.LAST_PRICE;
54: aPlsqlItem.INVOICE_CURRENCY_CODE := aSqlItem.INVOICE_CURRENCY_CODE;
55: RETURN aPlsqlItem;
56: END SQL_TO_PL2;
57: FUNCTION PL_TO_SQL3(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE)
58: RETURN DPPCUSTOMERCLAIMSPVTDPPC2_DPP IS
59: aSqlItem DPPCUSTOMERCLAIMSPVTDPPC2_DPP;
60: BEGIN
61: -- initialize the table

Line 70: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE IS

66: END LOOP;
67: RETURN aSqlItem;
68: END PL_TO_SQL3;
69: FUNCTION SQL_TO_PL3(aSqlItem DPPCUSTOMERCLAIMSPVTDPPC2_DPP)
70: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE IS
71: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE;
72: BEGIN
73: FOR I IN 1..aSqlItem.COUNT LOOP
74: aPlsqlItem(I) := SQL_TO_PL2(aSqlItem(I));

Line 71: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE;

67: RETURN aSqlItem;
68: END PL_TO_SQL3;
69: FUNCTION SQL_TO_PL3(aSqlItem DPPCUSTOMERCLAIMSPVTDPPC2_DPP)
70: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE IS
71: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_PRICE_TBL_TYPE;
72: BEGIN
73: FOR I IN 1..aSqlItem.COUNT LOOP
74: aPlsqlItem(I) := SQL_TO_PL2(aSqlItem(I));
75: END LOOP;

Line 78: FUNCTION PL_TO_SQL4(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE)

74: aPlsqlItem(I) := SQL_TO_PL2(aSqlItem(I));
75: END LOOP;
76: RETURN aPlsqlItem;
77: END SQL_TO_PL3;
78: FUNCTION PL_TO_SQL4(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE)
79: RETURN DPP_CUSTOMERCLAIMS_PVT_DPP_C2 IS
80: aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C2;
81: BEGIN
82: -- initialize the object

Line 91: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE IS

87: aSqlItem.CUSTOMER_PRICE_TBL := PL_TO_SQL3(aPlsqlItem.CUSTOMER_PRICE_TBL);
88: RETURN aSqlItem;
89: END PL_TO_SQL4;
90: FUNCTION SQL_TO_PL4(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C2)
91: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE IS
92: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE;
93: BEGIN
94: aPlsqlItem.TRANSACTION_LINE_ID := aSqlItem.TRANSACTION_LINE_ID;
95: aPlsqlItem.INVENTORY_ITEM_ID := aSqlItem.INVENTORY_ITEM_ID;

Line 92: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE;

88: RETURN aSqlItem;
89: END PL_TO_SQL4;
90: FUNCTION SQL_TO_PL4(aSqlItem DPP_CUSTOMERCLAIMS_PVT_DPP_C2)
91: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE IS
92: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_REC_TYPE;
93: BEGIN
94: aPlsqlItem.TRANSACTION_LINE_ID := aSqlItem.TRANSACTION_LINE_ID;
95: aPlsqlItem.INVENTORY_ITEM_ID := aSqlItem.INVENTORY_ITEM_ID;
96: aPlsqlItem.UOM_CODE := aSqlItem.UOM_CODE;

Line 100: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE)

96: aPlsqlItem.UOM_CODE := aSqlItem.UOM_CODE;
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

Line 113: RETURN DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE IS

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
117: aPlsqlItem(I) := SQL_TO_PL4(aSqlItem(I));

Line 114: aPlsqlItem DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;

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
117: aPlsqlItem(I) := SQL_TO_PL4(aSqlItem(I));
118: END LOOP;

Line 123: X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_CUST_HDR_REC DPP_CUSTOMERCLAIMS_PVT_DPP_CU,

119: RETURN aPlsqlItem;
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

Line 125: P_CUST_HDR_REC_ APPS.DPP_CUSTOMERCLAIMS_PVT.DPP_CUST_HDR_REC_TYPE;

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);
129: P_CUSTOMER_TBL_ := DPP_BPEL_SELCUSTCLAIM.SQL_TO_PL1(P_CUSTOMER_TBL);

Line 126: P_CUSTOMER_TBL_ APPS.DPP_CUSTOMERCLAIMS_PVT.DPP_CUSTOMER_TBL_TYPE;

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);
129: P_CUSTOMER_TBL_ := DPP_BPEL_SELCUSTCLAIM.SQL_TO_PL1(P_CUSTOMER_TBL);
130: APPS.DPP_CUSTOMERCLAIMS_PVT.SELECT_CUSTOMERPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,