APPS.JAI_OPEN_API_PKG dependencies on JAI_CMN_TAXES_ALL

Line 93: tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE

89: GV_PERIOD_FUTURE_STATUS VARCHAR2(10) := 'F';
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

Line 105: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%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
109: , tax_type_val NUMBER

Line 106: , tax_amount JAI_CMN_TAXES_ALL.tax_amount%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
109: , tax_type_val NUMBER
110: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%TYPE

Line 107: , uom_code JAI_CMN_TAXES_ALL.uom_code%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
109: , tax_type_val NUMBER
110: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%TYPE
111: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%TYPE

Line 108: , valid_date JAI_CMN_TAXES_ALL.end_date%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
109: , tax_type_val NUMBER
110: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%TYPE
111: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%TYPE
112: , tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE

Line 110: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%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
109: , tax_type_val NUMBER
110: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%TYPE
111: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%TYPE
112: , tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE
113: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%TYPE
114: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%TYPE

Line 111: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%TYPE

107: , uom_code JAI_CMN_TAXES_ALL.uom_code%TYPE
108: , valid_date JAI_CMN_TAXES_ALL.end_date%TYPE
109: , tax_type_val NUMBER
110: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%TYPE
111: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%TYPE
112: , tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE
113: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%TYPE
114: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%TYPE
115: , tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%TYPE

Line 112: , tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE

108: , valid_date JAI_CMN_TAXES_ALL.end_date%TYPE
109: , tax_type_val NUMBER
110: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%TYPE
111: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%TYPE
112: , tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE
113: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%TYPE
114: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%TYPE
115: , tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%TYPE
116: , inclusive_tax_flag JAI_CMN_TAXES_ALL.inclusive_tax_flag%TYPE

Line 113: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%TYPE

109: , tax_type_val NUMBER
110: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%TYPE
111: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%TYPE
112: , tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE
113: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%TYPE
114: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%TYPE
115: , tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%TYPE
116: , inclusive_tax_flag JAI_CMN_TAXES_ALL.inclusive_tax_flag%TYPE
117: , qty_rate number --Added by zhiwei for Bug#12604133 on 20110623

Line 114: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%TYPE

110: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%TYPE
111: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%TYPE
112: , tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE
113: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%TYPE
114: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%TYPE
115: , tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%TYPE
116: , inclusive_tax_flag JAI_CMN_TAXES_ALL.inclusive_tax_flag%TYPE
117: , qty_rate number --Added by zhiwei for Bug#12604133 on 20110623
118: , vat_flag JAI_CMN_TAXES_ALL.vat_flag%type--Added by zhiwei for Bug#12604133 on 20110623

Line 116: , inclusive_tax_flag JAI_CMN_TAXES_ALL.inclusive_tax_flag%TYPE

112: , tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE
113: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%TYPE
114: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%TYPE
115: , tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%TYPE
116: , inclusive_tax_flag JAI_CMN_TAXES_ALL.inclusive_tax_flag%TYPE
117: , qty_rate number --Added by zhiwei for Bug#12604133 on 20110623
118: , vat_flag JAI_CMN_TAXES_ALL.vat_flag%type--Added by zhiwei for Bug#12604133 on 20110623
119: );
120:

Line 118: , vat_flag JAI_CMN_TAXES_ALL.vat_flag%type--Added by zhiwei for Bug#12604133 on 20110623

114: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%TYPE
115: , tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%TYPE
116: , inclusive_tax_flag JAI_CMN_TAXES_ALL.inclusive_tax_flag%TYPE
117: , qty_rate number --Added by zhiwei for Bug#12604133 on 20110623
118: , vat_flag JAI_CMN_TAXES_ALL.vat_flag%type--Added by zhiwei for Bug#12604133 on 20110623
119: );
120:
121:
122: TYPE tax_typ IS RECORD

Line 126: , tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE

122: TYPE tax_typ IS RECORD
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

Line 137: , tax_type JAI_CMN_TAXES_ALL.tax_type%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
141: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%TYPE

Line 138: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%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
141: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%TYPE
142: , qty_rate number --Added by zhiwei for Bug#12604133 on 20110623

Line 139: , uom_code JAI_CMN_TAXES_ALL.uom_code%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
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

Line 140: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%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
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

Line 141: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%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
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