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

Line 35: customer_trx_line_id DBMS_SQL.NUMBER_TABLE,

31: pg_conc_program_id number;
32:
33: --{BUG#3339072
34: TYPE ctlrec IS RECORD (
35: customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
36: customer_trx_id DBMS_SQL.NUMBER_TABLE,
37: created_by DBMS_SQL.VARCHAR2_TABLE,
38: creation_date DBMS_SQL.DATE_TABLE,
39: last_updated_by DBMS_SQL.VARCHAR2_TABLE,

Line 36: customer_trx_id DBMS_SQL.NUMBER_TABLE,

32:
33: --{BUG#3339072
34: TYPE ctlrec IS RECORD (
35: customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
36: customer_trx_id DBMS_SQL.NUMBER_TABLE,
37: created_by DBMS_SQL.VARCHAR2_TABLE,
38: creation_date DBMS_SQL.DATE_TABLE,
39: last_updated_by DBMS_SQL.VARCHAR2_TABLE,
40: last_update_date DBMS_SQL.DATE_TABLE,

Line 37: created_by DBMS_SQL.VARCHAR2_TABLE,

33: --{BUG#3339072
34: TYPE ctlrec IS RECORD (
35: customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
36: customer_trx_id DBMS_SQL.NUMBER_TABLE,
37: created_by DBMS_SQL.VARCHAR2_TABLE,
38: creation_date DBMS_SQL.DATE_TABLE,
39: last_updated_by DBMS_SQL.VARCHAR2_TABLE,
40: last_update_date DBMS_SQL.DATE_TABLE,
41: last_update_login DBMS_SQL.VARCHAR2_TABLE,

Line 38: creation_date DBMS_SQL.DATE_TABLE,

34: TYPE ctlrec IS RECORD (
35: customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
36: customer_trx_id DBMS_SQL.NUMBER_TABLE,
37: created_by DBMS_SQL.VARCHAR2_TABLE,
38: creation_date DBMS_SQL.DATE_TABLE,
39: last_updated_by DBMS_SQL.VARCHAR2_TABLE,
40: last_update_date DBMS_SQL.DATE_TABLE,
41: last_update_login DBMS_SQL.VARCHAR2_TABLE,
42: line_number DBMS_SQL.NUMBER_TABLE,

Line 39: last_updated_by DBMS_SQL.VARCHAR2_TABLE,

35: customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
36: customer_trx_id DBMS_SQL.NUMBER_TABLE,
37: created_by DBMS_SQL.VARCHAR2_TABLE,
38: creation_date DBMS_SQL.DATE_TABLE,
39: last_updated_by DBMS_SQL.VARCHAR2_TABLE,
40: last_update_date DBMS_SQL.DATE_TABLE,
41: last_update_login DBMS_SQL.VARCHAR2_TABLE,
42: line_number DBMS_SQL.NUMBER_TABLE,
43: line_type DBMS_SQL.VARCHAR2_TABLE,

Line 40: last_update_date DBMS_SQL.DATE_TABLE,

36: customer_trx_id DBMS_SQL.NUMBER_TABLE,
37: created_by DBMS_SQL.VARCHAR2_TABLE,
38: creation_date DBMS_SQL.DATE_TABLE,
39: last_updated_by DBMS_SQL.VARCHAR2_TABLE,
40: last_update_date DBMS_SQL.DATE_TABLE,
41: last_update_login DBMS_SQL.VARCHAR2_TABLE,
42: line_number DBMS_SQL.NUMBER_TABLE,
43: line_type DBMS_SQL.VARCHAR2_TABLE,
44: set_of_books_id DBMS_SQL.NUMBER_TABLE,

Line 41: last_update_login DBMS_SQL.VARCHAR2_TABLE,

37: created_by DBMS_SQL.VARCHAR2_TABLE,
38: creation_date DBMS_SQL.DATE_TABLE,
39: last_updated_by DBMS_SQL.VARCHAR2_TABLE,
40: last_update_date DBMS_SQL.DATE_TABLE,
41: last_update_login DBMS_SQL.VARCHAR2_TABLE,
42: line_number DBMS_SQL.NUMBER_TABLE,
43: line_type DBMS_SQL.VARCHAR2_TABLE,
44: set_of_books_id DBMS_SQL.NUMBER_TABLE,
45: accounting_rule_id DBMS_SQL.NUMBER_TABLE,

Line 42: line_number DBMS_SQL.NUMBER_TABLE,

38: creation_date DBMS_SQL.DATE_TABLE,
39: last_updated_by DBMS_SQL.VARCHAR2_TABLE,
40: last_update_date DBMS_SQL.DATE_TABLE,
41: last_update_login DBMS_SQL.VARCHAR2_TABLE,
42: line_number DBMS_SQL.NUMBER_TABLE,
43: line_type DBMS_SQL.VARCHAR2_TABLE,
44: set_of_books_id DBMS_SQL.NUMBER_TABLE,
45: accounting_rule_id DBMS_SQL.NUMBER_TABLE,
46: autorule_complete_flag DBMS_SQL.VARCHAR2_TABLE,

Line 43: line_type DBMS_SQL.VARCHAR2_TABLE,

39: last_updated_by DBMS_SQL.VARCHAR2_TABLE,
40: last_update_date DBMS_SQL.DATE_TABLE,
41: last_update_login DBMS_SQL.VARCHAR2_TABLE,
42: line_number DBMS_SQL.NUMBER_TABLE,
43: line_type DBMS_SQL.VARCHAR2_TABLE,
44: set_of_books_id DBMS_SQL.NUMBER_TABLE,
45: accounting_rule_id DBMS_SQL.NUMBER_TABLE,
46: autorule_complete_flag DBMS_SQL.VARCHAR2_TABLE,
47: last_period_to_credit DBMS_SQL.NUMBER_TABLE,

Line 44: set_of_books_id DBMS_SQL.NUMBER_TABLE,

40: last_update_date DBMS_SQL.DATE_TABLE,
41: last_update_login DBMS_SQL.VARCHAR2_TABLE,
42: line_number DBMS_SQL.NUMBER_TABLE,
43: line_type DBMS_SQL.VARCHAR2_TABLE,
44: set_of_books_id DBMS_SQL.NUMBER_TABLE,
45: accounting_rule_id DBMS_SQL.NUMBER_TABLE,
46: autorule_complete_flag DBMS_SQL.VARCHAR2_TABLE,
47: last_period_to_credit DBMS_SQL.NUMBER_TABLE,
48: description DBMS_SQL.VARCHAR2_TABLE,

Line 45: accounting_rule_id DBMS_SQL.NUMBER_TABLE,

41: last_update_login DBMS_SQL.VARCHAR2_TABLE,
42: line_number DBMS_SQL.NUMBER_TABLE,
43: line_type DBMS_SQL.VARCHAR2_TABLE,
44: set_of_books_id DBMS_SQL.NUMBER_TABLE,
45: accounting_rule_id DBMS_SQL.NUMBER_TABLE,
46: autorule_complete_flag DBMS_SQL.VARCHAR2_TABLE,
47: last_period_to_credit DBMS_SQL.NUMBER_TABLE,
48: description DBMS_SQL.VARCHAR2_TABLE,
49: initial_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,

Line 46: autorule_complete_flag DBMS_SQL.VARCHAR2_TABLE,

42: line_number DBMS_SQL.NUMBER_TABLE,
43: line_type DBMS_SQL.VARCHAR2_TABLE,
44: set_of_books_id DBMS_SQL.NUMBER_TABLE,
45: accounting_rule_id DBMS_SQL.NUMBER_TABLE,
46: autorule_complete_flag DBMS_SQL.VARCHAR2_TABLE,
47: last_period_to_credit DBMS_SQL.NUMBER_TABLE,
48: description DBMS_SQL.VARCHAR2_TABLE,
49: initial_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
50: inventory_item_id DBMS_SQL.NUMBER_TABLE,

Line 47: last_period_to_credit DBMS_SQL.NUMBER_TABLE,

43: line_type DBMS_SQL.VARCHAR2_TABLE,
44: set_of_books_id DBMS_SQL.NUMBER_TABLE,
45: accounting_rule_id DBMS_SQL.NUMBER_TABLE,
46: autorule_complete_flag DBMS_SQL.VARCHAR2_TABLE,
47: last_period_to_credit DBMS_SQL.NUMBER_TABLE,
48: description DBMS_SQL.VARCHAR2_TABLE,
49: initial_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
50: inventory_item_id DBMS_SQL.NUMBER_TABLE,
51: item_exception_rate_id DBMS_SQL.NUMBER_TABLE,

Line 48: description DBMS_SQL.VARCHAR2_TABLE,

44: set_of_books_id DBMS_SQL.NUMBER_TABLE,
45: accounting_rule_id DBMS_SQL.NUMBER_TABLE,
46: autorule_complete_flag DBMS_SQL.VARCHAR2_TABLE,
47: last_period_to_credit DBMS_SQL.NUMBER_TABLE,
48: description DBMS_SQL.VARCHAR2_TABLE,
49: initial_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
50: inventory_item_id DBMS_SQL.NUMBER_TABLE,
51: item_exception_rate_id DBMS_SQL.NUMBER_TABLE,
52: memo_line_id DBMS_SQL.NUMBER_TABLE,

Line 49: initial_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,

45: accounting_rule_id DBMS_SQL.NUMBER_TABLE,
46: autorule_complete_flag DBMS_SQL.VARCHAR2_TABLE,
47: last_period_to_credit DBMS_SQL.NUMBER_TABLE,
48: description DBMS_SQL.VARCHAR2_TABLE,
49: initial_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
50: inventory_item_id DBMS_SQL.NUMBER_TABLE,
51: item_exception_rate_id DBMS_SQL.NUMBER_TABLE,
52: memo_line_id DBMS_SQL.NUMBER_TABLE,
53: reason_code DBMS_SQL.VARCHAR2_TABLE,

Line 50: inventory_item_id DBMS_SQL.NUMBER_TABLE,

46: autorule_complete_flag DBMS_SQL.VARCHAR2_TABLE,
47: last_period_to_credit DBMS_SQL.NUMBER_TABLE,
48: description DBMS_SQL.VARCHAR2_TABLE,
49: initial_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
50: inventory_item_id DBMS_SQL.NUMBER_TABLE,
51: item_exception_rate_id DBMS_SQL.NUMBER_TABLE,
52: memo_line_id DBMS_SQL.NUMBER_TABLE,
53: reason_code DBMS_SQL.VARCHAR2_TABLE,
54: previous_customer_trx_id DBMS_SQL.NUMBER_TABLE,

Line 51: item_exception_rate_id DBMS_SQL.NUMBER_TABLE,

47: last_period_to_credit DBMS_SQL.NUMBER_TABLE,
48: description DBMS_SQL.VARCHAR2_TABLE,
49: initial_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
50: inventory_item_id DBMS_SQL.NUMBER_TABLE,
51: item_exception_rate_id DBMS_SQL.NUMBER_TABLE,
52: memo_line_id DBMS_SQL.NUMBER_TABLE,
53: reason_code DBMS_SQL.VARCHAR2_TABLE,
54: previous_customer_trx_id DBMS_SQL.NUMBER_TABLE,
55: previous_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,

Line 52: memo_line_id DBMS_SQL.NUMBER_TABLE,

48: description DBMS_SQL.VARCHAR2_TABLE,
49: initial_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
50: inventory_item_id DBMS_SQL.NUMBER_TABLE,
51: item_exception_rate_id DBMS_SQL.NUMBER_TABLE,
52: memo_line_id DBMS_SQL.NUMBER_TABLE,
53: reason_code DBMS_SQL.VARCHAR2_TABLE,
54: previous_customer_trx_id DBMS_SQL.NUMBER_TABLE,
55: previous_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
56: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE,

Line 53: reason_code DBMS_SQL.VARCHAR2_TABLE,

49: initial_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
50: inventory_item_id DBMS_SQL.NUMBER_TABLE,
51: item_exception_rate_id DBMS_SQL.NUMBER_TABLE,
52: memo_line_id DBMS_SQL.NUMBER_TABLE,
53: reason_code DBMS_SQL.VARCHAR2_TABLE,
54: previous_customer_trx_id DBMS_SQL.NUMBER_TABLE,
55: previous_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
56: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE,
57: unit_standard_price DBMS_SQL.NUMBER_TABLE,

Line 54: previous_customer_trx_id DBMS_SQL.NUMBER_TABLE,

50: inventory_item_id DBMS_SQL.NUMBER_TABLE,
51: item_exception_rate_id DBMS_SQL.NUMBER_TABLE,
52: memo_line_id DBMS_SQL.NUMBER_TABLE,
53: reason_code DBMS_SQL.VARCHAR2_TABLE,
54: previous_customer_trx_id DBMS_SQL.NUMBER_TABLE,
55: previous_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
56: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE,
57: unit_standard_price DBMS_SQL.NUMBER_TABLE,
58: unit_selling_price DBMS_SQL.NUMBER_TABLE,

Line 55: previous_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,

51: item_exception_rate_id DBMS_SQL.NUMBER_TABLE,
52: memo_line_id DBMS_SQL.NUMBER_TABLE,
53: reason_code DBMS_SQL.VARCHAR2_TABLE,
54: previous_customer_trx_id DBMS_SQL.NUMBER_TABLE,
55: previous_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
56: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE,
57: unit_standard_price DBMS_SQL.NUMBER_TABLE,
58: unit_selling_price DBMS_SQL.NUMBER_TABLE,
59: gross_unit_selling_price DBMS_SQL.NUMBER_TABLE,-- Bug 7389126 KALYAN

Line 56: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE,

52: memo_line_id DBMS_SQL.NUMBER_TABLE,
53: reason_code DBMS_SQL.VARCHAR2_TABLE,
54: previous_customer_trx_id DBMS_SQL.NUMBER_TABLE,
55: previous_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
56: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE,
57: unit_standard_price DBMS_SQL.NUMBER_TABLE,
58: unit_selling_price DBMS_SQL.NUMBER_TABLE,
59: gross_unit_selling_price DBMS_SQL.NUMBER_TABLE,-- Bug 7389126 KALYAN
60: gross_extended_amount DBMS_SQL.NUMBER_TABLE, -- 6882394

Line 57: unit_standard_price DBMS_SQL.NUMBER_TABLE,

53: reason_code DBMS_SQL.VARCHAR2_TABLE,
54: previous_customer_trx_id DBMS_SQL.NUMBER_TABLE,
55: previous_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
56: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE,
57: unit_standard_price DBMS_SQL.NUMBER_TABLE,
58: unit_selling_price DBMS_SQL.NUMBER_TABLE,
59: gross_unit_selling_price DBMS_SQL.NUMBER_TABLE,-- Bug 7389126 KALYAN
60: gross_extended_amount DBMS_SQL.NUMBER_TABLE, -- 6882394
61: original_extended_amount DBMS_SQL.NUMBER_TABLE,-- 6882394

Line 58: unit_selling_price DBMS_SQL.NUMBER_TABLE,

54: previous_customer_trx_id DBMS_SQL.NUMBER_TABLE,
55: previous_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
56: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE,
57: unit_standard_price DBMS_SQL.NUMBER_TABLE,
58: unit_selling_price DBMS_SQL.NUMBER_TABLE,
59: gross_unit_selling_price DBMS_SQL.NUMBER_TABLE,-- Bug 7389126 KALYAN
60: gross_extended_amount DBMS_SQL.NUMBER_TABLE, -- 6882394
61: original_extended_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
62: original_revenue_amount DBMS_SQL.NUMBER_TABLE,-- 6882394

Line 59: gross_unit_selling_price DBMS_SQL.NUMBER_TABLE,-- Bug 7389126 KALYAN

55: previous_customer_trx_line_id DBMS_SQL.NUMBER_TABLE,
56: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE,
57: unit_standard_price DBMS_SQL.NUMBER_TABLE,
58: unit_selling_price DBMS_SQL.NUMBER_TABLE,
59: gross_unit_selling_price DBMS_SQL.NUMBER_TABLE,-- Bug 7389126 KALYAN
60: gross_extended_amount DBMS_SQL.NUMBER_TABLE, -- 6882394
61: original_extended_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
62: original_revenue_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
63: quantity_credited DBMS_SQL.NUMBER_TABLE,

Line 60: gross_extended_amount DBMS_SQL.NUMBER_TABLE, -- 6882394

56: link_to_cust_trx_line_id DBMS_SQL.NUMBER_TABLE,
57: unit_standard_price DBMS_SQL.NUMBER_TABLE,
58: unit_selling_price DBMS_SQL.NUMBER_TABLE,
59: gross_unit_selling_price DBMS_SQL.NUMBER_TABLE,-- Bug 7389126 KALYAN
60: gross_extended_amount DBMS_SQL.NUMBER_TABLE, -- 6882394
61: original_extended_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
62: original_revenue_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
63: quantity_credited DBMS_SQL.NUMBER_TABLE,
64: quantity_invoiced DBMS_SQL.NUMBER_TABLE, -- Bug 6990227

Line 61: original_extended_amount DBMS_SQL.NUMBER_TABLE,-- 6882394

57: unit_standard_price DBMS_SQL.NUMBER_TABLE,
58: unit_selling_price DBMS_SQL.NUMBER_TABLE,
59: gross_unit_selling_price DBMS_SQL.NUMBER_TABLE,-- Bug 7389126 KALYAN
60: gross_extended_amount DBMS_SQL.NUMBER_TABLE, -- 6882394
61: original_extended_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
62: original_revenue_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
63: quantity_credited DBMS_SQL.NUMBER_TABLE,
64: quantity_invoiced DBMS_SQL.NUMBER_TABLE, -- Bug 6990227
65: extended_amount DBMS_SQL.NUMBER_TABLE,

Line 62: original_revenue_amount DBMS_SQL.NUMBER_TABLE,-- 6882394

58: unit_selling_price DBMS_SQL.NUMBER_TABLE,
59: gross_unit_selling_price DBMS_SQL.NUMBER_TABLE,-- Bug 7389126 KALYAN
60: gross_extended_amount DBMS_SQL.NUMBER_TABLE, -- 6882394
61: original_extended_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
62: original_revenue_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
63: quantity_credited DBMS_SQL.NUMBER_TABLE,
64: quantity_invoiced DBMS_SQL.NUMBER_TABLE, -- Bug 6990227
65: extended_amount DBMS_SQL.NUMBER_TABLE,
66: revenue_amount DBMS_SQL.NUMBER_TABLE,

Line 63: quantity_credited DBMS_SQL.NUMBER_TABLE,

59: gross_unit_selling_price DBMS_SQL.NUMBER_TABLE,-- Bug 7389126 KALYAN
60: gross_extended_amount DBMS_SQL.NUMBER_TABLE, -- 6882394
61: original_extended_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
62: original_revenue_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
63: quantity_credited DBMS_SQL.NUMBER_TABLE,
64: quantity_invoiced DBMS_SQL.NUMBER_TABLE, -- Bug 6990227
65: extended_amount DBMS_SQL.NUMBER_TABLE,
66: revenue_amount DBMS_SQL.NUMBER_TABLE,
67: sales_order DBMS_SQL.VARCHAR2_TABLE,

Line 64: quantity_invoiced DBMS_SQL.NUMBER_TABLE, -- Bug 6990227

60: gross_extended_amount DBMS_SQL.NUMBER_TABLE, -- 6882394
61: original_extended_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
62: original_revenue_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
63: quantity_credited DBMS_SQL.NUMBER_TABLE,
64: quantity_invoiced DBMS_SQL.NUMBER_TABLE, -- Bug 6990227
65: extended_amount DBMS_SQL.NUMBER_TABLE,
66: revenue_amount DBMS_SQL.NUMBER_TABLE,
67: sales_order DBMS_SQL.VARCHAR2_TABLE,
68: sales_order_date DBMS_SQL.DATE_TABLE,

Line 65: extended_amount DBMS_SQL.NUMBER_TABLE,

61: original_extended_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
62: original_revenue_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
63: quantity_credited DBMS_SQL.NUMBER_TABLE,
64: quantity_invoiced DBMS_SQL.NUMBER_TABLE, -- Bug 6990227
65: extended_amount DBMS_SQL.NUMBER_TABLE,
66: revenue_amount DBMS_SQL.NUMBER_TABLE,
67: sales_order DBMS_SQL.VARCHAR2_TABLE,
68: sales_order_date DBMS_SQL.DATE_TABLE,
69: sales_order_line DBMS_SQL.VARCHAR2_TABLE,

Line 66: revenue_amount DBMS_SQL.NUMBER_TABLE,

62: original_revenue_amount DBMS_SQL.NUMBER_TABLE,-- 6882394
63: quantity_credited DBMS_SQL.NUMBER_TABLE,
64: quantity_invoiced DBMS_SQL.NUMBER_TABLE, -- Bug 6990227
65: extended_amount DBMS_SQL.NUMBER_TABLE,
66: revenue_amount DBMS_SQL.NUMBER_TABLE,
67: sales_order DBMS_SQL.VARCHAR2_TABLE,
68: sales_order_date DBMS_SQL.DATE_TABLE,
69: sales_order_line DBMS_SQL.VARCHAR2_TABLE,
70: sales_order_revision DBMS_SQL.NUMBER_TABLE,

Line 67: sales_order DBMS_SQL.VARCHAR2_TABLE,

63: quantity_credited DBMS_SQL.NUMBER_TABLE,
64: quantity_invoiced DBMS_SQL.NUMBER_TABLE, -- Bug 6990227
65: extended_amount DBMS_SQL.NUMBER_TABLE,
66: revenue_amount DBMS_SQL.NUMBER_TABLE,
67: sales_order DBMS_SQL.VARCHAR2_TABLE,
68: sales_order_date DBMS_SQL.DATE_TABLE,
69: sales_order_line DBMS_SQL.VARCHAR2_TABLE,
70: sales_order_revision DBMS_SQL.NUMBER_TABLE,
71: sales_order_source DBMS_SQL.VARCHAR2_TABLE,

Line 68: sales_order_date DBMS_SQL.DATE_TABLE,

64: quantity_invoiced DBMS_SQL.NUMBER_TABLE, -- Bug 6990227
65: extended_amount DBMS_SQL.NUMBER_TABLE,
66: revenue_amount DBMS_SQL.NUMBER_TABLE,
67: sales_order DBMS_SQL.VARCHAR2_TABLE,
68: sales_order_date DBMS_SQL.DATE_TABLE,
69: sales_order_line DBMS_SQL.VARCHAR2_TABLE,
70: sales_order_revision DBMS_SQL.NUMBER_TABLE,
71: sales_order_source DBMS_SQL.VARCHAR2_TABLE,
72: tax_exemption_id DBMS_SQL.NUMBER_TABLE,

Line 69: sales_order_line DBMS_SQL.VARCHAR2_TABLE,

65: extended_amount DBMS_SQL.NUMBER_TABLE,
66: revenue_amount DBMS_SQL.NUMBER_TABLE,
67: sales_order DBMS_SQL.VARCHAR2_TABLE,
68: sales_order_date DBMS_SQL.DATE_TABLE,
69: sales_order_line DBMS_SQL.VARCHAR2_TABLE,
70: sales_order_revision DBMS_SQL.NUMBER_TABLE,
71: sales_order_source DBMS_SQL.VARCHAR2_TABLE,
72: tax_exemption_id DBMS_SQL.NUMBER_TABLE,
73: tax_precedence DBMS_SQL.NUMBER_TABLE,

Line 70: sales_order_revision DBMS_SQL.NUMBER_TABLE,

66: revenue_amount DBMS_SQL.NUMBER_TABLE,
67: sales_order DBMS_SQL.VARCHAR2_TABLE,
68: sales_order_date DBMS_SQL.DATE_TABLE,
69: sales_order_line DBMS_SQL.VARCHAR2_TABLE,
70: sales_order_revision DBMS_SQL.NUMBER_TABLE,
71: sales_order_source DBMS_SQL.VARCHAR2_TABLE,
72: tax_exemption_id DBMS_SQL.NUMBER_TABLE,
73: tax_precedence DBMS_SQL.NUMBER_TABLE,
74: tax_rate DBMS_SQL.NUMBER_TABLE,

Line 71: sales_order_source DBMS_SQL.VARCHAR2_TABLE,

67: sales_order DBMS_SQL.VARCHAR2_TABLE,
68: sales_order_date DBMS_SQL.DATE_TABLE,
69: sales_order_line DBMS_SQL.VARCHAR2_TABLE,
70: sales_order_revision DBMS_SQL.NUMBER_TABLE,
71: sales_order_source DBMS_SQL.VARCHAR2_TABLE,
72: tax_exemption_id DBMS_SQL.NUMBER_TABLE,
73: tax_precedence DBMS_SQL.NUMBER_TABLE,
74: tax_rate DBMS_SQL.NUMBER_TABLE,
75: uom_code DBMS_SQL.VARCHAR2_TABLE,

Line 72: tax_exemption_id DBMS_SQL.NUMBER_TABLE,

68: sales_order_date DBMS_SQL.DATE_TABLE,
69: sales_order_line DBMS_SQL.VARCHAR2_TABLE,
70: sales_order_revision DBMS_SQL.NUMBER_TABLE,
71: sales_order_source DBMS_SQL.VARCHAR2_TABLE,
72: tax_exemption_id DBMS_SQL.NUMBER_TABLE,
73: tax_precedence DBMS_SQL.NUMBER_TABLE,
74: tax_rate DBMS_SQL.NUMBER_TABLE,
75: uom_code DBMS_SQL.VARCHAR2_TABLE,
76: default_ussgl_transaction_code DBMS_SQL.VARCHAR2_TABLE,

Line 73: tax_precedence DBMS_SQL.NUMBER_TABLE,

69: sales_order_line DBMS_SQL.VARCHAR2_TABLE,
70: sales_order_revision DBMS_SQL.NUMBER_TABLE,
71: sales_order_source DBMS_SQL.VARCHAR2_TABLE,
72: tax_exemption_id DBMS_SQL.NUMBER_TABLE,
73: tax_precedence DBMS_SQL.NUMBER_TABLE,
74: tax_rate DBMS_SQL.NUMBER_TABLE,
75: uom_code DBMS_SQL.VARCHAR2_TABLE,
76: default_ussgl_transaction_code DBMS_SQL.VARCHAR2_TABLE,
77: default_ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,

Line 74: tax_rate DBMS_SQL.NUMBER_TABLE,

70: sales_order_revision DBMS_SQL.NUMBER_TABLE,
71: sales_order_source DBMS_SQL.VARCHAR2_TABLE,
72: tax_exemption_id DBMS_SQL.NUMBER_TABLE,
73: tax_precedence DBMS_SQL.NUMBER_TABLE,
74: tax_rate DBMS_SQL.NUMBER_TABLE,
75: uom_code DBMS_SQL.VARCHAR2_TABLE,
76: default_ussgl_transaction_code DBMS_SQL.VARCHAR2_TABLE,
77: default_ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
78: sales_tax_id DBMS_SQL.NUMBER_TABLE,

Line 75: uom_code DBMS_SQL.VARCHAR2_TABLE,

71: sales_order_source DBMS_SQL.VARCHAR2_TABLE,
72: tax_exemption_id DBMS_SQL.NUMBER_TABLE,
73: tax_precedence DBMS_SQL.NUMBER_TABLE,
74: tax_rate DBMS_SQL.NUMBER_TABLE,
75: uom_code DBMS_SQL.VARCHAR2_TABLE,
76: default_ussgl_transaction_code DBMS_SQL.VARCHAR2_TABLE,
77: default_ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
78: sales_tax_id DBMS_SQL.NUMBER_TABLE,
79: location_segment_id DBMS_SQL.NUMBER_TABLE,

Line 76: default_ussgl_transaction_code DBMS_SQL.VARCHAR2_TABLE,

72: tax_exemption_id DBMS_SQL.NUMBER_TABLE,
73: tax_precedence DBMS_SQL.NUMBER_TABLE,
74: tax_rate DBMS_SQL.NUMBER_TABLE,
75: uom_code DBMS_SQL.VARCHAR2_TABLE,
76: default_ussgl_transaction_code DBMS_SQL.VARCHAR2_TABLE,
77: default_ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
78: sales_tax_id DBMS_SQL.NUMBER_TABLE,
79: location_segment_id DBMS_SQL.NUMBER_TABLE,
80: vat_tax_id DBMS_SQL.NUMBER_TABLE,

Line 77: default_ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,

73: tax_precedence DBMS_SQL.NUMBER_TABLE,
74: tax_rate DBMS_SQL.NUMBER_TABLE,
75: uom_code DBMS_SQL.VARCHAR2_TABLE,
76: default_ussgl_transaction_code DBMS_SQL.VARCHAR2_TABLE,
77: default_ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
78: sales_tax_id DBMS_SQL.NUMBER_TABLE,
79: location_segment_id DBMS_SQL.NUMBER_TABLE,
80: vat_tax_id DBMS_SQL.NUMBER_TABLE,
81: amount_includes_tax_flag DBMS_SQL.VARCHAR2_TABLE,

Line 78: sales_tax_id DBMS_SQL.NUMBER_TABLE,

74: tax_rate DBMS_SQL.NUMBER_TABLE,
75: uom_code DBMS_SQL.VARCHAR2_TABLE,
76: default_ussgl_transaction_code DBMS_SQL.VARCHAR2_TABLE,
77: default_ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
78: sales_tax_id DBMS_SQL.NUMBER_TABLE,
79: location_segment_id DBMS_SQL.NUMBER_TABLE,
80: vat_tax_id DBMS_SQL.NUMBER_TABLE,
81: amount_includes_tax_flag DBMS_SQL.VARCHAR2_TABLE,
82: warehouse_id DBMS_SQL.NUMBER_TABLE,

Line 79: location_segment_id DBMS_SQL.NUMBER_TABLE,

75: uom_code DBMS_SQL.VARCHAR2_TABLE,
76: default_ussgl_transaction_code DBMS_SQL.VARCHAR2_TABLE,
77: default_ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
78: sales_tax_id DBMS_SQL.NUMBER_TABLE,
79: location_segment_id DBMS_SQL.NUMBER_TABLE,
80: vat_tax_id DBMS_SQL.NUMBER_TABLE,
81: amount_includes_tax_flag DBMS_SQL.VARCHAR2_TABLE,
82: warehouse_id DBMS_SQL.NUMBER_TABLE,
83: taxable_amount DBMS_SQL.NUMBER_TABLE,

Line 80: vat_tax_id DBMS_SQL.NUMBER_TABLE,

76: default_ussgl_transaction_code DBMS_SQL.VARCHAR2_TABLE,
77: default_ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
78: sales_tax_id DBMS_SQL.NUMBER_TABLE,
79: location_segment_id DBMS_SQL.NUMBER_TABLE,
80: vat_tax_id DBMS_SQL.NUMBER_TABLE,
81: amount_includes_tax_flag DBMS_SQL.VARCHAR2_TABLE,
82: warehouse_id DBMS_SQL.NUMBER_TABLE,
83: taxable_amount DBMS_SQL.NUMBER_TABLE,
84: translated_description DBMS_SQL.VARCHAR2_TABLE,

Line 81: amount_includes_tax_flag DBMS_SQL.VARCHAR2_TABLE,

77: default_ussgl_trx_code_context DBMS_SQL.VARCHAR2_TABLE,
78: sales_tax_id DBMS_SQL.NUMBER_TABLE,
79: location_segment_id DBMS_SQL.NUMBER_TABLE,
80: vat_tax_id DBMS_SQL.NUMBER_TABLE,
81: amount_includes_tax_flag DBMS_SQL.VARCHAR2_TABLE,
82: warehouse_id DBMS_SQL.NUMBER_TABLE,
83: taxable_amount DBMS_SQL.NUMBER_TABLE,
84: translated_description DBMS_SQL.VARCHAR2_TABLE,
85: org_id DBMS_SQL.NUMBER_TABLE,

Line 82: warehouse_id DBMS_SQL.NUMBER_TABLE,

78: sales_tax_id DBMS_SQL.NUMBER_TABLE,
79: location_segment_id DBMS_SQL.NUMBER_TABLE,
80: vat_tax_id DBMS_SQL.NUMBER_TABLE,
81: amount_includes_tax_flag DBMS_SQL.VARCHAR2_TABLE,
82: warehouse_id DBMS_SQL.NUMBER_TABLE,
83: taxable_amount DBMS_SQL.NUMBER_TABLE,
84: translated_description DBMS_SQL.VARCHAR2_TABLE,
85: org_id DBMS_SQL.NUMBER_TABLE,
86: ship_to_customer_id DBMS_SQL.NUMBER_TABLE,

Line 83: taxable_amount DBMS_SQL.NUMBER_TABLE,

79: location_segment_id DBMS_SQL.NUMBER_TABLE,
80: vat_tax_id DBMS_SQL.NUMBER_TABLE,
81: amount_includes_tax_flag DBMS_SQL.VARCHAR2_TABLE,
82: warehouse_id DBMS_SQL.NUMBER_TABLE,
83: taxable_amount DBMS_SQL.NUMBER_TABLE,
84: translated_description DBMS_SQL.VARCHAR2_TABLE,
85: org_id DBMS_SQL.NUMBER_TABLE,
86: ship_to_customer_id DBMS_SQL.NUMBER_TABLE,
87: ship_to_address_id DBMS_SQL.NUMBER_TABLE,

Line 84: translated_description DBMS_SQL.VARCHAR2_TABLE,

80: vat_tax_id DBMS_SQL.NUMBER_TABLE,
81: amount_includes_tax_flag DBMS_SQL.VARCHAR2_TABLE,
82: warehouse_id DBMS_SQL.NUMBER_TABLE,
83: taxable_amount DBMS_SQL.NUMBER_TABLE,
84: translated_description DBMS_SQL.VARCHAR2_TABLE,
85: org_id DBMS_SQL.NUMBER_TABLE,
86: ship_to_customer_id DBMS_SQL.NUMBER_TABLE,
87: ship_to_address_id DBMS_SQL.NUMBER_TABLE,
88: ship_to_site_use_id DBMS_SQL.NUMBER_TABLE,

Line 85: org_id DBMS_SQL.NUMBER_TABLE,

81: amount_includes_tax_flag DBMS_SQL.VARCHAR2_TABLE,
82: warehouse_id DBMS_SQL.NUMBER_TABLE,
83: taxable_amount DBMS_SQL.NUMBER_TABLE,
84: translated_description DBMS_SQL.VARCHAR2_TABLE,
85: org_id DBMS_SQL.NUMBER_TABLE,
86: ship_to_customer_id DBMS_SQL.NUMBER_TABLE,
87: ship_to_address_id DBMS_SQL.NUMBER_TABLE,
88: ship_to_site_use_id DBMS_SQL.NUMBER_TABLE,
89: ship_to_contact_id DBMS_SQL.NUMBER_TABLE,

Line 86: ship_to_customer_id DBMS_SQL.NUMBER_TABLE,

82: warehouse_id DBMS_SQL.NUMBER_TABLE,
83: taxable_amount DBMS_SQL.NUMBER_TABLE,
84: translated_description DBMS_SQL.VARCHAR2_TABLE,
85: org_id DBMS_SQL.NUMBER_TABLE,
86: ship_to_customer_id DBMS_SQL.NUMBER_TABLE,
87: ship_to_address_id DBMS_SQL.NUMBER_TABLE,
88: ship_to_site_use_id DBMS_SQL.NUMBER_TABLE,
89: ship_to_contact_id DBMS_SQL.NUMBER_TABLE,
90: tax_classification_code DBMS_SQL.VARCHAR2_TABLE,

Line 87: ship_to_address_id DBMS_SQL.NUMBER_TABLE,

83: taxable_amount DBMS_SQL.NUMBER_TABLE,
84: translated_description DBMS_SQL.VARCHAR2_TABLE,
85: org_id DBMS_SQL.NUMBER_TABLE,
86: ship_to_customer_id DBMS_SQL.NUMBER_TABLE,
87: ship_to_address_id DBMS_SQL.NUMBER_TABLE,
88: ship_to_site_use_id DBMS_SQL.NUMBER_TABLE,
89: ship_to_contact_id DBMS_SQL.NUMBER_TABLE,
90: tax_classification_code DBMS_SQL.VARCHAR2_TABLE,
91: historical_flag DBMS_SQL.VARCHAR2_TABLE,

Line 88: ship_to_site_use_id DBMS_SQL.NUMBER_TABLE,

84: translated_description DBMS_SQL.VARCHAR2_TABLE,
85: org_id DBMS_SQL.NUMBER_TABLE,
86: ship_to_customer_id DBMS_SQL.NUMBER_TABLE,
87: ship_to_address_id DBMS_SQL.NUMBER_TABLE,
88: ship_to_site_use_id DBMS_SQL.NUMBER_TABLE,
89: ship_to_contact_id DBMS_SQL.NUMBER_TABLE,
90: tax_classification_code DBMS_SQL.VARCHAR2_TABLE,
91: historical_flag DBMS_SQL.VARCHAR2_TABLE,
92: memo_line_type DBMS_SQL.VARCHAR2_TABLE);

Line 89: ship_to_contact_id DBMS_SQL.NUMBER_TABLE,

85: org_id DBMS_SQL.NUMBER_TABLE,
86: ship_to_customer_id DBMS_SQL.NUMBER_TABLE,
87: ship_to_address_id DBMS_SQL.NUMBER_TABLE,
88: ship_to_site_use_id DBMS_SQL.NUMBER_TABLE,
89: ship_to_contact_id DBMS_SQL.NUMBER_TABLE,
90: tax_classification_code DBMS_SQL.VARCHAR2_TABLE,
91: historical_flag DBMS_SQL.VARCHAR2_TABLE,
92: memo_line_type DBMS_SQL.VARCHAR2_TABLE);
93: --}

Line 90: tax_classification_code DBMS_SQL.VARCHAR2_TABLE,

86: ship_to_customer_id DBMS_SQL.NUMBER_TABLE,
87: ship_to_address_id DBMS_SQL.NUMBER_TABLE,
88: ship_to_site_use_id DBMS_SQL.NUMBER_TABLE,
89: ship_to_contact_id DBMS_SQL.NUMBER_TABLE,
90: tax_classification_code DBMS_SQL.VARCHAR2_TABLE,
91: historical_flag DBMS_SQL.VARCHAR2_TABLE,
92: memo_line_type DBMS_SQL.VARCHAR2_TABLE);
93: --}
94: /*===========================================================================+

Line 91: historical_flag DBMS_SQL.VARCHAR2_TABLE,

87: ship_to_address_id DBMS_SQL.NUMBER_TABLE,
88: ship_to_site_use_id DBMS_SQL.NUMBER_TABLE,
89: ship_to_contact_id DBMS_SQL.NUMBER_TABLE,
90: tax_classification_code DBMS_SQL.VARCHAR2_TABLE,
91: historical_flag DBMS_SQL.VARCHAR2_TABLE,
92: memo_line_type DBMS_SQL.VARCHAR2_TABLE);
93: --}
94: /*===========================================================================+
95: | FUNCTION |

Line 92: memo_line_type DBMS_SQL.VARCHAR2_TABLE);

88: ship_to_site_use_id DBMS_SQL.NUMBER_TABLE,
89: ship_to_contact_id DBMS_SQL.NUMBER_TABLE,
90: tax_classification_code DBMS_SQL.VARCHAR2_TABLE,
91: historical_flag DBMS_SQL.VARCHAR2_TABLE,
92: memo_line_type DBMS_SQL.VARCHAR2_TABLE);
93: --}
94: /*===========================================================================+
95: | FUNCTION |
96: | calculate_prorated_tax_amount |

Line 248: | dbms_sql.bind_variable |

244: | |
245: | SCOPE - PRIVATE |
246: | |
247: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
248: | dbms_sql.bind_variable |
249: | arp_util.debug |
250: | |
251: | ARGUMENTS : IN: |
252: | p_update_cursor - ID of the update cursor |

Line 305: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',

301: /*------------------+
302: | Dummy constants |
303: +------------------*/
304:
305: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
306: AR_TEXT_DUMMY);
307:
308: dbms_sql.bind_variable(p_update_cursor, ':ar_text3_dummy',
309: AR_TEXT3_DUMMY);

Line 308: dbms_sql.bind_variable(p_update_cursor, ':ar_text3_dummy',

304:
305: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
306: AR_TEXT_DUMMY);
307:
308: dbms_sql.bind_variable(p_update_cursor, ':ar_text3_dummy',
309: AR_TEXT3_DUMMY);
310:
311: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
312: AR_FLAG_DUMMY);

