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.AR_LATE_CHARGE_PKG dependencies on DBMS_SQL

Line 17: iv_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;

13:
14: -----------
15: -- Invoice:
16: -----------
17: iv_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
18: iv_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
19: iv_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
20: iv_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
21: iv_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;

Line 18: iv_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;

14: -----------
15: -- Invoice:
16: -----------
17: iv_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
18: iv_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
19: iv_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
20: iv_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
21: iv_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
22: iv_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;

Line 19: iv_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;

15: -- Invoice:
16: -----------
17: iv_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
18: iv_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
19: iv_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
20: iv_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
21: iv_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
22: iv_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
23: iv_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;

Line 20: iv_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;

16: -----------
17: iv_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
18: iv_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
19: iv_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
20: iv_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
21: iv_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
22: iv_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
23: iv_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
24: iv_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 21: iv_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;

17: iv_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
18: iv_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
19: iv_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
20: iv_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
21: iv_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
22: iv_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
23: iv_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
24: iv_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
25: iv_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;

Line 22: iv_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;

18: iv_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
19: iv_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
20: iv_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
21: iv_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
22: iv_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
23: iv_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
24: iv_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
25: iv_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
26: iv_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;

Line 23: iv_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;

19: iv_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
20: iv_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
21: iv_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
22: iv_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
23: iv_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
24: iv_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
25: iv_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
26: iv_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
27: iv_org_id DBMS_SQL.NUMBER_TABLE;

Line 24: iv_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;

20: iv_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
21: iv_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
22: iv_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
23: iv_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
24: iv_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
25: iv_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
26: iv_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
27: iv_org_id DBMS_SQL.NUMBER_TABLE;
28: iv_legal_entity_id DBMS_SQL.NUMBER_TABLE;

Line 25: iv_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;

21: iv_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
22: iv_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
23: iv_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
24: iv_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
25: iv_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
26: iv_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
27: iv_org_id DBMS_SQL.NUMBER_TABLE;
28: iv_legal_entity_id DBMS_SQL.NUMBER_TABLE;
29: iv_interest_line_id DBMS_SQL.NUMBER_TABLE;

Line 26: iv_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;

22: iv_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
23: iv_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
24: iv_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
25: iv_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
26: iv_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
27: iv_org_id DBMS_SQL.NUMBER_TABLE;
28: iv_legal_entity_id DBMS_SQL.NUMBER_TABLE;
29: iv_interest_line_id DBMS_SQL.NUMBER_TABLE;
30: iv_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;

Line 27: iv_org_id DBMS_SQL.NUMBER_TABLE;

23: iv_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
24: iv_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
25: iv_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
26: iv_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
27: iv_org_id DBMS_SQL.NUMBER_TABLE;
28: iv_legal_entity_id DBMS_SQL.NUMBER_TABLE;
29: iv_interest_line_id DBMS_SQL.NUMBER_TABLE;
30: iv_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
31: iv_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;

Line 28: iv_legal_entity_id DBMS_SQL.NUMBER_TABLE;

24: iv_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
25: iv_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
26: iv_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
27: iv_org_id DBMS_SQL.NUMBER_TABLE;
28: iv_legal_entity_id DBMS_SQL.NUMBER_TABLE;
29: iv_interest_line_id DBMS_SQL.NUMBER_TABLE;
30: iv_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
31: iv_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
32: iv_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;

Line 29: iv_interest_line_id DBMS_SQL.NUMBER_TABLE;

25: iv_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
26: iv_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
27: iv_org_id DBMS_SQL.NUMBER_TABLE;
28: iv_legal_entity_id DBMS_SQL.NUMBER_TABLE;
29: iv_interest_line_id DBMS_SQL.NUMBER_TABLE;
30: iv_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
31: iv_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
32: iv_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
33: iv_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;

Line 30: iv_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;

26: iv_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
27: iv_org_id DBMS_SQL.NUMBER_TABLE;
28: iv_legal_entity_id DBMS_SQL.NUMBER_TABLE;
29: iv_interest_line_id DBMS_SQL.NUMBER_TABLE;
30: iv_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
31: iv_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
32: iv_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
33: iv_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
34: iv_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;

Line 31: iv_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;

27: iv_org_id DBMS_SQL.NUMBER_TABLE;
28: iv_legal_entity_id DBMS_SQL.NUMBER_TABLE;
29: iv_interest_line_id DBMS_SQL.NUMBER_TABLE;
30: iv_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
31: iv_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
32: iv_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
33: iv_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
34: iv_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
35: iv_type DBMS_SQL.VARCHAR2_TABLE;

