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: /*10297326 declare for contact*/

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: /*10297326 declare for contact*/
54: iv_CONTACT_ID DBMS_SQL.NUMBER_TABLE;

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: /*10297326 declare for contact*/
54: iv_CONTACT_ID DBMS_SQL.NUMBER_TABLE;
55: iv_CUST_ACCT_SITE_ID DBMS_SQL.NUMBER_TABLE;

Line 54: iv_CONTACT_ID DBMS_SQL.NUMBER_TABLE;

50: iv_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;
51: iv_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;
52:
53: /*10297326 declare for contact*/
54: iv_CONTACT_ID DBMS_SQL.NUMBER_TABLE;
55: iv_CUST_ACCT_SITE_ID DBMS_SQL.NUMBER_TABLE;
56: --------
57: -- invoice api
58: --------

Line 55: iv_CUST_ACCT_SITE_ID DBMS_SQL.NUMBER_TABLE;

51: iv_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;
52:
53: /*10297326 declare for contact*/
54: iv_CONTACT_ID DBMS_SQL.NUMBER_TABLE;
55: iv_CUST_ACCT_SITE_ID DBMS_SQL.NUMBER_TABLE;
56: --------
57: -- invoice api
58: --------
59: iv_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;

Line 82: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;

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

Line 83: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;

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

Line 84: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;

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

Line 85: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;

81: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
82: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
83: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
84: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
85: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
86: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
87: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
88: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
89: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 86: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;

82: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
83: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
84: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
85: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
86: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
87: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
88: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
89: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
90: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;

Line 87: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;

83: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
84: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
85: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
86: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
87: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
88: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
89: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
90: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
91: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;

Line 88: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;

84: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
85: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
86: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
87: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
88: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
89: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
90: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
91: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
92: nl_org_id DBMS_SQL.NUMBER_TABLE;

Line 89: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;

85: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
86: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
87: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
88: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
89: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
90: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
91: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
92: nl_org_id DBMS_SQL.NUMBER_TABLE;
93: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;

Line 90: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;

86: nl_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE;
87: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
88: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
89: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
90: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
91: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
92: nl_org_id DBMS_SQL.NUMBER_TABLE;
93: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
94: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;

Line 91: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;

87: nl_CUSTOMER_SITE_USE_ID DBMS_SQL.NUMBER_TABLE;
88: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
89: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
90: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
91: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
92: nl_org_id DBMS_SQL.NUMBER_TABLE;
93: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
94: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
95: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;

Line 92: nl_org_id DBMS_SQL.NUMBER_TABLE;

88: nl_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
89: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
90: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
91: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
92: nl_org_id DBMS_SQL.NUMBER_TABLE;
93: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
94: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
95: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
96: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;

Line 93: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;

89: nl_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
90: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
91: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
92: nl_org_id DBMS_SQL.NUMBER_TABLE;
93: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
94: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
95: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
96: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
97: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;

Line 94: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;

90: nl_EXCHANGE_RATE DBMS_SQL.NUMBER_TABLE;
91: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
92: nl_org_id DBMS_SQL.NUMBER_TABLE;
93: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
94: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
95: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
96: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
97: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
98: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;

Line 95: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;

91: nl_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
92: nl_org_id DBMS_SQL.NUMBER_TABLE;
93: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
94: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
95: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
96: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
97: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
98: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
99: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;

Line 96: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;

92: nl_org_id DBMS_SQL.NUMBER_TABLE;
93: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
94: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
95: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
96: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
97: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
98: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
99: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
100: nl_type DBMS_SQL.VARCHAR2_TABLE;

Line 97: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;

93: nl_legal_entity_id DBMS_SQL.NUMBER_TABLE;
94: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
95: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
96: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
97: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
98: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
99: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
100: nl_type DBMS_SQL.VARCHAR2_TABLE;
101: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;

Line 98: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;