Line 311: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',

307:
308: dbms_sql.bind_variable(p_update_cursor, ':ar_text3_dummy',
309: AR_TEXT3_DUMMY);
310:
311: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
312: AR_FLAG_DUMMY);
313:
314: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
315: AR_NUMBER_DUMMY);

Line 314: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',

310:
311: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
312: AR_FLAG_DUMMY);
313:
314: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
315: AR_NUMBER_DUMMY);
316:
317: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
318: AR_DATE_DUMMY);

Line 317: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',

313:
314: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
315: AR_NUMBER_DUMMY);
316:
317: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
318: AR_DATE_DUMMY);
319:
320: /*------------------+
321: | WHO variables |

Line 324: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',

320: /*------------------+
321: | WHO variables |
322: +------------------*/
323:
324: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
325: pg_user_id);
326:
327: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
328: pg_login_id);

Line 327: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',

323:
324: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
325: pg_user_id);
326:
327: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
328: pg_login_id);
329:
330: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
331: pg_conc_login_id);

Line 330: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',

326:
327: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
328: pg_login_id);
329:
330: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
331: pg_conc_login_id);
332:
333:
334: /*----------------------------------------------+

Line 339: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',

335: | Bind variables for all columns in the table |
336: +----------------------------------------------*/
337:
338:
339: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
340: p_line_rec.customer_trx_line_id);
341:
342: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
343: p_line_rec.customer_trx_id);

