15: +=======================================================================*/
16:
17: -- RECORD TYPE FOR AR ADJUSTMENT FUNCTION
18: TYPE ADJUSTMENT_REC_TYPE IS RECORD
19: (PAYMENT_SCHEDULE_ID AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE,
20: RECEIVABLES_TRX_ID AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE,
21: AMOUNT AR_ADJUSTMENTS.AMOUNT%TYPE,
22: CUSTOMER_TRX_LINE_ID AR_ADJUSTMENTS.CUSTOMER_TRX_LINE_ID%TYPE,
23: APPLY_DATE AR_ADJUSTMENTS.APPLY_DATE%TYPE,
16:
17: -- RECORD TYPE FOR AR ADJUSTMENT FUNCTION
18: TYPE ADJUSTMENT_REC_TYPE IS RECORD
19: (PAYMENT_SCHEDULE_ID AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE,
20: RECEIVABLES_TRX_ID AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE,
21: AMOUNT AR_ADJUSTMENTS.AMOUNT%TYPE,
22: CUSTOMER_TRX_LINE_ID AR_ADJUSTMENTS.CUSTOMER_TRX_LINE_ID%TYPE,
23: APPLY_DATE AR_ADJUSTMENTS.APPLY_DATE%TYPE,
24: GL_DATE AR_ADJUSTMENTS.GL_DATE%TYPE,
17: -- RECORD TYPE FOR AR ADJUSTMENT FUNCTION
18: TYPE ADJUSTMENT_REC_TYPE IS RECORD
19: (PAYMENT_SCHEDULE_ID AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE,
20: RECEIVABLES_TRX_ID AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE,
21: AMOUNT AR_ADJUSTMENTS.AMOUNT%TYPE,
22: CUSTOMER_TRX_LINE_ID AR_ADJUSTMENTS.CUSTOMER_TRX_LINE_ID%TYPE,
23: APPLY_DATE AR_ADJUSTMENTS.APPLY_DATE%TYPE,
24: GL_DATE AR_ADJUSTMENTS.GL_DATE%TYPE,
25: CREATED_FROM AR_ADJUSTMENTS.CREATED_FROM%TYPE);
18: TYPE ADJUSTMENT_REC_TYPE IS RECORD
19: (PAYMENT_SCHEDULE_ID AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE,
20: RECEIVABLES_TRX_ID AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE,
21: AMOUNT AR_ADJUSTMENTS.AMOUNT%TYPE,
22: CUSTOMER_TRX_LINE_ID AR_ADJUSTMENTS.CUSTOMER_TRX_LINE_ID%TYPE,
23: APPLY_DATE AR_ADJUSTMENTS.APPLY_DATE%TYPE,
24: GL_DATE AR_ADJUSTMENTS.GL_DATE%TYPE,
25: CREATED_FROM AR_ADJUSTMENTS.CREATED_FROM%TYPE);
26:
19: (PAYMENT_SCHEDULE_ID AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE,
20: RECEIVABLES_TRX_ID AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE,
21: AMOUNT AR_ADJUSTMENTS.AMOUNT%TYPE,
22: CUSTOMER_TRX_LINE_ID AR_ADJUSTMENTS.CUSTOMER_TRX_LINE_ID%TYPE,
23: APPLY_DATE AR_ADJUSTMENTS.APPLY_DATE%TYPE,
24: GL_DATE AR_ADJUSTMENTS.GL_DATE%TYPE,
25: CREATED_FROM AR_ADJUSTMENTS.CREATED_FROM%TYPE);
26:
27: --Bug 3886652 - Customer site added to Invoice_rec_type
20: RECEIVABLES_TRX_ID AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE,
21: AMOUNT AR_ADJUSTMENTS.AMOUNT%TYPE,
22: CUSTOMER_TRX_LINE_ID AR_ADJUSTMENTS.CUSTOMER_TRX_LINE_ID%TYPE,
23: APPLY_DATE AR_ADJUSTMENTS.APPLY_DATE%TYPE,
24: GL_DATE AR_ADJUSTMENTS.GL_DATE%TYPE,
25: CREATED_FROM AR_ADJUSTMENTS.CREATED_FROM%TYPE);
26:
27: --Bug 3886652 - Customer site added to Invoice_rec_type
28: TYPE INVOICE_REC_TYPE IS RECORD
21: AMOUNT AR_ADJUSTMENTS.AMOUNT%TYPE,
22: CUSTOMER_TRX_LINE_ID AR_ADJUSTMENTS.CUSTOMER_TRX_LINE_ID%TYPE,
23: APPLY_DATE AR_ADJUSTMENTS.APPLY_DATE%TYPE,
24: GL_DATE AR_ADJUSTMENTS.GL_DATE%TYPE,
25: CREATED_FROM AR_ADJUSTMENTS.CREATED_FROM%TYPE);
26:
27: --Bug 3886652 - Customer site added to Invoice_rec_type
28: TYPE INVOICE_REC_TYPE IS RECORD
29: (PAYMENT_SCHEDULE_ID NUMBER(15),