73:
74:
75: TYPE DEDUCTION_REC_TYPE IS RECORD
76: (
77: CLAIM_ID NUMBER := FND_API.G_MISS_NUM,
78: CLAIM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CLAIM_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
80: CLAIM_DATE DATE := FND_API.G_MISS_DATE,
81: DUE_DATE DATE := FND_API.G_MISS_DATE,
74:
75: TYPE DEDUCTION_REC_TYPE IS RECORD
76: (
77: CLAIM_ID NUMBER := FND_API.G_MISS_NUM,
78: CLAIM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CLAIM_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
80: CLAIM_DATE DATE := FND_API.G_MISS_DATE,
81: DUE_DATE DATE := FND_API.G_MISS_DATE,
82: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
75: TYPE DEDUCTION_REC_TYPE IS RECORD
76: (
77: CLAIM_ID NUMBER := FND_API.G_MISS_NUM,
78: CLAIM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CLAIM_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
80: CLAIM_DATE DATE := FND_API.G_MISS_DATE,
81: DUE_DATE DATE := FND_API.G_MISS_DATE,
82: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
83: AMOUNT NUMBER := FND_API.G_MISS_NUM,
76: (
77: CLAIM_ID NUMBER := FND_API.G_MISS_NUM,
78: CLAIM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CLAIM_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
80: CLAIM_DATE DATE := FND_API.G_MISS_DATE,
81: DUE_DATE DATE := FND_API.G_MISS_DATE,
82: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
83: AMOUNT NUMBER := FND_API.G_MISS_NUM,
84: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
77: CLAIM_ID NUMBER := FND_API.G_MISS_NUM,
78: CLAIM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CLAIM_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
80: CLAIM_DATE DATE := FND_API.G_MISS_DATE,
81: DUE_DATE DATE := FND_API.G_MISS_DATE,
82: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
83: AMOUNT NUMBER := FND_API.G_MISS_NUM,
84: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
85: EXCHANGE_RATE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: CLAIM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CLAIM_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
80: CLAIM_DATE DATE := FND_API.G_MISS_DATE,
81: DUE_DATE DATE := FND_API.G_MISS_DATE,
82: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
83: AMOUNT NUMBER := FND_API.G_MISS_NUM,
84: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
85: EXCHANGE_RATE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
79: CLAIM_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
80: CLAIM_DATE DATE := FND_API.G_MISS_DATE,
81: DUE_DATE DATE := FND_API.G_MISS_DATE,
82: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
83: AMOUNT NUMBER := FND_API.G_MISS_NUM,
84: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
85: EXCHANGE_RATE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
87: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
80: CLAIM_DATE DATE := FND_API.G_MISS_DATE,
81: DUE_DATE DATE := FND_API.G_MISS_DATE,
82: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
83: AMOUNT NUMBER := FND_API.G_MISS_NUM,
84: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
85: EXCHANGE_RATE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
87: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
88: SET_OF_BOOKS_ID NUMBER := FND_API.G_MISS_NUM,
81: DUE_DATE DATE := FND_API.G_MISS_DATE,
82: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
83: AMOUNT NUMBER := FND_API.G_MISS_NUM,
84: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
85: EXCHANGE_RATE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
87: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
88: SET_OF_BOOKS_ID NUMBER := FND_API.G_MISS_NUM,
89: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
82: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
83: AMOUNT NUMBER := FND_API.G_MISS_NUM,
84: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
85: EXCHANGE_RATE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
87: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
88: SET_OF_BOOKS_ID NUMBER := FND_API.G_MISS_NUM,
89: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
90: SOURCE_OBJECT_CLASS VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: AMOUNT NUMBER := FND_API.G_MISS_NUM,
84: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
85: EXCHANGE_RATE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
87: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
88: SET_OF_BOOKS_ID NUMBER := FND_API.G_MISS_NUM,
89: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
90: SOURCE_OBJECT_CLASS VARCHAR2(15) := FND_API.G_MISS_CHAR,
91: SOURCE_OBJECT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
84: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
85: EXCHANGE_RATE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
87: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
88: SET_OF_BOOKS_ID NUMBER := FND_API.G_MISS_NUM,
89: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
90: SOURCE_OBJECT_CLASS VARCHAR2(15) := FND_API.G_MISS_CHAR,
91: SOURCE_OBJECT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
92: SOURCE_OBJECT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: EXCHANGE_RATE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
87: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
88: SET_OF_BOOKS_ID NUMBER := FND_API.G_MISS_NUM,
89: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
90: SOURCE_OBJECT_CLASS VARCHAR2(15) := FND_API.G_MISS_CHAR,
91: SOURCE_OBJECT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
92: SOURCE_OBJECT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
86: EXCHANGE_RATE_DATE DATE := FND_API.G_MISS_DATE,
87: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
88: SET_OF_BOOKS_ID NUMBER := FND_API.G_MISS_NUM,
89: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
90: SOURCE_OBJECT_CLASS VARCHAR2(15) := FND_API.G_MISS_CHAR,
91: SOURCE_OBJECT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
92: SOURCE_OBJECT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
94: CUST_BILLTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
87: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
88: SET_OF_BOOKS_ID NUMBER := FND_API.G_MISS_NUM,
89: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
90: SOURCE_OBJECT_CLASS VARCHAR2(15) := FND_API.G_MISS_CHAR,
91: SOURCE_OBJECT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
92: SOURCE_OBJECT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
94: CUST_BILLTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: CUST_SHIPTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
88: SET_OF_BOOKS_ID NUMBER := FND_API.G_MISS_NUM,
89: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
90: SOURCE_OBJECT_CLASS VARCHAR2(15) := FND_API.G_MISS_CHAR,
91: SOURCE_OBJECT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
92: SOURCE_OBJECT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
94: CUST_BILLTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: CUST_SHIPTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
89: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
90: SOURCE_OBJECT_CLASS VARCHAR2(15) := FND_API.G_MISS_CHAR,
91: SOURCE_OBJECT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
92: SOURCE_OBJECT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
94: CUST_BILLTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: CUST_SHIPTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
97: REASON_CODE_ID NUMBER := FND_API.G_MISS_NUM,
90: SOURCE_OBJECT_CLASS VARCHAR2(15) := FND_API.G_MISS_CHAR,
91: SOURCE_OBJECT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
92: SOURCE_OBJECT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
94: CUST_BILLTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: CUST_SHIPTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
97: REASON_CODE_ID NUMBER := FND_API.G_MISS_NUM,
98: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: SOURCE_OBJECT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
92: SOURCE_OBJECT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
94: CUST_BILLTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: CUST_SHIPTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
97: REASON_CODE_ID NUMBER := FND_API.G_MISS_NUM,
98: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
92: SOURCE_OBJECT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
94: CUST_BILLTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: CUST_SHIPTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
97: REASON_CODE_ID NUMBER := FND_API.G_MISS_NUM,
98: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
100: SALES_REP_ID NUMBER := FND_API.G_MISS_NUM,
93: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
94: CUST_BILLTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: CUST_SHIPTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
97: REASON_CODE_ID NUMBER := FND_API.G_MISS_NUM,
98: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
100: SALES_REP_ID NUMBER := FND_API.G_MISS_NUM,
101: COLLECTOR_ID NUMBER := FND_API.G_MISS_NUM,
94: CUST_BILLTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
95: CUST_SHIPTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
97: REASON_CODE_ID NUMBER := FND_API.G_MISS_NUM,
98: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
100: SALES_REP_ID NUMBER := FND_API.G_MISS_NUM,
101: COLLECTOR_ID NUMBER := FND_API.G_MISS_NUM,
102: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
95: CUST_SHIPTO_ACCT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
97: REASON_CODE_ID NUMBER := FND_API.G_MISS_NUM,
98: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
100: SALES_REP_ID NUMBER := FND_API.G_MISS_NUM,
101: COLLECTOR_ID NUMBER := FND_API.G_MISS_NUM,
102: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
103: BROKER_ID NUMBER := FND_API.G_MISS_NUM,
96: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
97: REASON_CODE_ID NUMBER := FND_API.G_MISS_NUM,
98: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
100: SALES_REP_ID NUMBER := FND_API.G_MISS_NUM,
101: COLLECTOR_ID NUMBER := FND_API.G_MISS_NUM,
102: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
103: BROKER_ID NUMBER := FND_API.G_MISS_NUM,
104: CUSTOMER_REF_DATE DATE := FND_API.G_MISS_DATE,
97: REASON_CODE_ID NUMBER := FND_API.G_MISS_NUM,
98: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
100: SALES_REP_ID NUMBER := FND_API.G_MISS_NUM,
101: COLLECTOR_ID NUMBER := FND_API.G_MISS_NUM,
102: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
103: BROKER_ID NUMBER := FND_API.G_MISS_NUM,
104: CUSTOMER_REF_DATE DATE := FND_API.G_MISS_DATE,
105: CUSTOMER_REF_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
100: SALES_REP_ID NUMBER := FND_API.G_MISS_NUM,
101: COLLECTOR_ID NUMBER := FND_API.G_MISS_NUM,
102: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
103: BROKER_ID NUMBER := FND_API.G_MISS_NUM,
104: CUSTOMER_REF_DATE DATE := FND_API.G_MISS_DATE,
105: CUSTOMER_REF_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: RECEIPT_ID NUMBER := FND_API.G_MISS_NUM,
99: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
100: SALES_REP_ID NUMBER := FND_API.G_MISS_NUM,
101: COLLECTOR_ID NUMBER := FND_API.G_MISS_NUM,
102: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
103: BROKER_ID NUMBER := FND_API.G_MISS_NUM,
104: CUSTOMER_REF_DATE DATE := FND_API.G_MISS_DATE,
105: CUSTOMER_REF_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: RECEIPT_ID NUMBER := FND_API.G_MISS_NUM,
107: RECEIPT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: SALES_REP_ID NUMBER := FND_API.G_MISS_NUM,
101: COLLECTOR_ID NUMBER := FND_API.G_MISS_NUM,
102: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
103: BROKER_ID NUMBER := FND_API.G_MISS_NUM,
104: CUSTOMER_REF_DATE DATE := FND_API.G_MISS_DATE,
105: CUSTOMER_REF_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: RECEIPT_ID NUMBER := FND_API.G_MISS_NUM,
107: RECEIPT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: GL_DATE DATE := FND_API.G_MISS_DATE,
101: COLLECTOR_ID NUMBER := FND_API.G_MISS_NUM,
102: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
103: BROKER_ID NUMBER := FND_API.G_MISS_NUM,
104: CUSTOMER_REF_DATE DATE := FND_API.G_MISS_DATE,
105: CUSTOMER_REF_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: RECEIPT_ID NUMBER := FND_API.G_MISS_NUM,
107: RECEIPT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: GL_DATE DATE := FND_API.G_MISS_DATE,
109: COMMENTS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
102: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
103: BROKER_ID NUMBER := FND_API.G_MISS_NUM,
104: CUSTOMER_REF_DATE DATE := FND_API.G_MISS_DATE,
105: CUSTOMER_REF_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: RECEIPT_ID NUMBER := FND_API.G_MISS_NUM,
107: RECEIPT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: GL_DATE DATE := FND_API.G_MISS_DATE,
109: COMMENTS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
110: DEDUCTION_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: BROKER_ID NUMBER := FND_API.G_MISS_NUM,
104: CUSTOMER_REF_DATE DATE := FND_API.G_MISS_DATE,
105: CUSTOMER_REF_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: RECEIPT_ID NUMBER := FND_API.G_MISS_NUM,
107: RECEIPT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: GL_DATE DATE := FND_API.G_MISS_DATE,
109: COMMENTS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
110: DEDUCTION_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: DEDUCTION_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: CUSTOMER_REF_DATE DATE := FND_API.G_MISS_DATE,
105: CUSTOMER_REF_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: RECEIPT_ID NUMBER := FND_API.G_MISS_NUM,
107: RECEIPT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: GL_DATE DATE := FND_API.G_MISS_DATE,
109: COMMENTS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
110: DEDUCTION_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: DEDUCTION_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: DEDUCTION_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: CUSTOMER_REF_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: RECEIPT_ID NUMBER := FND_API.G_MISS_NUM,
107: RECEIPT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: GL_DATE DATE := FND_API.G_MISS_DATE,
109: COMMENTS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
110: DEDUCTION_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: DEDUCTION_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: DEDUCTION_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: DEDUCTION_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: RECEIPT_ID NUMBER := FND_API.G_MISS_NUM,
107: RECEIPT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: GL_DATE DATE := FND_API.G_MISS_DATE,
109: COMMENTS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
110: DEDUCTION_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: DEDUCTION_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: DEDUCTION_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: DEDUCTION_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: DEDUCTION_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
107: RECEIPT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: GL_DATE DATE := FND_API.G_MISS_DATE,
109: COMMENTS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
110: DEDUCTION_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: DEDUCTION_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: DEDUCTION_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: DEDUCTION_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: DEDUCTION_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: DEDUCTION_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
108: GL_DATE DATE := FND_API.G_MISS_DATE,
109: COMMENTS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
110: DEDUCTION_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: DEDUCTION_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: DEDUCTION_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: DEDUCTION_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: DEDUCTION_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: DEDUCTION_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: DEDUCTION_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
109: COMMENTS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
110: DEDUCTION_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: DEDUCTION_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: DEDUCTION_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: DEDUCTION_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: DEDUCTION_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: DEDUCTION_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: DEDUCTION_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: DEDUCTION_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
110: DEDUCTION_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: DEDUCTION_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: DEDUCTION_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: DEDUCTION_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: DEDUCTION_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: DEDUCTION_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: DEDUCTION_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: DEDUCTION_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: DEDUCTION_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: DEDUCTION_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: DEDUCTION_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: DEDUCTION_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: DEDUCTION_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: DEDUCTION_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: DEDUCTION_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: DEDUCTION_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: DEDUCTION_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: DEDUCTION_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: DEDUCTION_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: DEDUCTION_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: DEDUCTION_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: DEDUCTION_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: DEDUCTION_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: DEDUCTION_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: DEDUCTION_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: DEDUCTION_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: DEDUCTION_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: DEDUCTION_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: DEDUCTION_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: DEDUCTION_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: DEDUCTION_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: DEDUCTION_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: DEDUCTION_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: DEDUCTION_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: DEDUCTION_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: DEDUCTION_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: DEDUCTION_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: DEDUCTION_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: DEDUCTION_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: DEDUCTION_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: DEDUCTION_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: DEDUCTION_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: DEDUCTION_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: DEDUCTION_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: DEDUCTION_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: DEDUCTION_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: DEDUCTION_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: DEDUCTION_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: DEDUCTION_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: DEDUCTION_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: DEDUCTION_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: DEDUCTION_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: DEDUCTION_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: DEDUCTION_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: DEDUCTION_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: DEDUCTION_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: DEDUCTION_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: DEDUCTION_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: DEDUCTION_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: DEDUCTION_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: DEDUCTION_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: DEDUCTION_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: DEDUCTION_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: DEDUCTION_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: DEDUCTION_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: DEDUCTION_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: DEDUCTION_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: DEDUCTION_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: DEDUCTION_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: DEDUCTION_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: DEDUCTION_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: DEDUCTION_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: DEDUCTION_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: DEDUCTION_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: DEDUCTION_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: DEDUCTION_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: DEDUCTION_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: DEDUCTION_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: DEDUCTION_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: DEDUCTION_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM
119: DEDUCTION_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: DEDUCTION_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: DEDUCTION_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: DEDUCTION_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: DEDUCTION_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: DEDUCTION_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: DEDUCTION_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM
127: );
120: DEDUCTION_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: DEDUCTION_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: DEDUCTION_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: DEDUCTION_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: DEDUCTION_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: DEDUCTION_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM
127: );
128:
121: DEDUCTION_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: DEDUCTION_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: DEDUCTION_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: DEDUCTION_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: DEDUCTION_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM
127: );
128:
129:
122: DEDUCTION_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: DEDUCTION_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: DEDUCTION_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: DEDUCTION_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: ORG_ID NUMBER := FND_API.G_MISS_NUM
127: );
128:
129:
130: G_MISS_DEDUCTION_REC DEDUCTION_REC_TYPE;
150: -- Pre-Req :
151: -- Parameters:
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- P_Deduction IN Deduction_Rec_Type Required
158: --
151: -- Parameters:
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- P_Deduction IN Deduction_Rec_Type Required
158: --
159: -- OUT:
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- P_Deduction IN Deduction_Rec_Type Required
158: --
159: -- OUT:
160: -- x_return_status OUT VARCHAR2
171: -- End of Comments
172: --
173: PROCEDURE Create_Deduction(
174: P_Api_Version_Number IN NUMBER,
175: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
178:
179: X_Return_Status OUT NOCOPY VARCHAR2,
172: --
173: PROCEDURE Create_Deduction(
174: P_Api_Version_Number IN NUMBER,
175: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
178:
179: X_Return_Status OUT NOCOPY VARCHAR2,
180: X_Msg_Count OUT NOCOPY NUMBER,
173: PROCEDURE Create_Deduction(
174: P_Api_Version_Number IN NUMBER,
175: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
178:
179: X_Return_Status OUT NOCOPY VARCHAR2,
180: X_Msg_Count OUT NOCOPY NUMBER,
181: X_Msg_Data OUT NOCOPY VARCHAR2,
195: -- Pre-Req :
196: -- Parameters:
197: -- IN
198: -- p_api_version_number IN NUMBER Required
199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
200: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
201: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
202: -- P_Deduction IN Deduction_Rec_Type Required
203: --
196: -- Parameters:
197: -- IN
198: -- p_api_version_number IN NUMBER Required
199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
200: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
201: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
202: -- P_Deduction IN Deduction_Rec_Type Required
203: --
204: -- OUT:
197: -- IN
198: -- p_api_version_number IN NUMBER Required
199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
200: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
201: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
202: -- P_Deduction IN Deduction_Rec_Type Required
203: --
204: -- OUT:
205: -- x_return_status OUT VARCHAR2
214: -- End of Comments
215: --
216: PROCEDURE Update_Deduction(
217: P_Api_Version_Number IN NUMBER,
218: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
221:
222: X_Return_Status OUT NOCOPY VARCHAR2,
215: --
216: PROCEDURE Update_Deduction(
217: P_Api_Version_Number IN NUMBER,
218: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
221:
222: X_Return_Status OUT NOCOPY VARCHAR2,
223: X_Msg_Count OUT NOCOPY NUMBER,
216: PROCEDURE Update_Deduction(
217: P_Api_Version_Number IN NUMBER,
218: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
221:
222: X_Return_Status OUT NOCOPY VARCHAR2,
223: X_Msg_Count OUT NOCOPY NUMBER,
224: X_Msg_Data OUT NOCOPY VARCHAR2,