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 45: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';

41: l_return_status VARCHAR2(1);
42: l_msg_count NUMBER;
43: l_msg_data VARCHAR2(2000);
44:
45: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
46: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
47:
48: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
49: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;

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

42: l_msg_count NUMBER;
43: l_msg_data VARCHAR2(2000);
44:
45: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
46: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
47:
48: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
49: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
50:

Line 51: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;

47:
48: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
49: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
50:
51: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
52: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
53: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
54:
55: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;

Line 53: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;

49: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
50:
51: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
52: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
53: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
54:
55: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
56: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
57:

Line 55: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;

51: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
52: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
53: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
54:
55: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
56: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
57:
58: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
59: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;

Line 58: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;

54:
55: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
56: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
57:
58: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
59: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
60: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
61: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
62: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;

Line 59: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;

55: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
56: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
57:
58: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
59: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
60: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
61: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
62: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
63:

Line 60: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;

56: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
57:
58: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
59: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
60: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
61: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
62: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
63:
64: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;

Line 61: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;

57:
58: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
59: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
60: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
61: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
62: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
63:
64: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;
65:

Line 62: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;

58: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
59: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
60: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
61: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
62: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
63:
64: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;
65:
66: x_new_adj_id AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;

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

60: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
61: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
62: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
63:
64: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;
65:
66: x_new_adj_id AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;
67: x_new_adj_number AR_ADJUSTMENTS.ADJUSTMENT_NUMBER%TYPE;
68:

Line 66: x_new_adj_id AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;

62: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
63:
64: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;
65:
66: x_new_adj_id AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;
67: x_new_adj_number AR_ADJUSTMENTS.ADJUSTMENT_NUMBER%TYPE;
68:
69: l_org_id NUMBER DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
70:

Line 67: x_new_adj_number AR_ADJUSTMENTS.ADJUSTMENT_NUMBER%TYPE;

63:
64: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;
65:
66: x_new_adj_id AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;
67: x_new_adj_number AR_ADJUSTMENTS.ADJUSTMENT_NUMBER%TYPE;
68:
69: l_org_id NUMBER DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
70:
71: ------------------------------

Line 75: l_adj_rec ar_adjustments%rowtype;

71: ------------------------------
72: -- DECLARE Record/Table Types
73: ------------------------------
74:
75: l_adj_rec ar_adjustments%rowtype;
76: l_ajlv_rec ajlv_rec_type;
77: x_ajlv_rec ajlv_rec_type;
78:
79: ------------------------------

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

355: l_return_status VARCHAR2(1);
356: l_msg_count NUMBER;
357: l_msg_data VARCHAR2(2000);
358:
359: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
360: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
361:
362: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
363: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;

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

356: l_msg_count NUMBER;
357: l_msg_data VARCHAR2(2000);
358:
359: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
360: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
361:
362: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
363: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
364:

Line 365: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;

361:
362: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
363: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
364:
365: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
366: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
367: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
368:
369: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;

Line 367: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;

363: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
364:
365: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
366: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
367: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
368:
369: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
370: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
371:

Line 369: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;

365: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
366: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
367: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
368:
369: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
370: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
371:
372: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
373: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;

Line 372: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;

368:
369: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
370: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
371:
372: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
373: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
374: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
375: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
376: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;

Line 373: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;

369: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
370: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
371:
372: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
373: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
374: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
375: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
376: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
377:

Line 374: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;

370: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
371:
372: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
373: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
374: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
375: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
376: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
377:
378: l_chk_approval_limits VARCHAR2(3);

Line 375: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;

371:
372: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
373: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
374: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
375: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
376: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
377:
378: l_chk_approval_limits VARCHAR2(3);
379: l_commit_flag VARCHAR2(3);

Line 376: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;

372: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
373: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
374: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
375: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
376: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
377:
378: l_chk_approval_limits VARCHAR2(3);
379: l_commit_flag VARCHAR2(3);
380:

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

377:
378: l_chk_approval_limits VARCHAR2(3);
379: l_commit_flag VARCHAR2(3);
380:
381: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;
382:
383: x_new_adj_number AR_ADJUSTMENTS.ADJUSTMENT_NUMBER%TYPE;
384:
385: l_org_id NUMBER DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

Line 383: x_new_adj_number AR_ADJUSTMENTS.ADJUSTMENT_NUMBER%TYPE;

379: l_commit_flag VARCHAR2(3);
380:
381: l_set_of_books_id AR_ADJUSTMENTS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL;
382:
383: x_new_adj_number AR_ADJUSTMENTS.ADJUSTMENT_NUMBER%TYPE;
384:
385: l_org_id NUMBER DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
386: -- 19-Sep-05 varao bug 4505226 Start
387: l_pdt_id NUMBER := 0;

Line 399: l_adj_rec ar_adjustments%rowtype;

395: ------------------------------
396: -- DECLARE Record/Table Types
397: ------------------------------
398:
399: l_adj_rec ar_adjustments%rowtype;
400: l_adjv_rec adjv_rec_type;
401: x_adjv_rec adjv_rec_type;
402: l_ajlv_rec ajlv_rec_type;
403: x_ajlv_rec ajlv_rec_type;