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_APP_CALC_PKG dependencies on AR_APP_RULE_DETAILS

Line 1237: from ar_app_rule_details

1233: and overapp_flag = 'Y' ;
1234:
1235: cursor all_block (p_rule_id in ar_app_rules.rule_id%TYPE) is
1236: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1237: from ar_app_rule_details
1238: where rule_id = p_rule_id ;
1239:
1240: cursor round_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is
1241: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment

Line 1242: from ar_app_rule_details

1238: where rule_id = p_rule_id ;
1239:
1240: cursor round_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is
1241: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1242: from ar_app_rule_details
1243: where rule_id = p_rule_id
1244: and rounding_correction_flag = 'Y';
1245:
1246: cursor other_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is

Line 1248: from ar_app_rule_details

1244: and rounding_correction_flag = 'Y';
1245:
1246: cursor other_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is
1247: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1248: from ar_app_rule_details
1249: where rule_id = p_rule_id
1250: and rounding_correction_flag <> 'Y';
1251:
1252: cursor over_app_lines (p_rule_id in number ) is

Line 1254: from ar_app_rule_details

1250: and rounding_correction_flag <> 'Y';
1251:
1252: cursor over_app_lines (p_rule_id in number ) is
1253: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1254: from ar_app_rule_details
1255: where rule_id = p_rule_id;
1256:
1257:
1258: l_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';

Line 1258: l_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';

1254: from ar_app_rule_details
1255: where rule_id = p_rule_id;
1256:
1257:
1258: l_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1259: l_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1260: l_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1261: o_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1262: o_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';

Line 1259: l_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';

1255: where rule_id = p_rule_id;
1256:
1257:
1258: l_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1259: l_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1260: l_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1261: o_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1262: o_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1263: o_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';

Line 1260: l_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';

1256:
1257:
1258: l_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1259: l_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1260: l_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1261: o_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1262: o_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1263: o_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1264:

Line 1261: o_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';

1257:
1258: l_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1259: l_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1260: l_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1261: o_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1262: o_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1263: o_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1264:
1265: l_source long;

Line 1262: o_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';

1258: l_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1259: l_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1260: l_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1261: o_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1262: o_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1263: o_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1264:
1265: l_source long;
1266: l_round_minus long;

Line 1263: o_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';

1259: l_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1260: l_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1261: o_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1262: o_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1263: o_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1264:
1265: l_source long;
1266: l_round_minus long;
1267: l_counter number:=0;