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.OKL_CREATE_ADJST_PVT dependencies on AR_ADJUSTMENTS

Line 61: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;

57: ,x_adj_hdr_tbl OUT NOCOPY l_adj_hdr_tbl_type
58: ,x_adj_lines_tbl OUT NOCOPY l_adj_lines_tbl_type)
59: IS
60:
61: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
62: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
63: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
64: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
65: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;

Line 62: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;

58: ,x_adj_lines_tbl OUT NOCOPY l_adj_lines_tbl_type)
59: IS
60:
61: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
62: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
63: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
64: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
65: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
66: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;

Line 63: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;

59: IS
60:
61: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
62: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
63: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
64: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
65: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
66: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
67: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;

Line 64: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;

60:
61: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
62: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
63: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
64: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
65: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
66: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
67: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
68: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;

Line 66: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;

62: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
63: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
64: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
65: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
66: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
67: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
68: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
69:
70: CURSOR c_get_adjustments IS

Line 67: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;

63: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
64: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
65: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
66: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
67: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
68: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
69:
70: CURSOR c_get_adjustments IS
71: SELECT a.APPLY_DATE

Line 68: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;

64: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
65: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
66: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
67: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
68: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
69:
70: CURSOR c_get_adjustments IS
71: SELECT a.APPLY_DATE
72: ,a.GL_DATE

Line 295: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';

291: l_return_status VARCHAR2(1);
292: l_msg_count NUMBER;
293: l_msg_data VARCHAR2(2000);
294:
295: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
296: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
297:
298: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
299: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;

Line 296: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';

292: l_msg_count NUMBER;
293: l_msg_data VARCHAR2(2000);
294:
295: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
296: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
297:
298: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
299: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
300:

Line 301: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;

297:
298: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
299: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
300:
301: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
302: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
303: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
304:
305: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;

Line 303: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;

299: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
300:
301: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
302: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
303: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
304:
305: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
306: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
307:

Line 305: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;

301: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
302: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
303: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
304:
305: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
306: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
307:
308: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
309: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;

Line 308: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;

304:
305: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
306: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
307:
308: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
309: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
310: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
311: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
312: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;

Line 309: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;

305: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
306: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
307:
308: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
309: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
310: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
311: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
312: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
313:

Line 310: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;

306: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
307:
308: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
309: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
310: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
311: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
312: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
313:
314: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;

Line 311: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;

307:
308: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
309: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
310: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
311: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
312: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
313:
314: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;
315:

Line 312: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;

308: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
309: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
310: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
311: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
312: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
313:
314: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;
315:
316: x_new_adj_number AR_ADJUSTMENTS.ADJUSTMENT_NUMBER%TYPE;

Line 314: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;

310: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
311: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
312: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
313:
314: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;
315:
316: x_new_adj_number AR_ADJUSTMENTS.ADJUSTMENT_NUMBER%TYPE;
317:
318: l_org_id NUMBER DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

Line 316: x_new_adj_number AR_ADJUSTMENTS.ADJUSTMENT_NUMBER%TYPE;

312: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
313:
314: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;
315:
316: x_new_adj_number AR_ADJUSTMENTS.ADJUSTMENT_NUMBER%TYPE;
317:
318: l_org_id NUMBER DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
319:
320: ------------------------------

Line 324: l_adj_rec ar_adjustments%rowtype;

320: ------------------------------
321: -- DECLARE Record/Table Types
322: ------------------------------
323:
324: l_adj_rec ar_adjustments%rowtype;
325: l_ajlv_rec ajlv_rec_type;
326: x_ajlv_rec ajlv_rec_type;
327:
328: l_ajlv_tbl okl_txl_adjsts_lns_pub.ajlv_tbl_type;

Line 682: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';

678: l_return_status VARCHAR2(1);
679: l_msg_count NUMBER;
680: l_msg_data VARCHAR2(2000);
681:
682: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
683: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
684:
685: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
686: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;

Line 683: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';

679: l_msg_count NUMBER;
680: l_msg_data VARCHAR2(2000);
681:
682: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
683: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
684:
685: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
686: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
687:

Line 688: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;

684:
685: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
686: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
687:
688: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
689: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
690: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
691:
692: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;

Line 690: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;

686: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
687:
688: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
689: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
690: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
691:
692: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
693: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
694:

Line 692: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;

688: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
689: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
690: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
691:
692: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
693: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
694:
695: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
696: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;

Line 695: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;

691:
692: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
693: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
694:
695: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
696: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
697: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
698: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
699: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;

Line 696: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;

692: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
693: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
694:
695: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
696: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
697: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
698: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
699: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
700:

Line 697: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;

693: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
694:
695: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
696: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
697: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
698: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
699: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
700:
701: l_chk_approval_limits VARCHAR2(3);

Line 698: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;

694:
695: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
696: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
697: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
698: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
699: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
700:
701: l_chk_approval_limits VARCHAR2(3);
702: l_commit_flag VARCHAR2(3);

Line 699: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;

695: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
696: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
697: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
698: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
699: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
700:
701: l_chk_approval_limits VARCHAR2(3);
702: l_commit_flag VARCHAR2(3);
703:

Line 704: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;

700:
701: l_chk_approval_limits VARCHAR2(3);
702: l_commit_flag VARCHAR2(3);
703:
704: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;
705:
706: l_org_id NUMBER DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
707: -- 19-Sep-05 varao bug 4505226 Start
708: l_pdt_id NUMBER := 0;