Line 342: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',

338:
339: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
340: p_line_rec.customer_trx_line_id);
341:
342: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
343: p_line_rec.customer_trx_id);
344:
345: dbms_sql.bind_variable(p_update_cursor, ':line_number',
346: p_line_rec.line_number);

Line 345: dbms_sql.bind_variable(p_update_cursor, ':line_number',

341:
342: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
343: p_line_rec.customer_trx_id);
344:
345: dbms_sql.bind_variable(p_update_cursor, ':line_number',
346: p_line_rec.line_number);
347:
348: dbms_sql.bind_variable(p_update_cursor, ':line_type',
349: p_line_rec.line_type);

Line 348: dbms_sql.bind_variable(p_update_cursor, ':line_type',

344:
345: dbms_sql.bind_variable(p_update_cursor, ':line_number',
346: p_line_rec.line_number);
347:
348: dbms_sql.bind_variable(p_update_cursor, ':line_type',
349: p_line_rec.line_type);
350:
351: dbms_sql.bind_variable(p_update_cursor, ':quantity_credited',
352: p_line_rec.quantity_credited);

Line 351: dbms_sql.bind_variable(p_update_cursor, ':quantity_credited',

347:
348: dbms_sql.bind_variable(p_update_cursor, ':line_type',
349: p_line_rec.line_type);
350:
351: dbms_sql.bind_variable(p_update_cursor, ':quantity_credited',
352: p_line_rec.quantity_credited);
353:
354: dbms_sql.bind_variable(p_update_cursor, ':quantity_invoiced',
355: p_line_rec.quantity_invoiced);

Line 354: dbms_sql.bind_variable(p_update_cursor, ':quantity_invoiced',

350:
351: dbms_sql.bind_variable(p_update_cursor, ':quantity_credited',
352: p_line_rec.quantity_credited);
353:
354: dbms_sql.bind_variable(p_update_cursor, ':quantity_invoiced',
355: p_line_rec.quantity_invoiced);
356:
357: dbms_sql.bind_variable(p_update_cursor, ':quantity_ordered',
358: p_line_rec.quantity_ordered);

Line 357: dbms_sql.bind_variable(p_update_cursor, ':quantity_ordered',

353:
354: dbms_sql.bind_variable(p_update_cursor, ':quantity_invoiced',
355: p_line_rec.quantity_invoiced);
356:
357: dbms_sql.bind_variable(p_update_cursor, ':quantity_ordered',
358: p_line_rec.quantity_ordered);
359:
360: dbms_sql.bind_variable(p_update_cursor, ':unit_selling_price',
361: p_line_rec.unit_selling_price);

Line 360: dbms_sql.bind_variable(p_update_cursor, ':unit_selling_price',

356:
357: dbms_sql.bind_variable(p_update_cursor, ':quantity_ordered',
358: p_line_rec.quantity_ordered);
359:
360: dbms_sql.bind_variable(p_update_cursor, ':unit_selling_price',
361: p_line_rec.unit_selling_price);
362:
363: dbms_sql.bind_variable(p_update_cursor, ':unit_standard_price',
364: p_line_rec.unit_standard_price);

Line 363: dbms_sql.bind_variable(p_update_cursor, ':unit_standard_price',

359:
360: dbms_sql.bind_variable(p_update_cursor, ':unit_selling_price',
361: p_line_rec.unit_selling_price);
362:
363: dbms_sql.bind_variable(p_update_cursor, ':unit_standard_price',
364: p_line_rec.unit_standard_price);
365:
366: dbms_sql.bind_variable(p_update_cursor, ':revenue_amount',
367: p_line_rec.revenue_amount);

Line 366: dbms_sql.bind_variable(p_update_cursor, ':revenue_amount',

362:
363: dbms_sql.bind_variable(p_update_cursor, ':unit_standard_price',
364: p_line_rec.unit_standard_price);
365:
366: dbms_sql.bind_variable(p_update_cursor, ':revenue_amount',
367: p_line_rec.revenue_amount);
368:
369: dbms_sql.bind_variable(p_update_cursor, ':extended_amount',
370: p_line_rec.extended_amount);

Line 369: dbms_sql.bind_variable(p_update_cursor, ':extended_amount',

365:
366: dbms_sql.bind_variable(p_update_cursor, ':revenue_amount',
367: p_line_rec.revenue_amount);
368:
369: dbms_sql.bind_variable(p_update_cursor, ':extended_amount',
370: p_line_rec.extended_amount);
371:
372: dbms_sql.bind_variable(p_update_cursor, ':memo_line_id',
373: p_line_rec.memo_line_id);

Line 372: dbms_sql.bind_variable(p_update_cursor, ':memo_line_id',

368:
369: dbms_sql.bind_variable(p_update_cursor, ':extended_amount',
370: p_line_rec.extended_amount);
371:
372: dbms_sql.bind_variable(p_update_cursor, ':memo_line_id',
373: p_line_rec.memo_line_id);
374:
375: dbms_sql.bind_variable(p_update_cursor, ':inventory_item_id',
376: p_line_rec.inventory_item_id);

Line 375: dbms_sql.bind_variable(p_update_cursor, ':inventory_item_id',

371:
372: dbms_sql.bind_variable(p_update_cursor, ':memo_line_id',
373: p_line_rec.memo_line_id);
374:
375: dbms_sql.bind_variable(p_update_cursor, ':inventory_item_id',
376: p_line_rec.inventory_item_id);
377:
378: dbms_sql.bind_variable(p_update_cursor, ':item_exception_rate_id',
379: p_line_rec.item_exception_rate_id);

Line 378: dbms_sql.bind_variable(p_update_cursor, ':item_exception_rate_id',

374:
375: dbms_sql.bind_variable(p_update_cursor, ':inventory_item_id',
376: p_line_rec.inventory_item_id);
377:
378: dbms_sql.bind_variable(p_update_cursor, ':item_exception_rate_id',
379: p_line_rec.item_exception_rate_id);
380:
381: dbms_sql.bind_variable(p_update_cursor, ':description',
382: p_line_rec.description);

Line 381: dbms_sql.bind_variable(p_update_cursor, ':description',

377:
378: dbms_sql.bind_variable(p_update_cursor, ':item_exception_rate_id',
379: p_line_rec.item_exception_rate_id);
380:
381: dbms_sql.bind_variable(p_update_cursor, ':description',
382: p_line_rec.description);
383:
384: dbms_sql.bind_variable(p_update_cursor, ':item_context',
385: p_line_rec.item_context);

Line 384: dbms_sql.bind_variable(p_update_cursor, ':item_context',

380:
381: dbms_sql.bind_variable(p_update_cursor, ':description',
382: p_line_rec.description);
383:
384: dbms_sql.bind_variable(p_update_cursor, ':item_context',
385: p_line_rec.item_context);
386:
387: dbms_sql.bind_variable(p_update_cursor, ':initial_customer_trx_line_id',
388: p_line_rec.initial_customer_trx_line_id);

Line 387: dbms_sql.bind_variable(p_update_cursor, ':initial_customer_trx_line_id',

383:
384: dbms_sql.bind_variable(p_update_cursor, ':item_context',
385: p_line_rec.item_context);
386:
387: dbms_sql.bind_variable(p_update_cursor, ':initial_customer_trx_line_id',
388: p_line_rec.initial_customer_trx_line_id);
389:
390: dbms_sql.bind_variable(p_update_cursor, ':link_to_cust_trx_line_id',
391: p_line_rec.link_to_cust_trx_line_id);

Line 390: dbms_sql.bind_variable(p_update_cursor, ':link_to_cust_trx_line_id',

386:
387: dbms_sql.bind_variable(p_update_cursor, ':initial_customer_trx_line_id',
388: p_line_rec.initial_customer_trx_line_id);
389:
390: dbms_sql.bind_variable(p_update_cursor, ':link_to_cust_trx_line_id',
391: p_line_rec.link_to_cust_trx_line_id);
392:
393: dbms_sql.bind_variable(p_update_cursor, ':previous_customer_trx_id',
394: p_line_rec.previous_customer_trx_id);

Line 393: dbms_sql.bind_variable(p_update_cursor, ':previous_customer_trx_id',

389:
390: dbms_sql.bind_variable(p_update_cursor, ':link_to_cust_trx_line_id',
391: p_line_rec.link_to_cust_trx_line_id);
392:
393: dbms_sql.bind_variable(p_update_cursor, ':previous_customer_trx_id',
394: p_line_rec.previous_customer_trx_id);
395:
396: dbms_sql.bind_variable(p_update_cursor, ':previous_customer_trx_line_id',
397: p_line_rec.previous_customer_trx_line_id);

Line 396: dbms_sql.bind_variable(p_update_cursor, ':previous_customer_trx_line_id',

392:
393: dbms_sql.bind_variable(p_update_cursor, ':previous_customer_trx_id',
394: p_line_rec.previous_customer_trx_id);
395:
396: dbms_sql.bind_variable(p_update_cursor, ':previous_customer_trx_line_id',
397: p_line_rec.previous_customer_trx_line_id);
398:
399: dbms_sql.bind_variable(p_update_cursor, ':accounting_rule_duration',
400: p_line_rec.accounting_rule_duration);

Line 399: dbms_sql.bind_variable(p_update_cursor, ':accounting_rule_duration',

395:
396: dbms_sql.bind_variable(p_update_cursor, ':previous_customer_trx_line_id',
397: p_line_rec.previous_customer_trx_line_id);
398:
399: dbms_sql.bind_variable(p_update_cursor, ':accounting_rule_duration',
400: p_line_rec.accounting_rule_duration);
401:
402: dbms_sql.bind_variable(p_update_cursor, ':accounting_rule_id',
403: p_line_rec.accounting_rule_id);

Line 402: dbms_sql.bind_variable(p_update_cursor, ':accounting_rule_id',

398:
399: dbms_sql.bind_variable(p_update_cursor, ':accounting_rule_duration',
400: p_line_rec.accounting_rule_duration);
401:
402: dbms_sql.bind_variable(p_update_cursor, ':accounting_rule_id',
403: p_line_rec.accounting_rule_id);
404:
405: dbms_sql.bind_variable(p_update_cursor, ':rule_start_date',
406: p_line_rec.rule_start_date);

Line 405: dbms_sql.bind_variable(p_update_cursor, ':rule_start_date',

401:
402: dbms_sql.bind_variable(p_update_cursor, ':accounting_rule_id',
403: p_line_rec.accounting_rule_id);
404:
405: dbms_sql.bind_variable(p_update_cursor, ':rule_start_date',
406: p_line_rec.rule_start_date);
407:
408: dbms_sql.bind_variable(p_update_cursor, ':autorule_complete_flag',
409: p_line_rec.autorule_complete_flag);

Line 408: dbms_sql.bind_variable(p_update_cursor, ':autorule_complete_flag',

404:
405: dbms_sql.bind_variable(p_update_cursor, ':rule_start_date',
406: p_line_rec.rule_start_date);
407:
408: dbms_sql.bind_variable(p_update_cursor, ':autorule_complete_flag',
409: p_line_rec.autorule_complete_flag);
410:
411: dbms_sql.bind_variable(p_update_cursor, ':autorule_duration_processed',
412: p_line_rec.autorule_duration_processed);

Line 411: dbms_sql.bind_variable(p_update_cursor, ':autorule_duration_processed',

407:
408: dbms_sql.bind_variable(p_update_cursor, ':autorule_complete_flag',
409: p_line_rec.autorule_complete_flag);
410:
411: dbms_sql.bind_variable(p_update_cursor, ':autorule_duration_processed',
412: p_line_rec.autorule_duration_processed);
413:
414: dbms_sql.bind_variable(p_update_cursor, ':reason_code',
415: p_line_rec.reason_code);

Line 414: dbms_sql.bind_variable(p_update_cursor, ':reason_code',

410:
411: dbms_sql.bind_variable(p_update_cursor, ':autorule_duration_processed',
412: p_line_rec.autorule_duration_processed);
413:
414: dbms_sql.bind_variable(p_update_cursor, ':reason_code',
415: p_line_rec.reason_code);
416:
417: dbms_sql.bind_variable(p_update_cursor, ':last_period_to_credit',
418: p_line_rec.last_period_to_credit);

Line 417: dbms_sql.bind_variable(p_update_cursor, ':last_period_to_credit',

413:
414: dbms_sql.bind_variable(p_update_cursor, ':reason_code',
415: p_line_rec.reason_code);
416:
417: dbms_sql.bind_variable(p_update_cursor, ':last_period_to_credit',
418: p_line_rec.last_period_to_credit);
419:
420: dbms_sql.bind_variable(p_update_cursor, ':sales_order',
421: p_line_rec.sales_order);

Line 420: dbms_sql.bind_variable(p_update_cursor, ':sales_order',

416:
417: dbms_sql.bind_variable(p_update_cursor, ':last_period_to_credit',
418: p_line_rec.last_period_to_credit);
419:
420: dbms_sql.bind_variable(p_update_cursor, ':sales_order',
421: p_line_rec.sales_order);
422:
423: dbms_sql.bind_variable(p_update_cursor, ':sales_order_date',
424: p_line_rec.sales_order_date);

Line 423: dbms_sql.bind_variable(p_update_cursor, ':sales_order_date',

419:
420: dbms_sql.bind_variable(p_update_cursor, ':sales_order',
421: p_line_rec.sales_order);
422:
423: dbms_sql.bind_variable(p_update_cursor, ':sales_order_date',
424: p_line_rec.sales_order_date);
425:
426: dbms_sql.bind_variable(p_update_cursor, ':sales_order_line',
427: p_line_rec.sales_order_line);

Line 426: dbms_sql.bind_variable(p_update_cursor, ':sales_order_line',

422:
423: dbms_sql.bind_variable(p_update_cursor, ':sales_order_date',
424: p_line_rec.sales_order_date);
425:
426: dbms_sql.bind_variable(p_update_cursor, ':sales_order_line',
427: p_line_rec.sales_order_line);
428:
429: dbms_sql.bind_variable(p_update_cursor, ':sales_order_revision',
430: p_line_rec.sales_order_revision);

Line 429: dbms_sql.bind_variable(p_update_cursor, ':sales_order_revision',

425:
426: dbms_sql.bind_variable(p_update_cursor, ':sales_order_line',
427: p_line_rec.sales_order_line);
428:
429: dbms_sql.bind_variable(p_update_cursor, ':sales_order_revision',
430: p_line_rec.sales_order_revision);
431:
432: dbms_sql.bind_variable(p_update_cursor, ':sales_order_source',
433: p_line_rec.sales_order_source);

Line 432: dbms_sql.bind_variable(p_update_cursor, ':sales_order_source',

428:
429: dbms_sql.bind_variable(p_update_cursor, ':sales_order_revision',
430: p_line_rec.sales_order_revision);
431:
432: dbms_sql.bind_variable(p_update_cursor, ':sales_order_source',
433: p_line_rec.sales_order_source);
434:
435: dbms_sql.bind_variable(p_update_cursor, ':vat_tax_id',
436: p_line_rec.vat_tax_id);

Line 435: dbms_sql.bind_variable(p_update_cursor, ':vat_tax_id',

431:
432: dbms_sql.bind_variable(p_update_cursor, ':sales_order_source',
433: p_line_rec.sales_order_source);
434:
435: dbms_sql.bind_variable(p_update_cursor, ':vat_tax_id',
436: p_line_rec.vat_tax_id);
437:
438: dbms_sql.bind_variable(p_update_cursor, ':tax_exempt_flag',
439: p_line_rec.tax_exempt_flag);

Line 438: dbms_sql.bind_variable(p_update_cursor, ':tax_exempt_flag',

434:
435: dbms_sql.bind_variable(p_update_cursor, ':vat_tax_id',
436: p_line_rec.vat_tax_id);
437:
438: dbms_sql.bind_variable(p_update_cursor, ':tax_exempt_flag',
439: p_line_rec.tax_exempt_flag);
440:
441: dbms_sql.bind_variable(p_update_cursor, ':sales_tax_id',
442: p_line_rec.sales_tax_id);

Line 441: dbms_sql.bind_variable(p_update_cursor, ':sales_tax_id',

437:
438: dbms_sql.bind_variable(p_update_cursor, ':tax_exempt_flag',
439: p_line_rec.tax_exempt_flag);
440:
441: dbms_sql.bind_variable(p_update_cursor, ':sales_tax_id',
442: p_line_rec.sales_tax_id);
443:
444: dbms_sql.bind_variable(p_update_cursor, ':location_segment_id',
445: p_line_rec.location_segment_id);

Line 444: dbms_sql.bind_variable(p_update_cursor, ':location_segment_id',

440:
441: dbms_sql.bind_variable(p_update_cursor, ':sales_tax_id',
442: p_line_rec.sales_tax_id);
443:
444: dbms_sql.bind_variable(p_update_cursor, ':location_segment_id',
445: p_line_rec.location_segment_id);
446:
447: dbms_sql.bind_variable(p_update_cursor, ':tax_exempt_number',
448: p_line_rec.tax_exempt_number);

Line 447: dbms_sql.bind_variable(p_update_cursor, ':tax_exempt_number',

443:
444: dbms_sql.bind_variable(p_update_cursor, ':location_segment_id',
445: p_line_rec.location_segment_id);
446:
447: dbms_sql.bind_variable(p_update_cursor, ':tax_exempt_number',
448: p_line_rec.tax_exempt_number);
449:
450: dbms_sql.bind_variable(p_update_cursor, ':tax_exempt_reason_code',
451: p_line_rec.tax_exempt_reason_code);

Line 450: dbms_sql.bind_variable(p_update_cursor, ':tax_exempt_reason_code',

446:
447: dbms_sql.bind_variable(p_update_cursor, ':tax_exempt_number',
448: p_line_rec.tax_exempt_number);
449:
450: dbms_sql.bind_variable(p_update_cursor, ':tax_exempt_reason_code',
451: p_line_rec.tax_exempt_reason_code);
452:
453: dbms_sql.bind_variable(p_update_cursor, ':tax_vendor_return_code',
454: p_line_rec.tax_vendor_return_code);

Line 453: dbms_sql.bind_variable(p_update_cursor, ':tax_vendor_return_code',

449:
450: dbms_sql.bind_variable(p_update_cursor, ':tax_exempt_reason_code',
451: p_line_rec.tax_exempt_reason_code);
452:
453: dbms_sql.bind_variable(p_update_cursor, ':tax_vendor_return_code',
454: p_line_rec.tax_vendor_return_code);
455:
456: dbms_sql.bind_variable(p_update_cursor, ':taxable_flag',
457: p_line_rec.taxable_flag);

Line 456: dbms_sql.bind_variable(p_update_cursor, ':taxable_flag',

452:
453: dbms_sql.bind_variable(p_update_cursor, ':tax_vendor_return_code',
454: p_line_rec.tax_vendor_return_code);
455:
456: dbms_sql.bind_variable(p_update_cursor, ':taxable_flag',
457: p_line_rec.taxable_flag);
458:
459: dbms_sql.bind_variable(p_update_cursor, ':tax_exemption_id',
460: p_line_rec.tax_exemption_id);

Line 459: dbms_sql.bind_variable(p_update_cursor, ':tax_exemption_id',

455:
456: dbms_sql.bind_variable(p_update_cursor, ':taxable_flag',
457: p_line_rec.taxable_flag);
458:
459: dbms_sql.bind_variable(p_update_cursor, ':tax_exemption_id',
460: p_line_rec.tax_exemption_id);
461:
462: dbms_sql.bind_variable(p_update_cursor, ':tax_precedence',
463: p_line_rec.tax_precedence);

Line 462: dbms_sql.bind_variable(p_update_cursor, ':tax_precedence',

458:
459: dbms_sql.bind_variable(p_update_cursor, ':tax_exemption_id',
460: p_line_rec.tax_exemption_id);
461:
462: dbms_sql.bind_variable(p_update_cursor, ':tax_precedence',
463: p_line_rec.tax_precedence);
464:
465: dbms_sql.bind_variable(p_update_cursor, ':tax_rate',
466: p_line_rec.tax_rate);

Line 465: dbms_sql.bind_variable(p_update_cursor, ':tax_rate',

461:
462: dbms_sql.bind_variable(p_update_cursor, ':tax_precedence',
463: p_line_rec.tax_precedence);
464:
465: dbms_sql.bind_variable(p_update_cursor, ':tax_rate',
466: p_line_rec.tax_rate);
467:
468: dbms_sql.bind_variable(p_update_cursor, ':uom_code',
469: p_line_rec.uom_code);

Line 468: dbms_sql.bind_variable(p_update_cursor, ':uom_code',

464:
465: dbms_sql.bind_variable(p_update_cursor, ':tax_rate',
466: p_line_rec.tax_rate);
467:
468: dbms_sql.bind_variable(p_update_cursor, ':uom_code',
469: p_line_rec.uom_code);
470:
471: dbms_sql.bind_variable(p_update_cursor, ':autotax',
472: p_line_rec.autotax);

Line 471: dbms_sql.bind_variable(p_update_cursor, ':autotax',

467:
468: dbms_sql.bind_variable(p_update_cursor, ':uom_code',
469: p_line_rec.uom_code);
470:
471: dbms_sql.bind_variable(p_update_cursor, ':autotax',
472: p_line_rec.autotax);
473:
474: dbms_sql.bind_variable(p_update_cursor, ':movement_id',
475: p_line_rec.movement_id);

Line 474: dbms_sql.bind_variable(p_update_cursor, ':movement_id',

470:
471: dbms_sql.bind_variable(p_update_cursor, ':autotax',
472: p_line_rec.autotax);
473:
474: dbms_sql.bind_variable(p_update_cursor, ':movement_id',
475: p_line_rec.movement_id);
476:
477: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_transaction_code',
478: p_line_rec.default_ussgl_transaction_code);

Line 477: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_transaction_code',

473:
474: dbms_sql.bind_variable(p_update_cursor, ':movement_id',
475: p_line_rec.movement_id);
476:
477: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_transaction_code',
478: p_line_rec.default_ussgl_transaction_code);
479:
480: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_trx_code_context',
481: p_line_rec.default_ussgl_trx_code_context);

Line 480: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_trx_code_context',

476:
477: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_transaction_code',
478: p_line_rec.default_ussgl_transaction_code);
479:
480: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_trx_code_context',
481: p_line_rec.default_ussgl_trx_code_context);
482:
483: dbms_sql.bind_variable(p_update_cursor, ':interface_line_context',
484: p_line_rec.interface_line_context);

Line 483: dbms_sql.bind_variable(p_update_cursor, ':interface_line_context',

479:
480: dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_trx_code_context',
481: p_line_rec.default_ussgl_trx_code_context);
482:
483: dbms_sql.bind_variable(p_update_cursor, ':interface_line_context',
484: p_line_rec.interface_line_context);
485:
486: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute1',
487: p_line_rec.interface_line_attribute1);

Line 486: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute1',

482:
483: dbms_sql.bind_variable(p_update_cursor, ':interface_line_context',
484: p_line_rec.interface_line_context);
485:
486: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute1',
487: p_line_rec.interface_line_attribute1);
488:
489: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute2',
490: p_line_rec.interface_line_attribute2);

Line 489: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute2',

485:
486: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute1',
487: p_line_rec.interface_line_attribute1);
488:
489: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute2',
490: p_line_rec.interface_line_attribute2);
491:
492: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute3',
493: p_line_rec.interface_line_attribute3);

Line 492: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute3',

488:
489: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute2',
490: p_line_rec.interface_line_attribute2);
491:
492: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute3',
493: p_line_rec.interface_line_attribute3);
494:
495: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute4',
496: p_line_rec.interface_line_attribute4);

Line 495: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute4',

491:
492: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute3',
493: p_line_rec.interface_line_attribute3);
494:
495: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute4',
496: p_line_rec.interface_line_attribute4);
497:
498: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute5',
499: p_line_rec.interface_line_attribute5);

Line 498: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute5',

494:
495: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute4',
496: p_line_rec.interface_line_attribute4);
497:
498: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute5',
499: p_line_rec.interface_line_attribute5);
500:
501: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute6',
502: p_line_rec.interface_line_attribute6);

Line 501: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute6',

497:
498: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute5',
499: p_line_rec.interface_line_attribute5);
500:
501: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute6',
502: p_line_rec.interface_line_attribute6);
503:
504: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute7',
505: p_line_rec.interface_line_attribute7);

Line 504: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute7',

500:
501: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute6',
502: p_line_rec.interface_line_attribute6);
503:
504: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute7',
505: p_line_rec.interface_line_attribute7);
506:
507: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute8',
508: p_line_rec.interface_line_attribute8);

Line 507: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute8',

503:
504: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute7',
505: p_line_rec.interface_line_attribute7);
506:
507: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute8',
508: p_line_rec.interface_line_attribute8);
509:
510: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute9',
511: p_line_rec.interface_line_attribute9);

Line 510: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute9',

506:
507: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute8',
508: p_line_rec.interface_line_attribute8);
509:
510: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute9',
511: p_line_rec.interface_line_attribute9);
512:
513: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute10',
514: p_line_rec.interface_line_attribute10);

Line 513: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute10',

509:
510: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute9',
511: p_line_rec.interface_line_attribute9);
512:
513: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute10',
514: p_line_rec.interface_line_attribute10);
515:
516: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute11',
517: p_line_rec.interface_line_attribute11);

Line 516: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute11',

512:
513: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute10',
514: p_line_rec.interface_line_attribute10);
515:
516: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute11',
517: p_line_rec.interface_line_attribute11);
518:
519: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute12',
520: p_line_rec.interface_line_attribute12);

Line 519: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute12',

515:
516: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute11',
517: p_line_rec.interface_line_attribute11);
518:
519: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute12',
520: p_line_rec.interface_line_attribute12);
521:
522: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute13',
523: p_line_rec.interface_line_attribute13);

Line 522: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute13',

518:
519: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute12',
520: p_line_rec.interface_line_attribute12);
521:
522: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute13',
523: p_line_rec.interface_line_attribute13);
524:
525: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute14',
526: p_line_rec.interface_line_attribute14);

