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 1247: from ar_app_rule_details

1243: and overapp_flag = 'Y' ;
1244:
1245: cursor all_block (p_rule_id in ar_app_rules.rule_id%TYPE) is
1246: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1247: from ar_app_rule_details
1248: where rule_id = p_rule_id ;
1249:
1250: cursor round_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is
1251: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment

Line 1252: from ar_app_rule_details

1248: where rule_id = p_rule_id ;
1249:
1250: cursor round_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is
1251: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1252: from ar_app_rule_details
1253: where rule_id = p_rule_id
1254: and rounding_correction_flag = 'Y';
1255:
1256: cursor other_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is

Line 1258: from ar_app_rule_details

1254: and rounding_correction_flag = 'Y';
1255:
1256: cursor other_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is
1257: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1258: from ar_app_rule_details
1259: where rule_id = p_rule_id
1260: and rounding_correction_flag <> 'Y';
1261:
1262: cursor over_app_lines (p_rule_id in number ) is

Line 1264: from ar_app_rule_details

1260: and rounding_correction_flag <> 'Y';
1261:
1262: cursor over_app_lines (p_rule_id in number ) is
1263: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1264: from ar_app_rule_details
1265: where rule_id = p_rule_id;
1266:
1267:
1268: l_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';

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

1264: from ar_app_rule_details
1265: where rule_id = p_rule_id;
1266:
1267:
1268: l_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1269: l_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1270: l_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1271: o_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1272: o_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';

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

1265: where rule_id = p_rule_id;
1266:
1267:
1268: l_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1269: l_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1270: l_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1271: o_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1272: o_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1273: o_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';

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

1266:
1267:
1268: l_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1269: l_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1270: l_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1271: o_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1272: o_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1273: o_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1274:

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

1267:
1268: l_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1269: l_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1270: l_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1271: o_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1272: o_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1273: o_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1274:
1275: l_source long;

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

1268: l_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1269: l_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1270: l_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1271: o_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1272: o_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1273: o_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1274:
1275: l_source long;
1276: l_round_minus long;

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

1269: l_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1270: l_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1271: o_line_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1272: o_freight_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1273: o_charges_tax_treatment ar_app_rule_details.tax_treatment%TYPE:='NONE';
1274:
1275: l_source long;
1276: l_round_minus long;
1277: l_counter number:=0;