Line 32: iv_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;

28: iv_legal_entity_id DBMS_SQL.NUMBER_TABLE;
29: iv_interest_line_id DBMS_SQL.NUMBER_TABLE;
30: iv_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
31: iv_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
32: iv_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
33: iv_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
34: iv_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
35: iv_type DBMS_SQL.VARCHAR2_TABLE;
36: iv_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;

Line 33: iv_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;

29: iv_interest_line_id DBMS_SQL.NUMBER_TABLE;
30: iv_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
31: iv_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
32: iv_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
33: iv_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
34: iv_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
35: iv_type DBMS_SQL.VARCHAR2_TABLE;
36: iv_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
37: iv_salesrep_id DBMS_SQL.NUMBER_TABLE;

Line 34: iv_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;

30: iv_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
31: iv_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
32: iv_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
33: iv_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
34: iv_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
35: iv_type DBMS_SQL.VARCHAR2_TABLE;
36: iv_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
37: iv_salesrep_id DBMS_SQL.NUMBER_TABLE;
38: iv_salesrep_number DBMS_SQL.VARCHAR2_TABLE;

Line 35: iv_type DBMS_SQL.VARCHAR2_TABLE;

31: iv_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
32: iv_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
33: iv_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
34: iv_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
35: iv_type DBMS_SQL.VARCHAR2_TABLE;
36: iv_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
37: iv_salesrep_id DBMS_SQL.NUMBER_TABLE;
38: iv_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
39: iv_GL_ID_REC DBMS_SQL.NUMBER_TABLE;

Line 36: iv_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;

32: iv_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
33: iv_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
34: iv_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
35: iv_type DBMS_SQL.VARCHAR2_TABLE;
36: iv_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
37: iv_salesrep_id DBMS_SQL.NUMBER_TABLE;
38: iv_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
39: iv_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
40: iv_GL_ID_REV DBMS_SQL.NUMBER_TABLE;

Line 37: iv_salesrep_id DBMS_SQL.NUMBER_TABLE;

33: iv_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
34: iv_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
35: iv_type DBMS_SQL.VARCHAR2_TABLE;
36: iv_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
37: iv_salesrep_id DBMS_SQL.NUMBER_TABLE;
38: iv_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
39: iv_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
40: iv_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
41: iv_cpt NUMBER := 0;

Line 38: iv_salesrep_number DBMS_SQL.VARCHAR2_TABLE;

34: iv_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
35: iv_type DBMS_SQL.VARCHAR2_TABLE;
36: iv_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
37: iv_salesrep_id DBMS_SQL.NUMBER_TABLE;
38: iv_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
39: iv_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
40: iv_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
41: iv_cpt NUMBER := 0;
42: iv_salesrep_set VARCHAR2(1) := 'N';

Line 39: iv_GL_ID_REC DBMS_SQL.NUMBER_TABLE;

35: iv_type DBMS_SQL.VARCHAR2_TABLE;
36: iv_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
37: iv_salesrep_id DBMS_SQL.NUMBER_TABLE;
38: iv_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
39: iv_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
40: iv_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
41: iv_cpt NUMBER := 0;
42: iv_salesrep_set VARCHAR2(1) := 'N';
43: iv_sales_credit_name VARCHAR2(200);

Line 40: iv_GL_ID_REV DBMS_SQL.NUMBER_TABLE;

36: iv_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
37: iv_salesrep_id DBMS_SQL.NUMBER_TABLE;
38: iv_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
39: iv_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
40: iv_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
41: iv_cpt NUMBER := 0;
42: iv_salesrep_set VARCHAR2(1) := 'N';
43: iv_sales_credit_name VARCHAR2(200);
44: iv_sales_credit_id NUMBER;

Line 45: iv_original_trx_id DBMS_SQL.NUMBER_TABLE;

41: iv_cpt NUMBER := 0;
42: iv_salesrep_set VARCHAR2(1) := 'N';
43: iv_sales_credit_name VARCHAR2(200);
44: iv_sales_credit_id NUMBER;
45: iv_original_trx_id DBMS_SQL.NUMBER_TABLE;
46: iv_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
47: iv_DUE_DATE DBMS_SQL.DATE_TABLE;
48: iv_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
49: iv_PAYMENT_DATE DBMS_SQL.DATE_TABLE;

Line 46: iv_original_trx_class DBMS_SQL.VARCHAR2_TABLE;

42: iv_salesrep_set VARCHAR2(1) := 'N';
43: iv_sales_credit_name VARCHAR2(200);
44: iv_sales_credit_id NUMBER;
45: iv_original_trx_id DBMS_SQL.NUMBER_TABLE;
46: iv_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
47: iv_DUE_DATE DBMS_SQL.DATE_TABLE;
48: iv_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
49: iv_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
50: iv_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;