Line 525: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute14',

521:
522: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute13',
523: p_line_rec.interface_line_attribute13);
524:
525: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute14',
526: p_line_rec.interface_line_attribute14);
527:
528: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute15',
529: p_line_rec.interface_line_attribute15);

Line 528: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute15',

524:
525: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute14',
526: p_line_rec.interface_line_attribute14);
527:
528: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute15',
529: p_line_rec.interface_line_attribute15);
530:
531: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
532: p_line_rec.attribute_category);

Line 531: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',

527:
528: dbms_sql.bind_variable(p_update_cursor, ':interface_line_attribute15',
529: p_line_rec.interface_line_attribute15);
530:
531: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
532: p_line_rec.attribute_category);
533:
534: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
535: p_line_rec.attribute1);

Line 534: dbms_sql.bind_variable(p_update_cursor, ':attribute1',

530:
531: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
532: p_line_rec.attribute_category);
533:
534: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
535: p_line_rec.attribute1);
536:
537: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
538: p_line_rec.attribute2);

Line 537: dbms_sql.bind_variable(p_update_cursor, ':attribute2',

533:
534: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
535: p_line_rec.attribute1);
536:
537: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
538: p_line_rec.attribute2);
539:
540: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
541: p_line_rec.attribute3);