94: nl_interest_line_id DBMS_SQL.NUMBER_TABLE;
95: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
96: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
97: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
98: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
99: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
100: nl_type DBMS_SQL.VARCHAR2_TABLE;
101: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
102: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;

Line 99: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;

95: nl_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
96: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
97: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
98: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
99: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
100: nl_type DBMS_SQL.VARCHAR2_TABLE;
101: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
102: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
103: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;

Line 100: nl_type DBMS_SQL.VARCHAR2_TABLE;

96: nl_DAYS_OF_INTEREST DBMS_SQL.NUMBER_TABLE;
97: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
98: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
99: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
100: nl_type DBMS_SQL.VARCHAR2_TABLE;
101: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
102: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
103: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
104: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;

Line 101: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;

97: nl_DAYS_OVERDUE_LATE DBMS_SQL.NUMBER_TABLE;
98: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
99: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
100: nl_type DBMS_SQL.VARCHAR2_TABLE;
101: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
102: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
103: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
104: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
105: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;

Line 102: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;

98: nl_DAILY_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
99: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
100: nl_type DBMS_SQL.VARCHAR2_TABLE;
101: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
102: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
103: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
104: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
105: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
106: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;

Line 103: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;

99: nl_INTEREST_CHARGED DBMS_SQL.NUMBER_TABLE;
100: nl_type DBMS_SQL.VARCHAR2_TABLE;
101: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
102: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
103: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
104: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
105: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
106: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;
107: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;

Line 104: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;

100: nl_type DBMS_SQL.VARCHAR2_TABLE;
101: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
102: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
103: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
104: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
105: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
106: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;
107: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
108: nl_DUE_DATE DBMS_SQL.DATE_TABLE;

Line 105: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;

101: nl_salesrep_required_flag DBMS_SQL.VARCHAR2_TABLE;
102: nl_salesrep_id DBMS_SQL.NUMBER_TABLE;
103: nl_salesrep_number DBMS_SQL.VARCHAR2_TABLE;
104: nl_GL_ID_REC DBMS_SQL.NUMBER_TABLE;
105: nl_GL_ID_REV DBMS_SQL.NUMBER_TABLE;
106: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;
107: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
108: nl_DUE_DATE DBMS_SQL.DATE_TABLE;
109: nl_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;

Line 106: nl_original_trx_id DBMS_SQL.NUMBER_TABLE;

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

Line 107: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;

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

Line 108: nl_DUE_DATE DBMS_SQL.DATE_TABLE;

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

Line 109: nl_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;

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

Line 110: nl_PAYMENT_DATE DBMS_SQL.DATE_TABLE;

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

Line 111: nl_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;

107: nl_original_trx_class DBMS_SQL.VARCHAR2_TABLE;
108: nl_DUE_DATE DBMS_SQL.DATE_TABLE;
109: nl_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
110: nl_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
111: nl_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;
112: nl_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;
113:
114:
115:

Line 112: nl_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;

108: nl_DUE_DATE DBMS_SQL.DATE_TABLE;
109: nl_OUTSTANDING_AMOUNT DBMS_SQL.NUMBER_TABLE;
110: nl_PAYMENT_DATE DBMS_SQL.DATE_TABLE;
111: nl_LAST_CHARGE_DATE DBMS_SQL.DATE_TABLE;
112: nl_INTEREST_RATE DBMS_SQL.NUMBER_TABLE;
113:
114:
115:
116: PROCEDURE log(

Line 780: l_sucess_line_id DBMS_SQL.NUMBER_TABLE;

776: WHERE b.interest_header_id = a.interest_header_id
777: AND b.interest_batch_id = g_interest_batch_id
778: AND b.execution_status = 'E');
779:
780: l_sucess_line_id DBMS_SQL.NUMBER_TABLE;
781: l_success_ps_id DBMS_SQL.NUMBER_TABLE;
782:
783: l_trx_header_id DBMS_SQL.NUMBER_TABLE;
784: l_trx_line_id DBMS_SQL.NUMBER_TABLE;

Line 781: l_success_ps_id DBMS_SQL.NUMBER_TABLE;