Line 47: iv_DUE_DATE DBMS_SQL.DATE_TABLE;

43: iv_sales_credit_name VARCHAR2(200);
44: iv_sales_credit_id NUMBER;
45: iv_original_trx_id DBMS_SQL.NUMBER_TABLE;
46: iv_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
47: iv_DUE_DATE DBMS_SQL.DATE_TABLE;
48: iv_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
49: iv_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
50: iv_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;
51: iv_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;

Line 48: iv_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;

44: iv_sales_credit_id NUMBER;
45: iv_original_trx_id DBMS_SQL.NUMBER_TABLE;
46: iv_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
47: iv_DUE_DATE DBMS_SQL.DATE_TABLE;
48: iv_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
49: iv_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
50: iv_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;
51: iv_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;
52:

Line 49: iv_PAYMENT_DATE DBMS_SQL.DATE_TABLE;

45: iv_original_trx_id DBMS_SQL.NUMBER_TABLE;
46: iv_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
47: iv_DUE_DATE DBMS_SQL.DATE_TABLE;
48: iv_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
49: iv_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
50: iv_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;
51: iv_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;
52:
53: --------

Line 50: iv_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;

46: iv_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
47: iv_DUE_DATE DBMS_SQL.DATE_TABLE;
48: iv_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
49: iv_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
50: iv_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;
51: iv_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;
52:
53: --------
54: -- invoice api

Line 51: iv_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;

47: iv_DUE_DATE DBMS_SQL.DATE_TABLE;
48: iv_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
49: iv_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
50: iv_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;
51: iv_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;
52:
53: --------
54: -- invoice api
55: --------

Line 79: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;

75: nl_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
76: nl_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
77: nl_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
78: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
79: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
80: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
81: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
82: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
83: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;

Line 80: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;

76: nl_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
77: nl_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
78: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
79: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
80: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
81: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
82: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
83: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
84: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;

Line 81: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;

77: nl_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
78: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
79: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
80: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
81: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
82: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
83: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
84: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
85: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;

Line 82: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;

78: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
79: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
80: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
81: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
82: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
83: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
84: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
85: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
86: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 83: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;

79: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
80: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
81: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
82: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
83: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
84: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
85: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
86: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
87: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;

Line 84: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;

80: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
81: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
82: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
83: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
84: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
85: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
86: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
87: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
88: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;

Line 85: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;

81: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
82: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
83: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
84: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
85: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
86: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
87: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
88: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
89: nl_org_id DBMS_SQL.NUMBER_TABLE;

Line 86: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;

82: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
83: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
84: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
85: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
86: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
87: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
88: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
89: nl_org_id DBMS_SQL.NUMBER_TABLE;
90: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;

Line 87: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;

83: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
84: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
85: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
86: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
87: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
88: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
89: nl_org_id DBMS_SQL.NUMBER_TABLE;
90: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
91: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;

Line 88: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;

84: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
85: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
86: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
87: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
88: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
89: nl_org_id DBMS_SQL.NUMBER_TABLE;
90: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
91: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
92: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;

Line 89: nl_org_id DBMS_SQL.NUMBER_TABLE;

85: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
86: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
87: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
88: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
89: nl_org_id DBMS_SQL.NUMBER_TABLE;
90: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
91: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
92: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
93: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;

Line 90: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;

86: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
87: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
88: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
89: nl_org_id DBMS_SQL.NUMBER_TABLE;
90: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
91: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
92: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
93: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
94: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;

Line 91: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;

87: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
88: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
89: nl_org_id DBMS_SQL.NUMBER_TABLE;
90: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
91: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
92: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
93: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
94: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
95: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;

Line 92: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;

88: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
89: nl_org_id DBMS_SQL.NUMBER_TABLE;
90: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
91: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
92: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
93: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
94: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
95: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
96: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;

Line 93: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;

89: nl_org_id DBMS_SQL.NUMBER_TABLE;
90: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
91: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
92: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
93: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
94: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
95: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
96: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
97: nl_type DBMS_SQL.VARCHAR2_TABLE;

Line 94: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;

90: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
91: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
92: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
93: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
94: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
95: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
96: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
97: nl_type DBMS_SQL.VARCHAR2_TABLE;
98: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;

Line 95: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;

91: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
92: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
93: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
94: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
95: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
96: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
97: nl_type DBMS_SQL.VARCHAR2_TABLE;
98: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
99: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;

Line 96: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;