Line 540: dbms_sql.bind_variable(p_update_cursor, ':attribute3',

536:
537: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
538: p_line_rec.attribute2);
539:
540: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
541: p_line_rec.attribute3);
542:
543: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
544: p_line_rec.attribute4);

Line 543: dbms_sql.bind_variable(p_update_cursor, ':attribute4',

539:
540: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
541: p_line_rec.attribute3);
542:
543: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
544: p_line_rec.attribute4);
545:
546: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
547: p_line_rec.attribute5);

Line 546: dbms_sql.bind_variable(p_update_cursor, ':attribute5',

542:
543: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
544: p_line_rec.attribute4);
545:
546: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
547: p_line_rec.attribute5);
548:
549: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
550: p_line_rec.attribute6);

Line 549: dbms_sql.bind_variable(p_update_cursor, ':attribute6',

545:
546: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
547: p_line_rec.attribute5);
548:
549: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
550: p_line_rec.attribute6);
551:
552: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
553: p_line_rec.attribute7);

Line 552: dbms_sql.bind_variable(p_update_cursor, ':attribute7',

548:
549: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
550: p_line_rec.attribute6);
551:
552: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
553: p_line_rec.attribute7);
554:
555: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
556: p_line_rec.attribute8);

Line 555: dbms_sql.bind_variable(p_update_cursor, ':attribute8',

551:
552: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
553: p_line_rec.attribute7);
554:
555: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
556: p_line_rec.attribute8);
557:
558: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
559: p_line_rec.attribute9);