777: AND b.interest_batch_id = g_interest_batch_id
778: AND b.execution_status = 'E');
779:
780: l_sucess_line_id DBMS_SQL.NUMBER_TABLE;
781: l_success_ps_id DBMS_SQL.NUMBER_TABLE;
782:
783: l_trx_header_id DBMS_SQL.NUMBER_TABLE;
784: l_trx_line_id DBMS_SQL.NUMBER_TABLE;
785: l_err_text DBMS_SQL.VARCHAR2_TABLE;

Line 783: l_trx_header_id DBMS_SQL.NUMBER_TABLE;

779:
780: l_sucess_line_id DBMS_SQL.NUMBER_TABLE;
781: l_success_ps_id DBMS_SQL.NUMBER_TABLE;
782:
783: l_trx_header_id DBMS_SQL.NUMBER_TABLE;
784: l_trx_line_id DBMS_SQL.NUMBER_TABLE;
785: l_err_text DBMS_SQL.VARCHAR2_TABLE;
786: l_err_line_text DBMS_SQL.VARCHAR2_TABLE;
787:

Line 784: l_trx_line_id DBMS_SQL.NUMBER_TABLE;

780: l_sucess_line_id DBMS_SQL.NUMBER_TABLE;
781: l_success_ps_id DBMS_SQL.NUMBER_TABLE;
782:
783: l_trx_header_id DBMS_SQL.NUMBER_TABLE;
784: l_trx_line_id DBMS_SQL.NUMBER_TABLE;
785: l_err_text DBMS_SQL.VARCHAR2_TABLE;
786: l_err_line_text DBMS_SQL.VARCHAR2_TABLE;
787:
788: l_curr_hdr_id NUMBER := 0;

Line 785: l_err_text DBMS_SQL.VARCHAR2_TABLE;

781: l_success_ps_id DBMS_SQL.NUMBER_TABLE;
782:
783: l_trx_header_id DBMS_SQL.NUMBER_TABLE;
784: l_trx_line_id DBMS_SQL.NUMBER_TABLE;
785: l_err_text DBMS_SQL.VARCHAR2_TABLE;
786: l_err_line_text DBMS_SQL.VARCHAR2_TABLE;
787:
788: l_curr_hdr_id NUMBER := 0;
789: l_curr_line_id NUMBER := 0;

Line 786: l_err_line_text DBMS_SQL.VARCHAR2_TABLE;

782:
783: l_trx_header_id DBMS_SQL.NUMBER_TABLE;
784: l_trx_line_id DBMS_SQL.NUMBER_TABLE;
785: l_err_text DBMS_SQL.VARCHAR2_TABLE;
786: l_err_line_text DBMS_SQL.VARCHAR2_TABLE;
787:
788: l_curr_hdr_id NUMBER := 0;
789: l_curr_line_id NUMBER := 0;
790:

Line 791: l_header_upg DBMS_SQL.NUMBER_TABLE;

787:
788: l_curr_hdr_id NUMBER := 0;
789: l_curr_line_id NUMBER := 0;
790:
791: l_header_upg DBMS_SQL.NUMBER_TABLE;
792: l_header_text DBMS_SQL.VARCHAR2_TABLE;
793: hcpt NUMBER := 0;
794:
795: l_line_upg DBMS_SQL.NUMBER_TABLE;

Line 792: l_header_text DBMS_SQL.VARCHAR2_TABLE;

788: l_curr_hdr_id NUMBER := 0;
789: l_curr_line_id NUMBER := 0;
790:
791: l_header_upg DBMS_SQL.NUMBER_TABLE;
792: l_header_text DBMS_SQL.VARCHAR2_TABLE;
793: hcpt NUMBER := 0;
794:
795: l_line_upg DBMS_SQL.NUMBER_TABLE;
796: l_line_text DBMS_SQL.VARCHAR2_TABLE;

Line 795: l_line_upg DBMS_SQL.NUMBER_TABLE;