92: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
93: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
94: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
95: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
96: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
97: nl_type DBMS_SQL.VARCHAR2_TABLE;
98: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
99: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
100: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;

Line 97: nl_type DBMS_SQL.VARCHAR2_TABLE;

93: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
94: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
95: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
96: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
97: nl_type DBMS_SQL.VARCHAR2_TABLE;
98: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
99: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
100: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
101: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;

Line 98: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;

94: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
95: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
96: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
97: nl_type DBMS_SQL.VARCHAR2_TABLE;
98: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
99: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
100: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
101: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
102: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;

Line 99: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;

95: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
96: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
97: nl_type DBMS_SQL.VARCHAR2_TABLE;
98: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
99: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
100: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
101: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
102: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
103: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;

Line 100: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;

96: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
97: nl_type DBMS_SQL.VARCHAR2_TABLE;
98: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
99: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
100: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
101: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
102: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
103: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;
104: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;

Line 101: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;

97: nl_type DBMS_SQL.VARCHAR2_TABLE;
98: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
99: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
100: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
101: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
102: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
103: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;
104: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
105: nl_DUE_DATE DBMS_SQL.DATE_TABLE;

Line 102: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;

98: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
99: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
100: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
101: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
102: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
103: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;
104: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
105: nl_DUE_DATE DBMS_SQL.DATE_TABLE;
106: nl_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;

Line 103: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;

99: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
100: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
101: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
102: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
103: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;
104: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
105: nl_DUE_DATE DBMS_SQL.DATE_TABLE;
106: nl_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
107: nl_PAYMENT_DATE DBMS_SQL.DATE_TABLE;

Line 104: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;

100: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
101: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
102: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
103: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;
104: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
105: nl_DUE_DATE DBMS_SQL.DATE_TABLE;
106: nl_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
107: nl_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
108: nl_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;

Line 105: nl_DUE_DATE DBMS_SQL.DATE_TABLE;

101: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
102: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
103: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;
104: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
105: nl_DUE_DATE DBMS_SQL.DATE_TABLE;
106: nl_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
107: nl_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
108: nl_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;
109: nl_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;

Line 106: nl_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;

102: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
103: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;
104: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
105: nl_DUE_DATE DBMS_SQL.DATE_TABLE;
106: nl_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
107: nl_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
108: nl_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;
109: nl_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;
110:

Line 107: nl_PAYMENT_DATE DBMS_SQL.DATE_TABLE;

103: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;
104: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
105: nl_DUE_DATE DBMS_SQL.DATE_TABLE;
106: nl_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
107: nl_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
108: nl_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;
109: nl_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;
110:
111:

Line 108: nl_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;

104: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
105: nl_DUE_DATE DBMS_SQL.DATE_TABLE;
106: nl_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
107: nl_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
108: nl_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;
109: nl_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;
110:
111:
112:

Line 109: nl_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;

105: nl_DUE_DATE DBMS_SQL.DATE_TABLE;
106: nl_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
107: nl_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
108: nl_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;
109: nl_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;
110:
111:
112:
113: PROCEDURE log(

Line 757: l_sucess_line_id DBMS_SQL.NUMBER_TABLE;

753: WHERE b.interest_header_id = a.interest_header_id
754: AND b.interest_batch_id = g_interest_batch_id
755: AND b.execution_status = 'E');
756:
757: l_sucess_line_id DBMS_SQL.NUMBER_TABLE;
758: l_success_ps_id DBMS_SQL.NUMBER_TABLE;
759:
760: l_trx_header_id DBMS_SQL.NUMBER_TABLE;
761: l_trx_line_id DBMS_SQL.NUMBER_TABLE;

Line 758: l_success_ps_id DBMS_SQL.NUMBER_TABLE;

754: AND b.interest_batch_id = g_interest_batch_id
755: AND b.execution_status = 'E');
756:
757: l_sucess_line_id DBMS_SQL.NUMBER_TABLE;
758: l_success_ps_id DBMS_SQL.NUMBER_TABLE;
759:
760: l_trx_header_id DBMS_SQL.NUMBER_TABLE;
761: l_trx_line_id DBMS_SQL.NUMBER_TABLE;
762: l_err_text DBMS_SQL.VARCHAR2_TABLE;

Line 760: l_trx_header_id DBMS_SQL.NUMBER_TABLE;

756:
757: l_sucess_line_id DBMS_SQL.NUMBER_TABLE;
758: l_success_ps_id DBMS_SQL.NUMBER_TABLE;
759:
760: l_trx_header_id DBMS_SQL.NUMBER_TABLE;
761: l_trx_line_id DBMS_SQL.NUMBER_TABLE;
762: l_err_text DBMS_SQL.VARCHAR2_TABLE;
763: l_err_line_text DBMS_SQL.VARCHAR2_TABLE;
764:

Line 761: l_trx_line_id DBMS_SQL.NUMBER_TABLE;

757: l_sucess_line_id DBMS_SQL.NUMBER_TABLE;
758: l_success_ps_id DBMS_SQL.NUMBER_TABLE;
759:
760: l_trx_header_id DBMS_SQL.NUMBER_TABLE;
761: l_trx_line_id DBMS_SQL.NUMBER_TABLE;
762: l_err_text DBMS_SQL.VARCHAR2_TABLE;
763: l_err_line_text DBMS_SQL.VARCHAR2_TABLE;
764:
765: l_curr_hdr_id NUMBER := 0;

Line 762: l_err_text DBMS_SQL.VARCHAR2_TABLE;

758: l_success_ps_id DBMS_SQL.NUMBER_TABLE;
759:
760: l_trx_header_id DBMS_SQL.NUMBER_TABLE;
761: l_trx_line_id DBMS_SQL.NUMBER_TABLE;
762: l_err_text DBMS_SQL.VARCHAR2_TABLE;
763: l_err_line_text DBMS_SQL.VARCHAR2_TABLE;
764:
765: l_curr_hdr_id NUMBER := 0;
766: l_curr_line_id NUMBER := 0;

Line 763: l_err_line_text DBMS_SQL.VARCHAR2_TABLE;

759:
760: l_trx_header_id DBMS_SQL.NUMBER_TABLE;
761: l_trx_line_id DBMS_SQL.NUMBER_TABLE;
762: l_err_text DBMS_SQL.VARCHAR2_TABLE;
763: l_err_line_text DBMS_SQL.VARCHAR2_TABLE;
764:
765: l_curr_hdr_id NUMBER := 0;
766: l_curr_line_id NUMBER := 0;
767:

Line 768: l_header_upg DBMS_SQL.NUMBER_TABLE;

764:
765: l_curr_hdr_id NUMBER := 0;
766: l_curr_line_id NUMBER := 0;
767:
768: l_header_upg DBMS_SQL.NUMBER_TABLE;
769: l_header_text DBMS_SQL.VARCHAR2_TABLE;
770: hcpt NUMBER := 0;
771:
772: l_line_upg DBMS_SQL.NUMBER_TABLE;

Line 769: l_header_text DBMS_SQL.VARCHAR2_TABLE;

765: l_curr_hdr_id NUMBER := 0;
766: l_curr_line_id NUMBER := 0;
767:
768: l_header_upg DBMS_SQL.NUMBER_TABLE;
769: l_header_text DBMS_SQL.VARCHAR2_TABLE;
770: hcpt NUMBER := 0;
771:
772: l_line_upg DBMS_SQL.NUMBER_TABLE;
773: l_line_text DBMS_SQL.VARCHAR2_TABLE;

Line 772: l_line_upg DBMS_SQL.NUMBER_TABLE;

768: l_header_upg DBMS_SQL.NUMBER_TABLE;
769: l_header_text DBMS_SQL.VARCHAR2_TABLE;
770: hcpt NUMBER := 0;
771:
772: l_line_upg DBMS_SQL.NUMBER_TABLE;
773: l_line_text DBMS_SQL.VARCHAR2_TABLE;
774: lcpt NUMBER := 0;
775: l_text VARCHAR2(32000);
776: i NUMBER;

Line 773: l_line_text DBMS_SQL.VARCHAR2_TABLE;

769: l_header_text DBMS_SQL.VARCHAR2_TABLE;
770: hcpt NUMBER := 0;
771:
772: l_line_upg DBMS_SQL.NUMBER_TABLE;
773: l_line_text DBMS_SQL.VARCHAR2_TABLE;
774: lcpt NUMBER := 0;
775: l_text VARCHAR2(32000);
776: i NUMBER;
777:

Line 1179: (x_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

1175: END;
1176:
1177:
1178: PROCEDURE get_list_headers
1179: (x_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
1180: x_nb_list OUT NOCOPY NUMBER,
1181: p_worker_num IN NUMBER DEFAULT NULL)
1182: IS
1183: CURSOR nb_headers IS

Line 1323: l_list_header_id_tab DBMS_SQL.NUMBER_TABLE;

1319: l_inv_meaning VARCHAR2(80);
1320: l_dm_meaning VARCHAR2(80);
1321: l_last_fetch BOOLEAN := FALSE;
1322: j NUMBER := 0;
1323: l_list_header_id_tab DBMS_SQL.NUMBER_TABLE;
1324: l_nb_headers NUMBER;
1325: l_nb_row_ready NUMBER;
1326: l_exec_status VARCHAR2(1) := 'Y';
1327: L_NB_OF_DOC NUMBER;

Line 1328: l_list_header_in_error DBMS_SQL.NUMBER_TABLE;

1324: l_nb_headers NUMBER;
1325: l_nb_row_ready NUMBER;
1326: l_exec_status VARCHAR2(1) := 'Y';
1327: L_NB_OF_DOC NUMBER;
1328: l_list_header_in_error DBMS_SQL.NUMBER_TABLE;
1329: BEGIN
1330: outandlog( message => 'create_charge_inv_dm +');
1331: outandlog( message => ' p_batch_source_id :'||p_batch_source_id);
1332: outandlog( message => ' p_batch_id :'||p_batch_id);

Line 1651: l_interest_charged DBMS_SQL.NUMBER_TABLE;

1647: AND execution_status = 'I'
1648: AND NVL(p_worker_num,-9) = NVL(worker_num,-9);
1649:
1650:
1651: l_interest_charged DBMS_SQL.NUMBER_TABLE;
1652: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;
1653: l_type DBMS_SQL.VARCHAR2_TABLE;
1654: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1655: l_interest_header_id DBMS_SQL.NUMBER_TABLE;

Line 1652: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;

1648: AND NVL(p_worker_num,-9) = NVL(worker_num,-9);
1649:
1650:
1651: l_interest_charged DBMS_SQL.NUMBER_TABLE;
1652: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;
1653: l_type DBMS_SQL.VARCHAR2_TABLE;
1654: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1655: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1656: l_interest_line_id DBMS_SQL.NUMBER_TABLE;

Line 1653: l_type DBMS_SQL.VARCHAR2_TABLE;

1649:
1650:
1651: l_interest_charged DBMS_SQL.NUMBER_TABLE;
1652: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;
1653: l_type DBMS_SQL.VARCHAR2_TABLE;
1654: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1655: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1656: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1657: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;

Line 1654: l_original_trx_id DBMS_SQL.NUMBER_TABLE;

1650:
1651: l_interest_charged DBMS_SQL.NUMBER_TABLE;
1652: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;
1653: l_type DBMS_SQL.VARCHAR2_TABLE;
1654: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1655: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1656: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1657: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1658: l_rec_name DBMS_SQL.VARCHAR2_TABLE;

Line 1655: l_interest_header_id DBMS_SQL.NUMBER_TABLE;

1651: l_interest_charged DBMS_SQL.NUMBER_TABLE;
1652: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;
1653: l_type DBMS_SQL.VARCHAR2_TABLE;
1654: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1655: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1656: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1657: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1658: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1659: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;

Line 1656: l_interest_line_id DBMS_SQL.NUMBER_TABLE;

1652: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;
1653: l_type DBMS_SQL.VARCHAR2_TABLE;
1654: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1655: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1656: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1657: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1658: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1659: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1660: l_worker_num DBMS_SQL.NUMBER_TABLE;

Line 1657: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;

1653: l_type DBMS_SQL.VARCHAR2_TABLE;
1654: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1655: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1656: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1657: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1658: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1659: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1660: l_worker_num DBMS_SQL.NUMBER_TABLE;
1661: l_process_status DBMS_SQL.VARCHAR2_TABLE;

Line 1658: l_rec_name DBMS_SQL.VARCHAR2_TABLE;

1654: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1655: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1656: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1657: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1658: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1659: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1660: l_worker_num DBMS_SQL.NUMBER_TABLE;
1661: l_process_status DBMS_SQL.VARCHAR2_TABLE;
1662: l_process_msg DBMS_SQL.VARCHAR2_TABLE;

Line 1659: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;

1655: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1656: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1657: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1658: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1659: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1660: l_worker_num DBMS_SQL.NUMBER_TABLE;
1661: l_process_status DBMS_SQL.VARCHAR2_TABLE;
1662: l_process_msg DBMS_SQL.VARCHAR2_TABLE;
1663: l_error_line_id DBMS_SQL.NUMBER_TABLE;

Line 1660: l_worker_num DBMS_SQL.NUMBER_TABLE;

1656: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1657: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1658: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1659: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1660: l_worker_num DBMS_SQL.NUMBER_TABLE;
1661: l_process_status DBMS_SQL.VARCHAR2_TABLE;
1662: l_process_msg DBMS_SQL.VARCHAR2_TABLE;
1663: l_error_line_id DBMS_SQL.NUMBER_TABLE;
1664:

Line 1661: l_process_status DBMS_SQL.VARCHAR2_TABLE;

1657: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1658: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1659: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1660: l_worker_num DBMS_SQL.NUMBER_TABLE;
1661: l_process_status DBMS_SQL.VARCHAR2_TABLE;
1662: l_process_msg DBMS_SQL.VARCHAR2_TABLE;
1663: l_error_line_id DBMS_SQL.NUMBER_TABLE;
1664:
1665: --For late_charge_date on payment schedules

Line 1662: l_process_msg DBMS_SQL.VARCHAR2_TABLE;

1658: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1659: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1660: l_worker_num DBMS_SQL.NUMBER_TABLE;
1661: l_process_status DBMS_SQL.VARCHAR2_TABLE;
1662: l_process_msg DBMS_SQL.VARCHAR2_TABLE;
1663: l_error_line_id DBMS_SQL.NUMBER_TABLE;
1664:
1665: --For late_charge_date on payment schedules
1666: l_adjusted_ps DBMS_SQL.NUMBER_TABLE;

Line 1663: l_error_line_id DBMS_SQL.NUMBER_TABLE;

1659: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1660: l_worker_num DBMS_SQL.NUMBER_TABLE;
1661: l_process_status DBMS_SQL.VARCHAR2_TABLE;
1662: l_process_msg DBMS_SQL.VARCHAR2_TABLE;
1663: l_error_line_id DBMS_SQL.NUMBER_TABLE;
1664:
1665: --For late_charge_date on payment schedules
1666: l_adjusted_ps DBMS_SQL.NUMBER_TABLE;
1667: l_adjusted_ps_cnt NUMBER := 0;

Line 1666: l_adjusted_ps DBMS_SQL.NUMBER_TABLE;

1662: l_process_msg DBMS_SQL.VARCHAR2_TABLE;
1663: l_error_line_id DBMS_SQL.NUMBER_TABLE;
1664:
1665: --For late_charge_date on payment schedules
1666: l_adjusted_ps DBMS_SQL.NUMBER_TABLE;
1667: l_adjusted_ps_cnt NUMBER := 0;
1668:
1669: l_last_fetch BOOLEAN := FALSE;
1670: l_adj_meaning VARCHAR2(80);

Line 1674: l_null_char DBMS_SQL.VARCHAR2_TABLE;

1670: l_adj_meaning VARCHAR2(80);
1671: s_gl_date DATE;
1672: s_cal_int_date DATE;
1673:
1674: l_null_char DBMS_SQL.VARCHAR2_TABLE;
1675: l_null_num DBMS_SQL.NUMBER_TABLE;
1676: l_null_date DBMS_SQL.DATE_TABLE;
1677: l_msg_count NUMBER;
1678: l_msg_data VARCHAR2(2000);

Line 1675: l_null_num DBMS_SQL.NUMBER_TABLE;

1671: s_gl_date DATE;
1672: s_cal_int_date DATE;
1673:
1674: l_null_char DBMS_SQL.VARCHAR2_TABLE;
1675: l_null_num DBMS_SQL.NUMBER_TABLE;
1676: l_null_date DBMS_SQL.DATE_TABLE;
1677: l_msg_count NUMBER;
1678: l_msg_data VARCHAR2(2000);
1679: l_return_status VARCHAR2(10);

Line 1676: l_null_date DBMS_SQL.DATE_TABLE;

1672: s_cal_int_date DATE;
1673:
1674: l_null_char DBMS_SQL.VARCHAR2_TABLE;
1675: l_null_num DBMS_SQL.NUMBER_TABLE;
1676: l_null_date DBMS_SQL.DATE_TABLE;
1677: l_msg_count NUMBER;
1678: l_msg_data VARCHAR2(2000);
1679: l_return_status VARCHAR2(10);
1680: l_adj_rec ar_adjustments%ROWTYPE;

Line 2001: l_count DBMS_SQL.NUMBER_TABLE;

1997: FROM ar_late_charge_doc_gt
1998: WHERE interest_batch_id = g_interest_batch_id
1999: AND header_type = 'ADJ'
2000: GROUP BY execution_status;
2001: l_count DBMS_SQL.NUMBER_TABLE;
2002: l_status DBMS_SQL.VARCHAR2_TABLE;
2003: l_clr_count DBMS_SQL.NUMBER_TABLE;
2004: l_clr_status DBMS_SQL.VARCHAR2_TABLE;
2005: l_batch_status VARCHAR2(1) := 'S';

Line 2002: l_status DBMS_SQL.VARCHAR2_TABLE;

1998: WHERE interest_batch_id = g_interest_batch_id
1999: AND header_type = 'ADJ'
2000: GROUP BY execution_status;
2001: l_count DBMS_SQL.NUMBER_TABLE;
2002: l_status DBMS_SQL.VARCHAR2_TABLE;
2003: l_clr_count DBMS_SQL.NUMBER_TABLE;
2004: l_clr_status DBMS_SQL.VARCHAR2_TABLE;
2005: l_batch_status VARCHAR2(1) := 'S';
2006:

Line 2003: l_clr_count DBMS_SQL.NUMBER_TABLE;

1999: AND header_type = 'ADJ'
2000: GROUP BY execution_status;
2001: l_count DBMS_SQL.NUMBER_TABLE;
2002: l_status DBMS_SQL.VARCHAR2_TABLE;
2003: l_clr_count DBMS_SQL.NUMBER_TABLE;
2004: l_clr_status DBMS_SQL.VARCHAR2_TABLE;
2005: l_batch_status VARCHAR2(1) := 'S';
2006:
2007: PROCEDURE set_batch_status

Line 2004: l_clr_status DBMS_SQL.VARCHAR2_TABLE;

2000: GROUP BY execution_status;
2001: l_count DBMS_SQL.NUMBER_TABLE;
2002: l_status DBMS_SQL.VARCHAR2_TABLE;
2003: l_clr_count DBMS_SQL.NUMBER_TABLE;
2004: l_clr_status DBMS_SQL.VARCHAR2_TABLE;
2005: l_batch_status VARCHAR2(1) := 'S';
2006:
2007: PROCEDURE set_batch_status
2008: (p_status IN VARCHAR2,

Line 2466: l_customer_site_use_id DBMS_SQL.NUMBER_TABLE;

2462: WHERE interest_batch_id = g_interest_batch_id;
2463:
2464: l_err VARCHAR2(1);
2465: l_test VARCHAR2(1);
2466: l_customer_site_use_id DBMS_SQL.NUMBER_TABLE;
2467: x_num_adj_created NUMBER;
2468: x_num_adj_error NUMBER;
2469: x_return_status VARCHAR2(10);
2470: x_msg_count NUMBER;

Line 3071: x_worker_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

3067: --{HYU Implemetation per worker
3068: PROCEDURE prepare_header_for_worker
3069: (p_interest_batch_id IN NUMBER,
3070: p_max_workers IN NUMBER,
3071: x_worker_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
3072: x_nb_doc_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
3073: x_return_status OUT NOCOPY VARCHAR2)
3074: IS
3075: CURSOR c IS

Line 3072: x_nb_doc_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

3068: PROCEDURE prepare_header_for_worker
3069: (p_interest_batch_id IN NUMBER,
3070: p_max_workers IN NUMBER,
3071: x_worker_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
3072: x_nb_doc_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
3073: x_return_status OUT NOCOPY VARCHAR2)
3074: IS
3075: CURSOR c IS
3076: SELECT worker_num,

Line 3188: l_customer_site_use_id DBMS_SQL.NUMBER_TABLE;

3184: AND process_status <> 'S';
3185:
3186: l_err VARCHAR2(1);
3187: l_test VARCHAR2(1);
3188: l_customer_site_use_id DBMS_SQL.NUMBER_TABLE;
3189: x_num_adj_created NUMBER;
3190: x_num_adj_error NUMBER;
3191: x_return_status VARCHAR2(10);
3192: x_msg_count NUMBER;

Line 3197: x_worker_list DBMS_SQL.NUMBER_TABLE;

3193: x_msg_data VARCHAR2(2000);
3194: l_request_id NUMBER;
3195: l_exec_srs VARCHAR2(1) := 'N';
3196: l_need_wait VARCHAR2(1) := 'N';
3197: x_worker_list DBMS_SQL.NUMBER_TABLE;
3198: x_nb_doc_list DBMS_SQL.NUMBER_TABLE;
3199:
3200: nothing_to_process EXCEPTION;
3201: BEGIN

Line 3198: x_nb_doc_list DBMS_SQL.NUMBER_TABLE;

3194: l_request_id NUMBER;
3195: l_exec_srs VARCHAR2(1) := 'N';
3196: l_need_wait VARCHAR2(1) := 'N';
3197: x_worker_list DBMS_SQL.NUMBER_TABLE;
3198: x_nb_doc_list DBMS_SQL.NUMBER_TABLE;
3199:
3200: nothing_to_process EXCEPTION;
3201: BEGIN
3202: log('create_late_charge_by_worker +');