DBA Data[Home] [Help]

APPS.ARP_PROCESS_FREIGHT_COVER dependencies on RA_CUSTOMER_TRX_LINES

Line 56: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,

52:
53: PROCEDURE insert_freight_cover(
54: p_form_name IN varchar2,
55: p_form_version IN number,
56: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
57: p_line_type IN ra_customer_trx_lines.line_type%type,
58: p_line_number IN ra_customer_trx_lines.line_number%type,
59: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,

Line 57: p_line_type IN ra_customer_trx_lines.line_type%type,

53: PROCEDURE insert_freight_cover(
54: p_form_name IN varchar2,
55: p_form_version IN number,
56: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
57: p_line_type IN ra_customer_trx_lines.line_type%type,
58: p_line_number IN ra_customer_trx_lines.line_number%type,
59: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
61: p_previous_customer_trx_id IN

Line 58: p_line_number IN ra_customer_trx_lines.line_number%type,

54: p_form_name IN varchar2,
55: p_form_version IN number,
56: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
57: p_line_type IN ra_customer_trx_lines.line_type%type,
58: p_line_number IN ra_customer_trx_lines.line_number%type,
59: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
61: p_previous_customer_trx_id IN
62: ra_customer_trx_lines.previous_customer_trx_id%type,

Line 59: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,

55: p_form_version IN number,
56: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
57: p_line_type IN ra_customer_trx_lines.line_type%type,
58: p_line_number IN ra_customer_trx_lines.line_number%type,
59: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
61: p_previous_customer_trx_id IN
62: ra_customer_trx_lines.previous_customer_trx_id%type,
63: p_previous_cust_trx_line_id IN

Line 60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,

56: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
57: p_line_type IN ra_customer_trx_lines.line_type%type,
58: p_line_number IN ra_customer_trx_lines.line_number%type,
59: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
61: p_previous_customer_trx_id IN
62: ra_customer_trx_lines.previous_customer_trx_id%type,
63: p_previous_cust_trx_line_id IN
64: ra_customer_trx_lines.previous_customer_trx_line_id%type,

Line 62: ra_customer_trx_lines.previous_customer_trx_id%type,

58: p_line_number IN ra_customer_trx_lines.line_number%type,
59: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
61: p_previous_customer_trx_id IN
62: ra_customer_trx_lines.previous_customer_trx_id%type,
63: p_previous_cust_trx_line_id IN
64: ra_customer_trx_lines.previous_customer_trx_line_id%type,
65: p_link_to_cust_trx_line_id IN
66: ra_customer_trx_lines.link_to_cust_trx_line_id%type,

Line 64: ra_customer_trx_lines.previous_customer_trx_line_id%type,

60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
61: p_previous_customer_trx_id IN
62: ra_customer_trx_lines.previous_customer_trx_id%type,
63: p_previous_cust_trx_line_id IN
64: ra_customer_trx_lines.previous_customer_trx_line_id%type,
65: p_link_to_cust_trx_line_id IN
66: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
67: p_attribute_category IN
68: ra_customer_trx_lines.attribute_category%type,

Line 66: ra_customer_trx_lines.link_to_cust_trx_line_id%type,

62: ra_customer_trx_lines.previous_customer_trx_id%type,
63: p_previous_cust_trx_line_id IN
64: ra_customer_trx_lines.previous_customer_trx_line_id%type,
65: p_link_to_cust_trx_line_id IN
66: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
67: p_attribute_category IN
68: ra_customer_trx_lines.attribute_category%type,
69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,

Line 68: ra_customer_trx_lines.attribute_category%type,

64: ra_customer_trx_lines.previous_customer_trx_line_id%type,
65: p_link_to_cust_trx_line_id IN
66: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
67: p_attribute_category IN
68: ra_customer_trx_lines.attribute_category%type,
69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,

Line 69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,

65: p_link_to_cust_trx_line_id IN
66: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
67: p_attribute_category IN
68: ra_customer_trx_lines.attribute_category%type,
69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,

Line 70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,

66: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
67: p_attribute_category IN
68: ra_customer_trx_lines.attribute_category%type,
69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,

Line 71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,

67: p_attribute_category IN
68: ra_customer_trx_lines.attribute_category%type,
69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,

Line 72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,

68: ra_customer_trx_lines.attribute_category%type,
69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,

Line 73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,

69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,

Line 74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,

70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,

Line 75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,

71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,

Line 76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,

72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,

Line 77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,

73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,

Line 78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,

74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,

Line 79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,

75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,

Line 80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,

76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
84: p_interface_line_context IN

Line 81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,

77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
84: p_interface_line_context IN
85: ra_customer_trx_lines.interface_line_context%type,

Line 82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,

78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
84: p_interface_line_context IN
85: ra_customer_trx_lines.interface_line_context%type,
86: p_interface_line_attribute1 IN

Line 83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,

79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
84: p_interface_line_context IN
85: ra_customer_trx_lines.interface_line_context%type,
86: p_interface_line_attribute1 IN
87: ra_customer_trx_lines.interface_line_attribute1%type,

Line 85: ra_customer_trx_lines.interface_line_context%type,

81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
84: p_interface_line_context IN
85: ra_customer_trx_lines.interface_line_context%type,
86: p_interface_line_attribute1 IN
87: ra_customer_trx_lines.interface_line_attribute1%type,
88: p_interface_line_attribute2 IN
89: ra_customer_trx_lines.interface_line_attribute2%type,

Line 87: ra_customer_trx_lines.interface_line_attribute1%type,

83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
84: p_interface_line_context IN
85: ra_customer_trx_lines.interface_line_context%type,
86: p_interface_line_attribute1 IN
87: ra_customer_trx_lines.interface_line_attribute1%type,
88: p_interface_line_attribute2 IN
89: ra_customer_trx_lines.interface_line_attribute2%type,
90: p_interface_line_attribute3 IN
91: ra_customer_trx_lines.interface_line_attribute3%type,

Line 89: ra_customer_trx_lines.interface_line_attribute2%type,

85: ra_customer_trx_lines.interface_line_context%type,
86: p_interface_line_attribute1 IN
87: ra_customer_trx_lines.interface_line_attribute1%type,
88: p_interface_line_attribute2 IN
89: ra_customer_trx_lines.interface_line_attribute2%type,
90: p_interface_line_attribute3 IN
91: ra_customer_trx_lines.interface_line_attribute3%type,
92: p_interface_line_attribute4 IN
93: ra_customer_trx_lines.interface_line_attribute4%type,

Line 91: ra_customer_trx_lines.interface_line_attribute3%type,

87: ra_customer_trx_lines.interface_line_attribute1%type,
88: p_interface_line_attribute2 IN
89: ra_customer_trx_lines.interface_line_attribute2%type,
90: p_interface_line_attribute3 IN
91: ra_customer_trx_lines.interface_line_attribute3%type,
92: p_interface_line_attribute4 IN
93: ra_customer_trx_lines.interface_line_attribute4%type,
94: p_interface_line_attribute5 IN
95: ra_customer_trx_lines.interface_line_attribute5%type,

Line 93: ra_customer_trx_lines.interface_line_attribute4%type,

89: ra_customer_trx_lines.interface_line_attribute2%type,
90: p_interface_line_attribute3 IN
91: ra_customer_trx_lines.interface_line_attribute3%type,
92: p_interface_line_attribute4 IN
93: ra_customer_trx_lines.interface_line_attribute4%type,
94: p_interface_line_attribute5 IN
95: ra_customer_trx_lines.interface_line_attribute5%type,
96: p_interface_line_attribute6 IN
97: ra_customer_trx_lines.interface_line_attribute6%type,

Line 95: ra_customer_trx_lines.interface_line_attribute5%type,

91: ra_customer_trx_lines.interface_line_attribute3%type,
92: p_interface_line_attribute4 IN
93: ra_customer_trx_lines.interface_line_attribute4%type,
94: p_interface_line_attribute5 IN
95: ra_customer_trx_lines.interface_line_attribute5%type,
96: p_interface_line_attribute6 IN
97: ra_customer_trx_lines.interface_line_attribute6%type,
98: p_interface_line_attribute7 IN
99: ra_customer_trx_lines.interface_line_attribute7%type,

Line 97: ra_customer_trx_lines.interface_line_attribute6%type,

93: ra_customer_trx_lines.interface_line_attribute4%type,
94: p_interface_line_attribute5 IN
95: ra_customer_trx_lines.interface_line_attribute5%type,
96: p_interface_line_attribute6 IN
97: ra_customer_trx_lines.interface_line_attribute6%type,
98: p_interface_line_attribute7 IN
99: ra_customer_trx_lines.interface_line_attribute7%type,
100: p_interface_line_attribute8 IN
101: ra_customer_trx_lines.interface_line_attribute8%type,

Line 99: ra_customer_trx_lines.interface_line_attribute7%type,

95: ra_customer_trx_lines.interface_line_attribute5%type,
96: p_interface_line_attribute6 IN
97: ra_customer_trx_lines.interface_line_attribute6%type,
98: p_interface_line_attribute7 IN
99: ra_customer_trx_lines.interface_line_attribute7%type,
100: p_interface_line_attribute8 IN
101: ra_customer_trx_lines.interface_line_attribute8%type,
102: p_interface_line_attribute9 IN
103: ra_customer_trx_lines.interface_line_attribute9%type,

Line 101: ra_customer_trx_lines.interface_line_attribute8%type,

97: ra_customer_trx_lines.interface_line_attribute6%type,
98: p_interface_line_attribute7 IN
99: ra_customer_trx_lines.interface_line_attribute7%type,
100: p_interface_line_attribute8 IN
101: ra_customer_trx_lines.interface_line_attribute8%type,
102: p_interface_line_attribute9 IN
103: ra_customer_trx_lines.interface_line_attribute9%type,
104: p_interface_line_attribute10 IN
105: ra_customer_trx_lines.interface_line_attribute10%type,

Line 103: ra_customer_trx_lines.interface_line_attribute9%type,

99: ra_customer_trx_lines.interface_line_attribute7%type,
100: p_interface_line_attribute8 IN
101: ra_customer_trx_lines.interface_line_attribute8%type,
102: p_interface_line_attribute9 IN
103: ra_customer_trx_lines.interface_line_attribute9%type,
104: p_interface_line_attribute10 IN
105: ra_customer_trx_lines.interface_line_attribute10%type,
106: p_interface_line_attribute11 IN
107: ra_customer_trx_lines.interface_line_attribute11%type,

Line 105: ra_customer_trx_lines.interface_line_attribute10%type,

101: ra_customer_trx_lines.interface_line_attribute8%type,
102: p_interface_line_attribute9 IN
103: ra_customer_trx_lines.interface_line_attribute9%type,
104: p_interface_line_attribute10 IN
105: ra_customer_trx_lines.interface_line_attribute10%type,
106: p_interface_line_attribute11 IN
107: ra_customer_trx_lines.interface_line_attribute11%type,
108: p_interface_line_attribute12 IN
109: ra_customer_trx_lines.interface_line_attribute12%type,

Line 107: ra_customer_trx_lines.interface_line_attribute11%type,

103: ra_customer_trx_lines.interface_line_attribute9%type,
104: p_interface_line_attribute10 IN
105: ra_customer_trx_lines.interface_line_attribute10%type,
106: p_interface_line_attribute11 IN
107: ra_customer_trx_lines.interface_line_attribute11%type,
108: p_interface_line_attribute12 IN
109: ra_customer_trx_lines.interface_line_attribute12%type,
110: p_interface_line_attribute13 IN
111: ra_customer_trx_lines.interface_line_attribute13%type,

Line 109: ra_customer_trx_lines.interface_line_attribute12%type,

105: ra_customer_trx_lines.interface_line_attribute10%type,
106: p_interface_line_attribute11 IN
107: ra_customer_trx_lines.interface_line_attribute11%type,
108: p_interface_line_attribute12 IN
109: ra_customer_trx_lines.interface_line_attribute12%type,
110: p_interface_line_attribute13 IN
111: ra_customer_trx_lines.interface_line_attribute13%type,
112: p_interface_line_attribute14 IN
113: ra_customer_trx_lines.interface_line_attribute14%type,

Line 111: ra_customer_trx_lines.interface_line_attribute13%type,

107: ra_customer_trx_lines.interface_line_attribute11%type,
108: p_interface_line_attribute12 IN
109: ra_customer_trx_lines.interface_line_attribute12%type,
110: p_interface_line_attribute13 IN
111: ra_customer_trx_lines.interface_line_attribute13%type,
112: p_interface_line_attribute14 IN
113: ra_customer_trx_lines.interface_line_attribute14%type,
114: p_interface_line_attribute15 IN
115: ra_customer_trx_lines.interface_line_attribute15%type,

Line 113: ra_customer_trx_lines.interface_line_attribute14%type,

109: ra_customer_trx_lines.interface_line_attribute12%type,
110: p_interface_line_attribute13 IN
111: ra_customer_trx_lines.interface_line_attribute13%type,
112: p_interface_line_attribute14 IN
113: ra_customer_trx_lines.interface_line_attribute14%type,
114: p_interface_line_attribute15 IN
115: ra_customer_trx_lines.interface_line_attribute15%type,
116: p_default_ussgl_code_context IN
117: ra_customer_trx_lines.default_ussgl_trx_code_context%type,

Line 115: ra_customer_trx_lines.interface_line_attribute15%type,

111: ra_customer_trx_lines.interface_line_attribute13%type,
112: p_interface_line_attribute14 IN
113: ra_customer_trx_lines.interface_line_attribute14%type,
114: p_interface_line_attribute15 IN
115: ra_customer_trx_lines.interface_line_attribute15%type,
116: p_default_ussgl_code_context IN
117: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
118: p_default_ussgl_trx_code IN
119: ra_customer_trx_lines.default_ussgl_transaction_code%type,

Line 117: ra_customer_trx_lines.default_ussgl_trx_code_context%type,

113: ra_customer_trx_lines.interface_line_attribute14%type,
114: p_interface_line_attribute15 IN
115: ra_customer_trx_lines.interface_line_attribute15%type,
116: p_default_ussgl_code_context IN
117: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
118: p_default_ussgl_trx_code IN
119: ra_customer_trx_lines.default_ussgl_transaction_code%type,
120: p_trx_class IN ra_cust_trx_types.type%type,
121: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 119: ra_customer_trx_lines.default_ussgl_transaction_code%type,

115: ra_customer_trx_lines.interface_line_attribute15%type,
116: p_default_ussgl_code_context IN
117: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
118: p_default_ussgl_trx_code IN
119: ra_customer_trx_lines.default_ussgl_transaction_code%type,
120: p_trx_class IN ra_cust_trx_types.type%type,
121: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
122: p_frt_ccid IN
123: ra_cust_trx_line_gl_dist.code_combination_id%type,

Line 125: ra_customer_trx_lines.customer_trx_line_id%type,

121: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
122: p_frt_ccid IN
123: ra_cust_trx_line_gl_dist.code_combination_id%type,
124: p_customer_trx_line_id OUT NOCOPY
125: ra_customer_trx_lines.customer_trx_line_id%type,
126: p_status OUT NOCOPY varchar2)
127: IS
128:
129: l_frt_rec ra_customer_trx_lines%rowtype;

Line 129: l_frt_rec ra_customer_trx_lines%rowtype;

125: ra_customer_trx_lines.customer_trx_line_id%type,
126: p_status OUT NOCOPY varchar2)
127: IS
128:
129: l_frt_rec ra_customer_trx_lines%rowtype;
130: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
131:
132: BEGIN
133:

Line 130: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

126: p_status OUT NOCOPY varchar2)
127: IS
128:
129: l_frt_rec ra_customer_trx_lines%rowtype;
130: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
131:
132: BEGIN
133:
134: IF PG_DEBUG in ('Y', 'C') THEN

Line 309: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,

305:
306: PROCEDURE update_freight_cover(
307: p_form_name IN varchar2,
308: p_form_version IN number,
309: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
310: p_customer_trx_line_id IN
311: ra_customer_trx_lines.customer_trx_line_id%type,
312: p_line_type IN ra_customer_trx_lines.line_type%type,
313: p_line_number IN ra_customer_trx_lines.line_number%type,

Line 311: ra_customer_trx_lines.customer_trx_line_id%type,

307: p_form_name IN varchar2,
308: p_form_version IN number,
309: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
310: p_customer_trx_line_id IN
311: ra_customer_trx_lines.customer_trx_line_id%type,
312: p_line_type IN ra_customer_trx_lines.line_type%type,
313: p_line_number IN ra_customer_trx_lines.line_number%type,
314: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,

Line 312: p_line_type IN ra_customer_trx_lines.line_type%type,

308: p_form_version IN number,
309: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
310: p_customer_trx_line_id IN
311: ra_customer_trx_lines.customer_trx_line_id%type,
312: p_line_type IN ra_customer_trx_lines.line_type%type,
313: p_line_number IN ra_customer_trx_lines.line_number%type,
314: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
316: p_previous_customer_trx_id IN

Line 313: p_line_number IN ra_customer_trx_lines.line_number%type,

309: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
310: p_customer_trx_line_id IN
311: ra_customer_trx_lines.customer_trx_line_id%type,
312: p_line_type IN ra_customer_trx_lines.line_type%type,
313: p_line_number IN ra_customer_trx_lines.line_number%type,
314: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
316: p_previous_customer_trx_id IN
317: ra_customer_trx_lines.previous_customer_trx_id%type,

Line 314: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,

310: p_customer_trx_line_id IN
311: ra_customer_trx_lines.customer_trx_line_id%type,
312: p_line_type IN ra_customer_trx_lines.line_type%type,
313: p_line_number IN ra_customer_trx_lines.line_number%type,
314: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
316: p_previous_customer_trx_id IN
317: ra_customer_trx_lines.previous_customer_trx_id%type,
318: p_previous_cust_trx_line_id IN

Line 315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,

311: ra_customer_trx_lines.customer_trx_line_id%type,
312: p_line_type IN ra_customer_trx_lines.line_type%type,
313: p_line_number IN ra_customer_trx_lines.line_number%type,
314: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
316: p_previous_customer_trx_id IN
317: ra_customer_trx_lines.previous_customer_trx_id%type,
318: p_previous_cust_trx_line_id IN
319: ra_customer_trx_lines.previous_customer_trx_line_id%type,

Line 317: ra_customer_trx_lines.previous_customer_trx_id%type,

313: p_line_number IN ra_customer_trx_lines.line_number%type,
314: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
316: p_previous_customer_trx_id IN
317: ra_customer_trx_lines.previous_customer_trx_id%type,
318: p_previous_cust_trx_line_id IN
319: ra_customer_trx_lines.previous_customer_trx_line_id%type,
320: p_link_to_cust_trx_line_id IN
321: ra_customer_trx_lines.link_to_cust_trx_line_id%type,

Line 319: ra_customer_trx_lines.previous_customer_trx_line_id%type,

315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
316: p_previous_customer_trx_id IN
317: ra_customer_trx_lines.previous_customer_trx_id%type,
318: p_previous_cust_trx_line_id IN
319: ra_customer_trx_lines.previous_customer_trx_line_id%type,
320: p_link_to_cust_trx_line_id IN
321: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
322: p_attribute_category IN
323: ra_customer_trx_lines.attribute_category%type,

Line 321: ra_customer_trx_lines.link_to_cust_trx_line_id%type,

317: ra_customer_trx_lines.previous_customer_trx_id%type,
318: p_previous_cust_trx_line_id IN
319: ra_customer_trx_lines.previous_customer_trx_line_id%type,
320: p_link_to_cust_trx_line_id IN
321: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
322: p_attribute_category IN
323: ra_customer_trx_lines.attribute_category%type,
324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,

Line 323: ra_customer_trx_lines.attribute_category%type,

319: ra_customer_trx_lines.previous_customer_trx_line_id%type,
320: p_link_to_cust_trx_line_id IN
321: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
322: p_attribute_category IN
323: ra_customer_trx_lines.attribute_category%type,
324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,

Line 324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,

320: p_link_to_cust_trx_line_id IN
321: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
322: p_attribute_category IN
323: ra_customer_trx_lines.attribute_category%type,
324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,

Line 325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,

321: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
322: p_attribute_category IN
323: ra_customer_trx_lines.attribute_category%type,
324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,

Line 326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,

322: p_attribute_category IN
323: ra_customer_trx_lines.attribute_category%type,
324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,

Line 327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,

323: ra_customer_trx_lines.attribute_category%type,
324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,

Line 328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,

324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,

Line 329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,

325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,

Line 330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,

326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,

Line 331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,

327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,

Line 332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,

328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,

Line 333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,

329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,

Line 334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,

330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,

Line 335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,

331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
339: p_interface_line_context IN

Line 336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,

332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
339: p_interface_line_context IN
340: ra_customer_trx_lines.interface_line_context%type,

Line 337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,

333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
339: p_interface_line_context IN
340: ra_customer_trx_lines.interface_line_context%type,
341: p_interface_line_attribute1 IN

Line 338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,

334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
339: p_interface_line_context IN
340: ra_customer_trx_lines.interface_line_context%type,
341: p_interface_line_attribute1 IN
342: ra_customer_trx_lines.interface_line_attribute1%type,

Line 340: ra_customer_trx_lines.interface_line_context%type,

336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
339: p_interface_line_context IN
340: ra_customer_trx_lines.interface_line_context%type,
341: p_interface_line_attribute1 IN
342: ra_customer_trx_lines.interface_line_attribute1%type,
343: p_interface_line_attribute2 IN
344: ra_customer_trx_lines.interface_line_attribute2%type,

Line 342: ra_customer_trx_lines.interface_line_attribute1%type,

338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
339: p_interface_line_context IN
340: ra_customer_trx_lines.interface_line_context%type,
341: p_interface_line_attribute1 IN
342: ra_customer_trx_lines.interface_line_attribute1%type,
343: p_interface_line_attribute2 IN
344: ra_customer_trx_lines.interface_line_attribute2%type,
345: p_interface_line_attribute3 IN
346: ra_customer_trx_lines.interface_line_attribute3%type,

Line 344: ra_customer_trx_lines.interface_line_attribute2%type,

340: ra_customer_trx_lines.interface_line_context%type,
341: p_interface_line_attribute1 IN
342: ra_customer_trx_lines.interface_line_attribute1%type,
343: p_interface_line_attribute2 IN
344: ra_customer_trx_lines.interface_line_attribute2%type,
345: p_interface_line_attribute3 IN
346: ra_customer_trx_lines.interface_line_attribute3%type,
347: p_interface_line_attribute4 IN
348: ra_customer_trx_lines.interface_line_attribute4%type,

Line 346: ra_customer_trx_lines.interface_line_attribute3%type,

342: ra_customer_trx_lines.interface_line_attribute1%type,
343: p_interface_line_attribute2 IN
344: ra_customer_trx_lines.interface_line_attribute2%type,
345: p_interface_line_attribute3 IN
346: ra_customer_trx_lines.interface_line_attribute3%type,
347: p_interface_line_attribute4 IN
348: ra_customer_trx_lines.interface_line_attribute4%type,
349: p_interface_line_attribute5 IN
350: ra_customer_trx_lines.interface_line_attribute5%type,

Line 348: ra_customer_trx_lines.interface_line_attribute4%type,

344: ra_customer_trx_lines.interface_line_attribute2%type,
345: p_interface_line_attribute3 IN
346: ra_customer_trx_lines.interface_line_attribute3%type,
347: p_interface_line_attribute4 IN
348: ra_customer_trx_lines.interface_line_attribute4%type,
349: p_interface_line_attribute5 IN
350: ra_customer_trx_lines.interface_line_attribute5%type,
351: p_interface_line_attribute6 IN
352: ra_customer_trx_lines.interface_line_attribute6%type,

Line 350: ra_customer_trx_lines.interface_line_attribute5%type,

346: ra_customer_trx_lines.interface_line_attribute3%type,
347: p_interface_line_attribute4 IN
348: ra_customer_trx_lines.interface_line_attribute4%type,
349: p_interface_line_attribute5 IN
350: ra_customer_trx_lines.interface_line_attribute5%type,
351: p_interface_line_attribute6 IN
352: ra_customer_trx_lines.interface_line_attribute6%type,
353: p_interface_line_attribute7 IN
354: ra_customer_trx_lines.interface_line_attribute7%type,

Line 352: ra_customer_trx_lines.interface_line_attribute6%type,

348: ra_customer_trx_lines.interface_line_attribute4%type,
349: p_interface_line_attribute5 IN
350: ra_customer_trx_lines.interface_line_attribute5%type,
351: p_interface_line_attribute6 IN
352: ra_customer_trx_lines.interface_line_attribute6%type,
353: p_interface_line_attribute7 IN
354: ra_customer_trx_lines.interface_line_attribute7%type,
355: p_interface_line_attribute8 IN
356: ra_customer_trx_lines.interface_line_attribute8%type,

Line 354: ra_customer_trx_lines.interface_line_attribute7%type,

350: ra_customer_trx_lines.interface_line_attribute5%type,
351: p_interface_line_attribute6 IN
352: ra_customer_trx_lines.interface_line_attribute6%type,
353: p_interface_line_attribute7 IN
354: ra_customer_trx_lines.interface_line_attribute7%type,
355: p_interface_line_attribute8 IN
356: ra_customer_trx_lines.interface_line_attribute8%type,
357: p_interface_line_attribute9 IN
358: ra_customer_trx_lines.interface_line_attribute9%type,

Line 356: ra_customer_trx_lines.interface_line_attribute8%type,

352: ra_customer_trx_lines.interface_line_attribute6%type,
353: p_interface_line_attribute7 IN
354: ra_customer_trx_lines.interface_line_attribute7%type,
355: p_interface_line_attribute8 IN
356: ra_customer_trx_lines.interface_line_attribute8%type,
357: p_interface_line_attribute9 IN
358: ra_customer_trx_lines.interface_line_attribute9%type,
359: p_interface_line_attribute10 IN
360: ra_customer_trx_lines.interface_line_attribute10%type,

Line 358: ra_customer_trx_lines.interface_line_attribute9%type,

354: ra_customer_trx_lines.interface_line_attribute7%type,
355: p_interface_line_attribute8 IN
356: ra_customer_trx_lines.interface_line_attribute8%type,
357: p_interface_line_attribute9 IN
358: ra_customer_trx_lines.interface_line_attribute9%type,
359: p_interface_line_attribute10 IN
360: ra_customer_trx_lines.interface_line_attribute10%type,
361: p_interface_line_attribute11 IN
362: ra_customer_trx_lines.interface_line_attribute11%type,

Line 360: ra_customer_trx_lines.interface_line_attribute10%type,

356: ra_customer_trx_lines.interface_line_attribute8%type,
357: p_interface_line_attribute9 IN
358: ra_customer_trx_lines.interface_line_attribute9%type,
359: p_interface_line_attribute10 IN
360: ra_customer_trx_lines.interface_line_attribute10%type,
361: p_interface_line_attribute11 IN
362: ra_customer_trx_lines.interface_line_attribute11%type,
363: p_interface_line_attribute12 IN
364: ra_customer_trx_lines.interface_line_attribute12%type,

Line 362: ra_customer_trx_lines.interface_line_attribute11%type,

358: ra_customer_trx_lines.interface_line_attribute9%type,
359: p_interface_line_attribute10 IN
360: ra_customer_trx_lines.interface_line_attribute10%type,
361: p_interface_line_attribute11 IN
362: ra_customer_trx_lines.interface_line_attribute11%type,
363: p_interface_line_attribute12 IN
364: ra_customer_trx_lines.interface_line_attribute12%type,
365: p_interface_line_attribute13 IN
366: ra_customer_trx_lines.interface_line_attribute13%type,

Line 364: ra_customer_trx_lines.interface_line_attribute12%type,

360: ra_customer_trx_lines.interface_line_attribute10%type,
361: p_interface_line_attribute11 IN
362: ra_customer_trx_lines.interface_line_attribute11%type,
363: p_interface_line_attribute12 IN
364: ra_customer_trx_lines.interface_line_attribute12%type,
365: p_interface_line_attribute13 IN
366: ra_customer_trx_lines.interface_line_attribute13%type,
367: p_interface_line_attribute14 IN
368: ra_customer_trx_lines.interface_line_attribute14%type,

Line 366: ra_customer_trx_lines.interface_line_attribute13%type,

362: ra_customer_trx_lines.interface_line_attribute11%type,
363: p_interface_line_attribute12 IN
364: ra_customer_trx_lines.interface_line_attribute12%type,
365: p_interface_line_attribute13 IN
366: ra_customer_trx_lines.interface_line_attribute13%type,
367: p_interface_line_attribute14 IN
368: ra_customer_trx_lines.interface_line_attribute14%type,
369: p_interface_line_attribute15 IN
370: ra_customer_trx_lines.interface_line_attribute15%type,

Line 368: ra_customer_trx_lines.interface_line_attribute14%type,

364: ra_customer_trx_lines.interface_line_attribute12%type,
365: p_interface_line_attribute13 IN
366: ra_customer_trx_lines.interface_line_attribute13%type,
367: p_interface_line_attribute14 IN
368: ra_customer_trx_lines.interface_line_attribute14%type,
369: p_interface_line_attribute15 IN
370: ra_customer_trx_lines.interface_line_attribute15%type,
371: p_default_ussgl_code_context IN
372: ra_customer_trx_lines.default_ussgl_trx_code_context%type,

Line 370: ra_customer_trx_lines.interface_line_attribute15%type,

366: ra_customer_trx_lines.interface_line_attribute13%type,
367: p_interface_line_attribute14 IN
368: ra_customer_trx_lines.interface_line_attribute14%type,
369: p_interface_line_attribute15 IN
370: ra_customer_trx_lines.interface_line_attribute15%type,
371: p_default_ussgl_code_context IN
372: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
373: p_default_ussgl_trx_code IN
374: ra_customer_trx_lines.default_ussgl_transaction_code%type,

Line 372: ra_customer_trx_lines.default_ussgl_trx_code_context%type,

368: ra_customer_trx_lines.interface_line_attribute14%type,
369: p_interface_line_attribute15 IN
370: ra_customer_trx_lines.interface_line_attribute15%type,
371: p_default_ussgl_code_context IN
372: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
373: p_default_ussgl_trx_code IN
374: ra_customer_trx_lines.default_ussgl_transaction_code%type,
375: p_trx_class IN ra_cust_trx_types.type%type,
376: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 374: ra_customer_trx_lines.default_ussgl_transaction_code%type,

370: ra_customer_trx_lines.interface_line_attribute15%type,
371: p_default_ussgl_code_context IN
372: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
373: p_default_ussgl_trx_code IN
374: ra_customer_trx_lines.default_ussgl_transaction_code%type,
375: p_trx_class IN ra_cust_trx_types.type%type,
376: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
377: p_frt_ccid IN
378: ra_cust_trx_line_gl_dist.code_combination_id%type,

Line 384: l_frt_rec ra_customer_trx_lines%rowtype;

380: p_open_rec_flag IN varchar2,
381: p_status OUT NOCOPY varchar2)
382: IS
383:
384: l_frt_rec ra_customer_trx_lines%rowtype;
385:
386: BEGIN
387:
388: IF PG_DEBUG in ('Y', 'C') THEN