791: l_header_upg DBMS_SQL.NUMBER_TABLE;
792: l_header_text DBMS_SQL.VARCHAR2_TABLE;
793: hcpt NUMBER := 0;
794:
795: l_line_upg DBMS_SQL.NUMBER_TABLE;
796: l_line_text DBMS_SQL.VARCHAR2_TABLE;
797: lcpt NUMBER := 0;
798: l_text VARCHAR2(32000);
799: i NUMBER;

Line 796: l_line_text DBMS_SQL.VARCHAR2_TABLE;

792: l_header_text DBMS_SQL.VARCHAR2_TABLE;
793: hcpt NUMBER := 0;
794:
795: l_line_upg DBMS_SQL.NUMBER_TABLE;
796: l_line_text DBMS_SQL.VARCHAR2_TABLE;
797: lcpt NUMBER := 0;
798: l_text VARCHAR2(32000);
799: i NUMBER;
800:

Line 1207: (x_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

1203: END;
1204:
1205:
1206: PROCEDURE get_list_headers
1207: (x_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
1208: x_nb_list OUT NOCOPY NUMBER,
1209: p_worker_num IN NUMBER DEFAULT NULL)
1210: IS
1211: CURSOR nb_headers IS

Line 1358: l_list_header_id_tab DBMS_SQL.NUMBER_TABLE;

1354: l_inv_meaning VARCHAR2(80);
1355: l_dm_meaning VARCHAR2(80);
1356: l_last_fetch BOOLEAN := FALSE;
1357: j NUMBER := 0;
1358: l_list_header_id_tab DBMS_SQL.NUMBER_TABLE;
1359: l_nb_headers NUMBER;
1360: l_nb_row_ready NUMBER;
1361: l_exec_status VARCHAR2(1) := 'Y';
1362: L_NB_OF_DOC NUMBER;

Line 1363: l_list_header_in_error DBMS_SQL.NUMBER_TABLE;

1359: l_nb_headers NUMBER;
1360: l_nb_row_ready NUMBER;
1361: l_exec_status VARCHAR2(1) := 'Y';
1362: L_NB_OF_DOC NUMBER;
1363: l_list_header_in_error DBMS_SQL.NUMBER_TABLE;
1364: BEGIN
1365: outandlog( message => 'create_charge_inv_dm +');
1366: outandlog( message => ' p_batch_source_id :'||p_batch_source_id);
1367: outandlog( message => ' p_batch_id :'||p_batch_id);

Line 1691: l_interest_charged DBMS_SQL.NUMBER_TABLE;

1687: AND execution_status = 'I'
1688: AND NVL(p_worker_num,-9) = NVL(worker_num,-9);
1689:
1690:
1691: l_interest_charged DBMS_SQL.NUMBER_TABLE;
1692: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;
1693: l_type DBMS_SQL.VARCHAR2_TABLE;
1694: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1695: l_interest_header_id DBMS_SQL.NUMBER_TABLE;

Line 1692: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;

1688: AND NVL(p_worker_num,-9) = NVL(worker_num,-9);
1689:
1690:
1691: l_interest_charged DBMS_SQL.NUMBER_TABLE;
1692: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;
1693: l_type DBMS_SQL.VARCHAR2_TABLE;
1694: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1695: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1696: l_interest_line_id DBMS_SQL.NUMBER_TABLE;

Line 1693: l_type DBMS_SQL.VARCHAR2_TABLE;

1689:
1690:
1691: l_interest_charged DBMS_SQL.NUMBER_TABLE;
1692: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;
1693: l_type DBMS_SQL.VARCHAR2_TABLE;
1694: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1695: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1696: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1697: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;

Line 1694: l_original_trx_id DBMS_SQL.NUMBER_TABLE;

1690:
1691: l_interest_charged DBMS_SQL.NUMBER_TABLE;
1692: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;
1693: l_type DBMS_SQL.VARCHAR2_TABLE;
1694: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1695: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1696: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1697: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1698: l_rec_name DBMS_SQL.VARCHAR2_TABLE;

Line 1695: l_interest_header_id DBMS_SQL.NUMBER_TABLE;

1691: l_interest_charged DBMS_SQL.NUMBER_TABLE;
1692: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;
1693: l_type DBMS_SQL.VARCHAR2_TABLE;
1694: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1695: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1696: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1697: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1698: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1699: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;

Line 1696: l_interest_line_id DBMS_SQL.NUMBER_TABLE;

1692: l_payment_schedule_id DBMS_SQL.NUMBER_TABLE;
1693: l_type DBMS_SQL.VARCHAR2_TABLE;
1694: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1695: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1696: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1697: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1698: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1699: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1700: l_worker_num DBMS_SQL.NUMBER_TABLE;

Line 1697: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;

1693: l_type DBMS_SQL.VARCHAR2_TABLE;
1694: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1695: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1696: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1697: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1698: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1699: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1700: l_worker_num DBMS_SQL.NUMBER_TABLE;
1701: l_process_status DBMS_SQL.VARCHAR2_TABLE;

Line 1698: l_rec_name DBMS_SQL.VARCHAR2_TABLE;

1694: l_original_trx_id DBMS_SQL.NUMBER_TABLE;
1695: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1696: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1697: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1698: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1699: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1700: l_worker_num DBMS_SQL.NUMBER_TABLE;
1701: l_process_status DBMS_SQL.VARCHAR2_TABLE;
1702: l_process_msg DBMS_SQL.VARCHAR2_TABLE;

Line 1699: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;

1695: l_interest_header_id DBMS_SQL.NUMBER_TABLE;
1696: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1697: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1698: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1699: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1700: l_worker_num DBMS_SQL.NUMBER_TABLE;
1701: l_process_status DBMS_SQL.VARCHAR2_TABLE;
1702: l_process_msg DBMS_SQL.VARCHAR2_TABLE;
1703: l_error_line_id DBMS_SQL.NUMBER_TABLE;

Line 1700: l_worker_num DBMS_SQL.NUMBER_TABLE;

1696: l_interest_line_id DBMS_SQL.NUMBER_TABLE;
1697: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1698: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1699: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1700: l_worker_num DBMS_SQL.NUMBER_TABLE;
1701: l_process_status DBMS_SQL.VARCHAR2_TABLE;
1702: l_process_msg DBMS_SQL.VARCHAR2_TABLE;
1703: l_error_line_id DBMS_SQL.NUMBER_TABLE;
1704:

Line 1701: l_process_status DBMS_SQL.VARCHAR2_TABLE;

1697: l_rec_trx_id DBMS_SQL.NUMBER_TABLE;
1698: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1699: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1700: l_worker_num DBMS_SQL.NUMBER_TABLE;
1701: l_process_status DBMS_SQL.VARCHAR2_TABLE;
1702: l_process_msg DBMS_SQL.VARCHAR2_TABLE;
1703: l_error_line_id DBMS_SQL.NUMBER_TABLE;
1704:
1705: --For late_charge_date on payment schedules

Line 1702: l_process_msg DBMS_SQL.VARCHAR2_TABLE;

1698: l_rec_name DBMS_SQL.VARCHAR2_TABLE;
1699: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1700: l_worker_num DBMS_SQL.NUMBER_TABLE;
1701: l_process_status DBMS_SQL.VARCHAR2_TABLE;
1702: l_process_msg DBMS_SQL.VARCHAR2_TABLE;
1703: l_error_line_id DBMS_SQL.NUMBER_TABLE;
1704:
1705: --For late_charge_date on payment schedules
1706: l_adjusted_ps DBMS_SQL.NUMBER_TABLE;

Line 1703: l_error_line_id DBMS_SQL.NUMBER_TABLE;

1699: l_interest_batch_id DBMS_SQL.NUMBER_TABLE;
1700: l_worker_num DBMS_SQL.NUMBER_TABLE;
1701: l_process_status DBMS_SQL.VARCHAR2_TABLE;
1702: l_process_msg DBMS_SQL.VARCHAR2_TABLE;
1703: l_error_line_id DBMS_SQL.NUMBER_TABLE;
1704:
1705: --For late_charge_date on payment schedules
1706: l_adjusted_ps DBMS_SQL.NUMBER_TABLE;
1707: l_adjusted_ps_cnt NUMBER := 0;

Line 1706: l_adjusted_ps DBMS_SQL.NUMBER_TABLE;

1702: l_process_msg DBMS_SQL.VARCHAR2_TABLE;
1703: l_error_line_id DBMS_SQL.NUMBER_TABLE;
1704:
1705: --For late_charge_date on payment schedules
1706: l_adjusted_ps DBMS_SQL.NUMBER_TABLE;
1707: l_adjusted_ps_cnt NUMBER := 0;
1708:
1709: l_last_fetch BOOLEAN := FALSE;
1710: l_adj_meaning VARCHAR2(80);

Line 1714: l_null_char DBMS_SQL.VARCHAR2_TABLE;

1710: l_adj_meaning VARCHAR2(80);
1711: s_gl_date DATE;
1712: s_cal_int_date DATE;
1713:
1714: l_null_char DBMS_SQL.VARCHAR2_TABLE;
1715: l_null_num DBMS_SQL.NUMBER_TABLE;
1716: l_null_date DBMS_SQL.DATE_TABLE;
1717: l_msg_count NUMBER;
1718: l_msg_data VARCHAR2(2000);

Line 1715: l_null_num DBMS_SQL.NUMBER_TABLE;

1711: s_gl_date DATE;
1712: s_cal_int_date DATE;
1713:
1714: l_null_char DBMS_SQL.VARCHAR2_TABLE;
1715: l_null_num DBMS_SQL.NUMBER_TABLE;
1716: l_null_date DBMS_SQL.DATE_TABLE;
1717: l_msg_count NUMBER;
1718: l_msg_data VARCHAR2(2000);
1719: l_return_status VARCHAR2(10);

Line 1716: l_null_date DBMS_SQL.DATE_TABLE;

1712: s_cal_int_date DATE;
1713:
1714: l_null_char DBMS_SQL.VARCHAR2_TABLE;
1715: l_null_num DBMS_SQL.NUMBER_TABLE;
1716: l_null_date DBMS_SQL.DATE_TABLE;
1717: l_msg_count NUMBER;
1718: l_msg_data VARCHAR2(2000);
1719: l_return_status VARCHAR2(10);
1720: l_adj_rec ar_adjustments%ROWTYPE;

Line 2041: l_count DBMS_SQL.NUMBER_TABLE;

2037: FROM ar_late_charge_doc_gt
2038: WHERE interest_batch_id = g_interest_batch_id
2039: AND header_type = 'ADJ'
2040: GROUP BY execution_status;
2041: l_count DBMS_SQL.NUMBER_TABLE;
2042: l_status DBMS_SQL.VARCHAR2_TABLE;
2043: l_clr_count DBMS_SQL.NUMBER_TABLE;
2044: l_clr_status DBMS_SQL.VARCHAR2_TABLE;
2045: l_batch_status VARCHAR2(1) := 'S';

Line 2042: l_status DBMS_SQL.VARCHAR2_TABLE;

2038: WHERE interest_batch_id = g_interest_batch_id
2039: AND header_type = 'ADJ'
2040: GROUP BY execution_status;
2041: l_count DBMS_SQL.NUMBER_TABLE;
2042: l_status DBMS_SQL.VARCHAR2_TABLE;
2043: l_clr_count DBMS_SQL.NUMBER_TABLE;
2044: l_clr_status DBMS_SQL.VARCHAR2_TABLE;
2045: l_batch_status VARCHAR2(1) := 'S';
2046:

Line 2043: l_clr_count DBMS_SQL.NUMBER_TABLE;

2039: AND header_type = 'ADJ'
2040: GROUP BY execution_status;
2041: l_count DBMS_SQL.NUMBER_TABLE;
2042: l_status DBMS_SQL.VARCHAR2_TABLE;
2043: l_clr_count DBMS_SQL.NUMBER_TABLE;
2044: l_clr_status DBMS_SQL.VARCHAR2_TABLE;
2045: l_batch_status VARCHAR2(1) := 'S';
2046:
2047: PROCEDURE set_batch_status

Line 2044: l_clr_status DBMS_SQL.VARCHAR2_TABLE;

2040: GROUP BY execution_status;
2041: l_count DBMS_SQL.NUMBER_TABLE;
2042: l_status DBMS_SQL.VARCHAR2_TABLE;
2043: l_clr_count DBMS_SQL.NUMBER_TABLE;
2044: l_clr_status DBMS_SQL.VARCHAR2_TABLE;
2045: l_batch_status VARCHAR2(1) := 'S';
2046:
2047: PROCEDURE set_batch_status
2048: (p_status IN VARCHAR2,

Line 2506: l_customer_site_use_id DBMS_SQL.NUMBER_TABLE;

2502: WHERE interest_batch_id = g_interest_batch_id;
2503:
2504: l_err VARCHAR2(1);
2505: l_test VARCHAR2(1);
2506: l_customer_site_use_id DBMS_SQL.NUMBER_TABLE;
2507: x_num_adj_created NUMBER;
2508: x_num_adj_error NUMBER;
2509: x_return_status VARCHAR2(10);
2510: x_msg_count NUMBER;

Line 3111: x_worker_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

3107: --{HYU Implemetation per worker
3108: PROCEDURE prepare_header_for_worker
3109: (p_interest_batch_id IN NUMBER,
3110: p_max_workers IN NUMBER,
3111: x_worker_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
3112: x_nb_doc_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
3113: x_return_status OUT NOCOPY VARCHAR2)
3114: IS
3115: CURSOR c IS

Line 3112: x_nb_doc_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

3108: PROCEDURE prepare_header_for_worker
3109: (p_interest_batch_id IN NUMBER,
3110: p_max_workers IN NUMBER,
3111: x_worker_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
3112: x_nb_doc_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
3113: x_return_status OUT NOCOPY VARCHAR2)
3114: IS
3115: CURSOR c IS
3116: SELECT worker_num,

Line 3228: l_customer_site_use_id DBMS_SQL.NUMBER_TABLE;

3224: AND process_status <> 'S';
3225:
3226: l_err VARCHAR2(1);
3227: l_test VARCHAR2(1);
3228: l_customer_site_use_id DBMS_SQL.NUMBER_TABLE;
3229: x_num_adj_created NUMBER;
3230: x_num_adj_error NUMBER;
3231: x_return_status VARCHAR2(10);
3232: x_msg_count NUMBER;

Line 3237: x_worker_list DBMS_SQL.NUMBER_TABLE;

3233: x_msg_data VARCHAR2(2000);
3234: l_request_id NUMBER;
3235: l_exec_srs VARCHAR2(1) := 'N';
3236: l_need_wait VARCHAR2(1) := 'N';
3237: x_worker_list DBMS_SQL.NUMBER_TABLE;
3238: x_nb_doc_list DBMS_SQL.NUMBER_TABLE;
3239:
3240: nothing_to_process EXCEPTION;
3241: BEGIN

Line 3238: x_nb_doc_list DBMS_SQL.NUMBER_TABLE;

3234: l_request_id NUMBER;
3235: l_exec_srs VARCHAR2(1) := 'N';
3236: l_need_wait VARCHAR2(1) := 'N';
3237: x_worker_list DBMS_SQL.NUMBER_TABLE;
3238: x_nb_doc_list DBMS_SQL.NUMBER_TABLE;
3239:
3240: nothing_to_process EXCEPTION;
3241: BEGIN
3242: log('create_late_charge_by_worker +');