Line 558: dbms_sql.bind_variable(p_update_cursor, ':attribute9',

554:
555: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
556: p_line_rec.attribute8);
557:
558: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
559: p_line_rec.attribute9);
560:
561: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
562: p_line_rec.attribute10);

Line 561: dbms_sql.bind_variable(p_update_cursor, ':attribute10',

557:
558: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
559: p_line_rec.attribute9);
560:
561: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
562: p_line_rec.attribute10);
563:
564: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
565: p_line_rec.attribute11);

Line 564: dbms_sql.bind_variable(p_update_cursor, ':attribute11',

560:
561: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
562: p_line_rec.attribute10);
563:
564: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
565: p_line_rec.attribute11);
566:
567: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
568: p_line_rec.attribute12);

Line 567: dbms_sql.bind_variable(p_update_cursor, ':attribute12',

563:
564: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
565: p_line_rec.attribute11);
566:
567: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
568: p_line_rec.attribute12);
569:
570: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
571: p_line_rec.attribute13);

Line 570: dbms_sql.bind_variable(p_update_cursor, ':attribute13',

566:
567: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
568: p_line_rec.attribute12);
569:
570: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
571: p_line_rec.attribute13);
572:
573: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
574: p_line_rec.attribute14);

Line 573: dbms_sql.bind_variable(p_update_cursor, ':attribute14',

569:
570: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
571: p_line_rec.attribute13);
572:
573: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
574: p_line_rec.attribute14);
575:
576: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
577: p_line_rec.attribute15);

Line 576: dbms_sql.bind_variable(p_update_cursor, ':attribute15',

572:
573: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
574: p_line_rec.attribute14);
575:
576: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
577: p_line_rec.attribute15);
578:
579: dbms_sql.bind_variable(p_update_cursor, ':created_by',
580: p_line_rec.created_by);

Line 579: dbms_sql.bind_variable(p_update_cursor, ':created_by',

575:
576: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
577: p_line_rec.attribute15);
578:
579: dbms_sql.bind_variable(p_update_cursor, ':created_by',
580: p_line_rec.created_by);
581:
582: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
583: p_line_rec.creation_date);

Line 582: dbms_sql.bind_variable(p_update_cursor, ':creation_date',

578:
579: dbms_sql.bind_variable(p_update_cursor, ':created_by',
580: p_line_rec.created_by);
581:
582: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
583: p_line_rec.creation_date);
584:
585: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
586: p_line_rec.last_updated_by);

Line 585: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',

581:
582: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
583: p_line_rec.creation_date);
584:
585: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
586: p_line_rec.last_updated_by);
587:
588: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
589: p_line_rec.last_update_date);

Line 588: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',

584:
585: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
586: p_line_rec.last_updated_by);
587:
588: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
589: p_line_rec.last_update_date);
590:
591: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
592: p_line_rec.program_application_id);

Line 591: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',

587:
588: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
589: p_line_rec.last_update_date);
590:
591: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
592: p_line_rec.program_application_id);
593:
594: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
595: p_line_rec.last_update_login);

Line 594: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',

590:
591: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
592: p_line_rec.program_application_id);
593:
594: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
595: p_line_rec.last_update_login);
596:
597: dbms_sql.bind_variable(p_update_cursor, ':program_id',
598: p_line_rec.program_id);

Line 597: dbms_sql.bind_variable(p_update_cursor, ':program_id',

593:
594: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
595: p_line_rec.last_update_login);
596:
597: dbms_sql.bind_variable(p_update_cursor, ':program_id',
598: p_line_rec.program_id);
599:
600: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
601: p_line_rec.program_update_date);

Line 600: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',

