DBA Data[Home] [Help]

APPS.JAI_OPEN_API_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 94: , lno JAI_CMN_TAX_CTG_LINES.line_no%TYPE

90:
91: TYPE ref_cur_typ IS REF CURSOR;
92: TYPE tax_rec_typ IS RECORD(
93: tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE
94: , lno JAI_CMN_TAX_CTG_LINES.line_no%TYPE
95: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%TYPE
96: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE
97: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
98: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE

Line 95: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%TYPE

91: TYPE ref_cur_typ IS REF CURSOR;
92: TYPE tax_rec_typ IS RECORD(
93: tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE
94: , lno JAI_CMN_TAX_CTG_LINES.line_no%TYPE
95: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%TYPE
96: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE
97: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
98: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
99: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE

Line 96: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE

92: TYPE tax_rec_typ IS RECORD(
93: tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE
94: , lno JAI_CMN_TAX_CTG_LINES.line_no%TYPE
95: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%TYPE
96: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE
97: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
98: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
99: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
100: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE

Line 97: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE

93: tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE
94: , lno JAI_CMN_TAX_CTG_LINES.line_no%TYPE
95: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%TYPE
96: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE
97: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
98: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
99: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
100: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
101: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE

Line 98: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE

94: , lno JAI_CMN_TAX_CTG_LINES.line_no%TYPE
95: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%TYPE
96: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE
97: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
98: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
99: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
100: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
101: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
102: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE

Line 99: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE

95: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%TYPE
96: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE
97: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
98: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
99: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
100: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
101: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
102: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE
103: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE

Line 100: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE

96: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE
97: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
98: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
99: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
100: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
101: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
102: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE
103: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE
104: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%TYPE

Line 101: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE

97: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
98: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
99: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
100: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
101: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
102: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE
103: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE
104: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%TYPE
105: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE

Line 102: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE

98: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
99: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
100: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
101: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
102: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE
103: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE
104: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%TYPE
105: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE
106: , tax_amount JAI_CMN_TAXES_ALL.tax_amount%TYPE

Line 103: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE

99: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
100: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
101: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
102: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE
103: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE
104: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%TYPE
105: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE
106: , tax_amount JAI_CMN_TAXES_ALL.tax_amount%TYPE
107: , uom_code JAI_CMN_TAXES_ALL.uom_code%TYPE

Line 104: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%TYPE

100: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
101: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
102: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE
103: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE
104: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%TYPE
105: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE
106: , tax_amount JAI_CMN_TAXES_ALL.tax_amount%TYPE
107: , uom_code JAI_CMN_TAXES_ALL.uom_code%TYPE
108: , valid_date JAI_CMN_TAXES_ALL.end_date%TYPE

Line 127: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%TYPE

123: ( internal_trx_id jai_interface_lines_all.internal_trx_id%TYPE
124: , internal_trx_line_id jai_interface_lines_all.internal_trx_line_id%TYPE
125: , interface_line_id jai_interface_lines_all.interface_line_id%TYPE
126: , tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE
127: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%TYPE
128: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE
129: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
130: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
131: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE

Line 128: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE

124: , internal_trx_line_id jai_interface_lines_all.internal_trx_line_id%TYPE
125: , interface_line_id jai_interface_lines_all.interface_line_id%TYPE
126: , tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE
127: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%TYPE
128: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE
129: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
130: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
131: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
132: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE

Line 129: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE

125: , interface_line_id jai_interface_lines_all.interface_line_id%TYPE
126: , tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE
127: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%TYPE
128: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE
129: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
130: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
131: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
132: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
133: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE

Line 130: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE

126: , tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE
127: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%TYPE
128: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE
129: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
130: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
131: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
132: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
133: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
134: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE

Line 131: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE

127: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%TYPE
128: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE
129: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
130: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
131: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
132: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
133: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
134: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE
135: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE

Line 132: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE

128: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%TYPE
129: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
130: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
131: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
132: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
133: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
134: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE
135: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE
136: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%TYPE

Line 133: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE

129: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%TYPE
130: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
131: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
132: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
133: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
134: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE
135: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE
136: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%TYPE
137: , tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE

Line 134: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE

130: , p_4 JAI_CMN_TAX_CTG_LINES.precedence_4%TYPE
131: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
132: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
133: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
134: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE
135: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE
136: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%TYPE
137: , tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE
138: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE

Line 135: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE

131: , p_5 JAI_CMN_TAX_CTG_LINES.precedence_5%TYPE
132: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
133: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
134: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE
135: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE
136: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%TYPE
137: , tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE
138: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE
139: , uom_code JAI_CMN_TAXES_ALL.uom_code%TYPE

Line 136: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%TYPE

132: , p_6 JAI_CMN_TAX_CTG_LINES.precedence_6%TYPE
133: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%TYPE
134: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%TYPE
135: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%TYPE
136: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%TYPE
137: , tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE
138: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE
139: , uom_code JAI_CMN_TAXES_ALL.uom_code%TYPE
140: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%TYPE

Line 143: , lno JAI_CMN_TAX_CTG_LINES.line_no%TYPE

139: , uom_code JAI_CMN_TAXES_ALL.uom_code%TYPE
140: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%TYPE
141: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%TYPE
142: , qty_rate number --Added by zhiwei for Bug#12604133 on 20110623
143: , lno JAI_CMN_TAX_CTG_LINES.line_no%TYPE
144: , tax_amount NUMBER
145: , func_tax_amount NUMBER
146: , base_tax_amount NUMBER
147: );