596:
597: dbms_sql.bind_variable(p_update_cursor, ':program_id',
598: p_line_rec.program_id);
599:
600: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
601: p_line_rec.program_update_date);
602:
603: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
604: p_line_rec.set_of_books_id);

Line 603: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',

599:
600: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
601: p_line_rec.program_update_date);
602:
603: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
604: p_line_rec.set_of_books_id);
605:
606: -- Rel. 11 Changes:
607:

Line 608: dbms_sql.bind_variable(p_update_cursor, ':gross_unit_selling_price',

604: p_line_rec.set_of_books_id);
605:
606: -- Rel. 11 Changes:
607:
608: dbms_sql.bind_variable(p_update_cursor, ':gross_unit_selling_price',
609: p_line_rec.gross_unit_selling_price);
610:
611: dbms_sql.bind_variable(p_update_cursor, ':gross_extended_amount',
612: p_line_rec.gross_extended_amount);

Line 611: dbms_sql.bind_variable(p_update_cursor, ':gross_extended_amount',

607:
608: dbms_sql.bind_variable(p_update_cursor, ':gross_unit_selling_price',
609: p_line_rec.gross_unit_selling_price);
610:
611: dbms_sql.bind_variable(p_update_cursor, ':gross_extended_amount',
612: p_line_rec.gross_extended_amount);
613:
614: dbms_sql.bind_variable(p_update_cursor, ':amount_includes_tax_flag',
615: p_line_rec.amount_includes_tax_flag);

Line 614: dbms_sql.bind_variable(p_update_cursor, ':amount_includes_tax_flag',

610:
611: dbms_sql.bind_variable(p_update_cursor, ':gross_extended_amount',
612: p_line_rec.gross_extended_amount);
613:
614: dbms_sql.bind_variable(p_update_cursor, ':amount_includes_tax_flag',
615: p_line_rec.amount_includes_tax_flag);
616:
617: -- For global descriptive flexfield
618:

Line 619: dbms_sql.bind_variable(p_update_cursor, ':global_attribute_category',

615: p_line_rec.amount_includes_tax_flag);
616:
617: -- For global descriptive flexfield
618:
619: dbms_sql.bind_variable(p_update_cursor, ':global_attribute_category',
620: p_line_rec.global_attribute_category);
621:
622: dbms_sql.bind_variable(p_update_cursor, ':global_attribute1',
623: p_line_rec.global_attribute1);

Line 622: dbms_sql.bind_variable(p_update_cursor, ':global_attribute1',

618:
619: dbms_sql.bind_variable(p_update_cursor, ':global_attribute_category',
620: p_line_rec.global_attribute_category);
621:
622: dbms_sql.bind_variable(p_update_cursor, ':global_attribute1',
623: p_line_rec.global_attribute1);
624:
625: dbms_sql.bind_variable(p_update_cursor, ':global_attribute2',
626: p_line_rec.global_attribute2);

Line 625: dbms_sql.bind_variable(p_update_cursor, ':global_attribute2',

621:
622: dbms_sql.bind_variable(p_update_cursor, ':global_attribute1',
623: p_line_rec.global_attribute1);
624:
625: dbms_sql.bind_variable(p_update_cursor, ':global_attribute2',
626: p_line_rec.global_attribute2);
627:
628: dbms_sql.bind_variable(p_update_cursor, ':global_attribute3',
629: p_line_rec.global_attribute3);

Line 628: dbms_sql.bind_variable(p_update_cursor, ':global_attribute3',

624:
625: dbms_sql.bind_variable(p_update_cursor, ':global_attribute2',
626: p_line_rec.global_attribute2);
627:
628: dbms_sql.bind_variable(p_update_cursor, ':global_attribute3',
629: p_line_rec.global_attribute3);
630:
631: dbms_sql.bind_variable(p_update_cursor, ':global_attribute4',
632: p_line_rec.global_attribute4);

Line 631: dbms_sql.bind_variable(p_update_cursor, ':global_attribute4',

627:
628: dbms_sql.bind_variable(p_update_cursor, ':global_attribute3',
629: p_line_rec.global_attribute3);
630:
631: dbms_sql.bind_variable(p_update_cursor, ':global_attribute4',
632: p_line_rec.global_attribute4);
633:
634: dbms_sql.bind_variable(p_update_cursor, ':global_attribute5',
635: p_line_rec.global_attribute5);

Line 634: dbms_sql.bind_variable(p_update_cursor, ':global_attribute5',

630:
631: dbms_sql.bind_variable(p_update_cursor, ':global_attribute4',
632: p_line_rec.global_attribute4);
633:
634: dbms_sql.bind_variable(p_update_cursor, ':global_attribute5',
635: p_line_rec.global_attribute5);
636:
637: dbms_sql.bind_variable(p_update_cursor, ':global_attribute6',
638: p_line_rec.global_attribute6);

Line 637: dbms_sql.bind_variable(p_update_cursor, ':global_attribute6',

633:
634: dbms_sql.bind_variable(p_update_cursor, ':global_attribute5',
635: p_line_rec.global_attribute5);
636:
637: dbms_sql.bind_variable(p_update_cursor, ':global_attribute6',
638: p_line_rec.global_attribute6);
639:
640: dbms_sql.bind_variable(p_update_cursor, ':global_attribute7',
641: p_line_rec.global_attribute7);

Line 640: dbms_sql.bind_variable(p_update_cursor, ':global_attribute7',

636:
637: dbms_sql.bind_variable(p_update_cursor, ':global_attribute6',
638: p_line_rec.global_attribute6);
639:
640: dbms_sql.bind_variable(p_update_cursor, ':global_attribute7',
641: p_line_rec.global_attribute7);
642:
643: dbms_sql.bind_variable(p_update_cursor, ':global_attribute8',
644: p_line_rec.global_attribute8);

Line 643: dbms_sql.bind_variable(p_update_cursor, ':global_attribute8',

639:
640: dbms_sql.bind_variable(p_update_cursor, ':global_attribute7',
641: p_line_rec.global_attribute7);
642:
643: dbms_sql.bind_variable(p_update_cursor, ':global_attribute8',
644: p_line_rec.global_attribute8);
645:
646: dbms_sql.bind_variable(p_update_cursor, ':global_attribute9',
647: p_line_rec.global_attribute9);

Line 646: dbms_sql.bind_variable(p_update_cursor, ':global_attribute9',

642:
643: dbms_sql.bind_variable(p_update_cursor, ':global_attribute8',
644: p_line_rec.global_attribute8);
645:
646: dbms_sql.bind_variable(p_update_cursor, ':global_attribute9',
647: p_line_rec.global_attribute9);
648:
649: dbms_sql.bind_variable(p_update_cursor, ':global_attribute10',
650: p_line_rec.global_attribute10);

Line 649: dbms_sql.bind_variable(p_update_cursor, ':global_attribute10',

645:
646: dbms_sql.bind_variable(p_update_cursor, ':global_attribute9',
647: p_line_rec.global_attribute9);
648:
649: dbms_sql.bind_variable(p_update_cursor, ':global_attribute10',
650: p_line_rec.global_attribute10);
651:
652: dbms_sql.bind_variable(p_update_cursor, ':global_attribute11',
653: p_line_rec.global_attribute11);

Line 652: dbms_sql.bind_variable(p_update_cursor, ':global_attribute11',

648:
649: dbms_sql.bind_variable(p_update_cursor, ':global_attribute10',
650: p_line_rec.global_attribute10);
651:
652: dbms_sql.bind_variable(p_update_cursor, ':global_attribute11',
653: p_line_rec.global_attribute11);
654:
655: dbms_sql.bind_variable(p_update_cursor, ':global_attribute12',
656: p_line_rec.global_attribute12);

Line 655: dbms_sql.bind_variable(p_update_cursor, ':global_attribute12',

651:
652: dbms_sql.bind_variable(p_update_cursor, ':global_attribute11',
653: p_line_rec.global_attribute11);
654:
655: dbms_sql.bind_variable(p_update_cursor, ':global_attribute12',
656: p_line_rec.global_attribute12);
657:
658: dbms_sql.bind_variable(p_update_cursor, ':global_attribute13',
659: p_line_rec.global_attribute13);

Line 658: dbms_sql.bind_variable(p_update_cursor, ':global_attribute13',

654:
655: dbms_sql.bind_variable(p_update_cursor, ':global_attribute12',
656: p_line_rec.global_attribute12);
657:
658: dbms_sql.bind_variable(p_update_cursor, ':global_attribute13',
659: p_line_rec.global_attribute13);
660:
661: dbms_sql.bind_variable(p_update_cursor, ':global_attribute14',
662: p_line_rec.global_attribute14);

Line 661: dbms_sql.bind_variable(p_update_cursor, ':global_attribute14',

657:
658: dbms_sql.bind_variable(p_update_cursor, ':global_attribute13',
659: p_line_rec.global_attribute13);
660:
661: dbms_sql.bind_variable(p_update_cursor, ':global_attribute14',
662: p_line_rec.global_attribute14);
663:
664: dbms_sql.bind_variable(p_update_cursor, ':global_attribute15',
665: p_line_rec.global_attribute15);

Line 664: dbms_sql.bind_variable(p_update_cursor, ':global_attribute15',

660:
661: dbms_sql.bind_variable(p_update_cursor, ':global_attribute14',
662: p_line_rec.global_attribute14);
663:
664: dbms_sql.bind_variable(p_update_cursor, ':global_attribute15',
665: p_line_rec.global_attribute15);
666:
667: dbms_sql.bind_variable(p_update_cursor, ':global_attribute16',
668: p_line_rec.global_attribute16);

Line 667: dbms_sql.bind_variable(p_update_cursor, ':global_attribute16',

663:
664: dbms_sql.bind_variable(p_update_cursor, ':global_attribute15',
665: p_line_rec.global_attribute15);
666:
667: dbms_sql.bind_variable(p_update_cursor, ':global_attribute16',
668: p_line_rec.global_attribute16);
669:
670: dbms_sql.bind_variable(p_update_cursor, ':global_attribute17',
671: p_line_rec.global_attribute17);

Line 670: dbms_sql.bind_variable(p_update_cursor, ':global_attribute17',

666:
667: dbms_sql.bind_variable(p_update_cursor, ':global_attribute16',
668: p_line_rec.global_attribute16);
669:
670: dbms_sql.bind_variable(p_update_cursor, ':global_attribute17',
671: p_line_rec.global_attribute17);
672:
673: dbms_sql.bind_variable(p_update_cursor, ':global_attribute18',
674: p_line_rec.global_attribute18);

Line 673: dbms_sql.bind_variable(p_update_cursor, ':global_attribute18',

669:
670: dbms_sql.bind_variable(p_update_cursor, ':global_attribute17',
671: p_line_rec.global_attribute17);
672:
673: dbms_sql.bind_variable(p_update_cursor, ':global_attribute18',
674: p_line_rec.global_attribute18);
675:
676: dbms_sql.bind_variable(p_update_cursor, ':global_attribute19',
677: p_line_rec.global_attribute19);

Line 676: dbms_sql.bind_variable(p_update_cursor, ':global_attribute19',

672:
673: dbms_sql.bind_variable(p_update_cursor, ':global_attribute18',
674: p_line_rec.global_attribute18);
675:
676: dbms_sql.bind_variable(p_update_cursor, ':global_attribute19',
677: p_line_rec.global_attribute19);
678:
679: dbms_sql.bind_variable(p_update_cursor, ':global_attribute20',
680: p_line_rec.global_attribute20);

Line 679: dbms_sql.bind_variable(p_update_cursor, ':global_attribute20',

675:
676: dbms_sql.bind_variable(p_update_cursor, ':global_attribute19',
677: p_line_rec.global_attribute19);
678:
679: dbms_sql.bind_variable(p_update_cursor, ':global_attribute20',
680: p_line_rec.global_attribute20);
681:
682: /* added for global tax engine */
683: dbms_sql.bind_variable(p_update_cursor, ':warehouse_id',

Line 683: dbms_sql.bind_variable(p_update_cursor, ':warehouse_id',

679: dbms_sql.bind_variable(p_update_cursor, ':global_attribute20',
680: p_line_rec.global_attribute20);
681:
682: /* added for global tax engine */
683: dbms_sql.bind_variable(p_update_cursor, ':warehouse_id',
684: p_line_rec.warehouse_id);
685: dbms_sql.bind_variable(p_update_cursor, ':translated_description',
686: p_line_rec.translated_description);
687:

Line 685: dbms_sql.bind_variable(p_update_cursor, ':translated_description',

681:
682: /* added for global tax engine */
683: dbms_sql.bind_variable(p_update_cursor, ':warehouse_id',
684: p_line_rec.warehouse_id);
685: dbms_sql.bind_variable(p_update_cursor, ':translated_description',
686: p_line_rec.translated_description);
687:
688: /* Bug 853757 */
689: dbms_sql.bind_variable(p_update_cursor, ':taxable_amount',

Line 689: dbms_sql.bind_variable(p_update_cursor, ':taxable_amount',

685: dbms_sql.bind_variable(p_update_cursor, ':translated_description',
686: p_line_rec.translated_description);
687:
688: /* Bug 853757 */
689: dbms_sql.bind_variable(p_update_cursor, ':taxable_amount',
690: p_line_rec.taxable_amount);
691:
692: dbms_sql.bind_variable(p_update_cursor, ':extended_acctd_amount',
693: p_line_rec.extended_acctd_amount);

Line 692: dbms_sql.bind_variable(p_update_cursor, ':extended_acctd_amount',

688: /* Bug 853757 */
689: dbms_sql.bind_variable(p_update_cursor, ':taxable_amount',
690: p_line_rec.taxable_amount);
691:
692: dbms_sql.bind_variable(p_update_cursor, ':extended_acctd_amount',
693: p_line_rec.extended_acctd_amount);
694:
695: dbms_sql.bind_variable(p_update_cursor, ':br_ref_customer_trx_id',
696: p_line_rec.br_ref_customer_trx_id);

Line 695: dbms_sql.bind_variable(p_update_cursor, ':br_ref_customer_trx_id',

691:
692: dbms_sql.bind_variable(p_update_cursor, ':extended_acctd_amount',
693: p_line_rec.extended_acctd_amount);
694:
695: dbms_sql.bind_variable(p_update_cursor, ':br_ref_customer_trx_id',
696: p_line_rec.br_ref_customer_trx_id);
697:
698: dbms_sql.bind_variable(p_update_cursor, ':br_ref_payment_schedule_id',
699: p_line_rec.br_ref_payment_schedule_id);

Line 698: dbms_sql.bind_variable(p_update_cursor, ':br_ref_payment_schedule_id',

694:
695: dbms_sql.bind_variable(p_update_cursor, ':br_ref_customer_trx_id',
696: p_line_rec.br_ref_customer_trx_id);
697:
698: dbms_sql.bind_variable(p_update_cursor, ':br_ref_payment_schedule_id',
699: p_line_rec.br_ref_payment_schedule_id);
700:
701: dbms_sql.bind_variable(p_update_cursor, ':br_adjustment_id',
702: p_line_rec.br_adjustment_id);

Line 701: dbms_sql.bind_variable(p_update_cursor, ':br_adjustment_id',

697:
698: dbms_sql.bind_variable(p_update_cursor, ':br_ref_payment_schedule_id',
699: p_line_rec.br_ref_payment_schedule_id);
700:
701: dbms_sql.bind_variable(p_update_cursor, ':br_adjustment_id',
702: p_line_rec.br_adjustment_id);
703:
704: dbms_sql.bind_variable(p_update_cursor, ':wh_update_date',
705: p_line_rec.wh_update_date);

Line 704: dbms_sql.bind_variable(p_update_cursor, ':wh_update_date',

700:
701: dbms_sql.bind_variable(p_update_cursor, ':br_adjustment_id',
702: p_line_rec.br_adjustment_id);
703:
704: dbms_sql.bind_variable(p_update_cursor, ':wh_update_date',
705: p_line_rec.wh_update_date);
706:
707: dbms_sql.bind_variable(p_update_cursor, ':payment_set_id',
708: p_line_rec.payment_set_id);

Line 707: dbms_sql.bind_variable(p_update_cursor, ':payment_set_id',

703:
704: dbms_sql.bind_variable(p_update_cursor, ':wh_update_date',
705: p_line_rec.wh_update_date);
706:
707: dbms_sql.bind_variable(p_update_cursor, ':payment_set_id',
708: p_line_rec.payment_set_id);
709: /* 4713671 */
710: dbms_sql.bind_variable(p_update_cursor, ':ship_to_customer_id',
711: p_line_rec.ship_to_customer_id);

Line 710: dbms_sql.bind_variable(p_update_cursor, ':ship_to_customer_id',

706:
707: dbms_sql.bind_variable(p_update_cursor, ':payment_set_id',
708: p_line_rec.payment_set_id);
709: /* 4713671 */
710: dbms_sql.bind_variable(p_update_cursor, ':ship_to_customer_id',
711: p_line_rec.ship_to_customer_id);
712:
713: dbms_sql.bind_variable(p_update_cursor, ':ship_to_site_use_id',
714: p_line_rec.ship_to_site_use_id);

Line 713: dbms_sql.bind_variable(p_update_cursor, ':ship_to_site_use_id',

709: /* 4713671 */
710: dbms_sql.bind_variable(p_update_cursor, ':ship_to_customer_id',
711: p_line_rec.ship_to_customer_id);
712:
713: dbms_sql.bind_variable(p_update_cursor, ':ship_to_site_use_id',
714: p_line_rec.ship_to_site_use_id);
715:
716: dbms_sql.bind_variable(p_update_cursor, ':ship_to_contact_id',
717: p_line_rec.ship_to_contact_id);

Line 716: dbms_sql.bind_variable(p_update_cursor, ':ship_to_contact_id',

712:
713: dbms_sql.bind_variable(p_update_cursor, ':ship_to_site_use_id',
714: p_line_rec.ship_to_site_use_id);
715:
716: dbms_sql.bind_variable(p_update_cursor, ':ship_to_contact_id',
717: p_line_rec.ship_to_contact_id);
718:
719: dbms_sql.bind_variable(p_update_cursor, ':tax_classification_code',
720: p_line_rec.tax_classification_code);

Line 719: dbms_sql.bind_variable(p_update_cursor, ':tax_classification_code',

715:
716: dbms_sql.bind_variable(p_update_cursor, ':ship_to_contact_id',
717: p_line_rec.ship_to_contact_id);
718:
719: dbms_sql.bind_variable(p_update_cursor, ':tax_classification_code',
720: p_line_rec.tax_classification_code);
721: /* 4713671 end */
722: dbms_sql.bind_variable(p_update_cursor, ':rule_end_date',
723: p_line_rec.rule_end_date);

Line 722: dbms_sql.bind_variable(p_update_cursor, ':rule_end_date',

718:
719: dbms_sql.bind_variable(p_update_cursor, ':tax_classification_code',
720: p_line_rec.tax_classification_code);
721: /* 4713671 end */
722: dbms_sql.bind_variable(p_update_cursor, ':rule_end_date',
723: p_line_rec.rule_end_date);
724:
725: arp_util.debug('arp_ctl_pkg.bind_line_variables()-');
726:

Line 1375: | dbms_sql.open_cursor |

1371: | SCOPE - PRIVATE |
1372: | |
1373: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1374: | arp_util.debug |
1375: | dbms_sql.open_cursor |
1376: | dbms_sql.parse |
1377: | dbms_sql.execute |
1378: | dbms_sql.close_cursor |
1379: | |

Line 1376: | dbms_sql.parse |

1372: | |
1373: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1374: | arp_util.debug |
1375: | dbms_sql.open_cursor |
1376: | dbms_sql.parse |
1377: | dbms_sql.execute |
1378: | dbms_sql.close_cursor |
1379: | |
1380: | ARGUMENTS : IN: |

Line 1377: | dbms_sql.execute |

1373: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1374: | arp_util.debug |
1375: | dbms_sql.open_cursor |
1376: | dbms_sql.parse |
1377: | dbms_sql.execute |
1378: | dbms_sql.close_cursor |
1379: | |
1380: | ARGUMENTS : IN: |
1381: | p_update_cursor - identifies the cursor to use |

Line 1378: | dbms_sql.close_cursor |

1374: | arp_util.debug |
1375: | dbms_sql.open_cursor |
1376: | dbms_sql.parse |
1377: | dbms_sql.execute |
1378: | dbms_sql.close_cursor |
1379: | |
1380: | ARGUMENTS : IN: |
1381: | p_update_cursor - identifies the cursor to use |
1382: | p_where_clause - identifies which rows to update |

Line 1412: ctl_array dbms_sql.number_table;

1408:
1409: l_count number;
1410: l_update_statement varchar2(32767);
1411: --{bug#3339072 MRC trx lines
1412: ctl_array dbms_sql.number_table;
1413: --}
1414:
1415: BEGIN
1416: arp_util.debug('arp_ctl_pkg.generic_update()+');

Line 1428: p_update_cursor := dbms_sql.open_cursor;

1424:
1425: IF (p_update_cursor is null)
1426: THEN
1427:
1428: p_update_cursor := dbms_sql.open_cursor;
1429:
1430: /*---------------------------------+
1431: | Construct the update statement |
1432: +---------------------------------*/

Line 1450: dbms_sql.parse(p_update_cursor,

1446: /*-----------------------------------------------+
1447: | Parse, bind, execute and close the statement |
1448: +-----------------------------------------------*/
1449:
1450: dbms_sql.parse(p_update_cursor,
1451: l_update_statement,
1452: dbms_sql.v7);
1453:
1454: END IF;

Line 1452: dbms_sql.v7);

1448: +-----------------------------------------------*/
1449:
1450: dbms_sql.parse(p_update_cursor,
1451: l_update_statement,
1452: dbms_sql.v7);
1453:
1454: END IF;
1455:
1456: arp_ctl_pkg.bind_line_variables(p_update_cursor, p_line_rec);

Line 1462: dbms_sql.bind_variable(p_update_cursor, ':where_1',

1458: /*-----------------------------------------+
1459: | Bind the variables in the where clause |
1460: +-----------------------------------------*/
1461:
1462: dbms_sql.bind_variable(p_update_cursor, ':where_1',
1463: p_where1);
1464:
1465: dbms_sql.bind_variable(p_update_cursor, ':where_line_type',
1466: p_line_type);

Line 1465: dbms_sql.bind_variable(p_update_cursor, ':where_line_type',

1461:
1462: dbms_sql.bind_variable(p_update_cursor, ':where_1',
1463: p_where1);
1464:
1465: dbms_sql.bind_variable(p_update_cursor, ':where_line_type',
1466: p_line_type);
1467:
1468: dbms_sql.bind_variable(p_update_cursor, ':invoice_currency_code',
1469: p_currency_code);

Line 1468: dbms_sql.bind_variable(p_update_cursor, ':invoice_currency_code',

1464:
1465: dbms_sql.bind_variable(p_update_cursor, ':where_line_type',
1466: p_line_type);
1467:
1468: dbms_sql.bind_variable(p_update_cursor, ':invoice_currency_code',
1469: p_currency_code);
1470:
1471: --{BUG#3339072
1472: dbms_sql.bind_array(p_update_cursor, ':ctl_value',

Line 1472: dbms_sql.bind_array(p_update_cursor, ':ctl_value',

1468: dbms_sql.bind_variable(p_update_cursor, ':invoice_currency_code',
1469: p_currency_code);
1470:
1471: --{BUG#3339072
1472: dbms_sql.bind_array(p_update_cursor, ':ctl_value',
1473: ctl_array);
1474: --}
1475:
1476: l_count := dbms_sql.execute(p_update_cursor);

Line 1476: l_count := dbms_sql.execute(p_update_cursor);

1472: dbms_sql.bind_array(p_update_cursor, ':ctl_value',
1473: ctl_array);
1474: --}
1475:
1476: l_count := dbms_sql.execute(p_update_cursor);
1477:
1478: arp_util.debug( to_char(l_count) || ' rows updated');
1479:
1480: --{BUG#3339072

Line 1481: dbms_sql.variable_value(p_update_cursor, ':ctl_value',

1477:
1478: arp_util.debug( to_char(l_count) || ' rows updated');
1479:
1480: --{BUG#3339072
1481: dbms_sql.variable_value(p_update_cursor, ':ctl_value',
1482: ctl_array);
1483: --}
1484:
1485: /*------------------------------------------------------------+

Line 1500: to_char(dbms_sql.last_error_position));

1496: WHEN OTHERS THEN
1497: arp_util.debug('EXCEPTION: arp_ctl_pkg.generic_update()');
1498: arp_util.debug(l_update_statement);
1499: arp_util.debug('Error at character: ' ||
1500: to_char(dbms_sql.last_error_position));
1501:
1502: arp_util.debug('');
1503: arp_util.debug('-------- parameters for generic_update() ------');
1504: arp_util.debug('p_update_cursor = ' || p_update_cursor);