APPS.PA_FI_AMT_CALC_PKG dependencies on PA_FI_AMOUNT_DTLS_TMP

Line 1428: DELETE FROM Pa_Fi_Amount_Dtls_Tmp;

1424: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1425: END IF;
1426:
1427:
1428: DELETE FROM Pa_Fi_Amount_Dtls_Tmp;
1429: COMMIT;
1430:
1431:
1432: /* Forecast Item records should be locked to prevent Update from

Line 2702: INSERT INTO Pa_Fi_Amount_Dtls_Tmp(

2698: END LOOP;
2699:
2700: IF l_call_tp_api_flag = 'Y' THEN
2701: FORALL b_tmp IN 1 .. l_fi_id_tab.COUNT
2702: INSERT INTO Pa_Fi_Amount_Dtls_Tmp(
2703: FORECAST_ITEM_ID ,
2704: ITEM_DATE ,
2705: ITEM_UOM ,
2706: ITEM_QUANTITY ,

Line 3163: lx_cc_markup_basecode FROM Pa_Fi_Amount_Dtls_Tmp WHERE

3159: lx_tp_bill_markup_percent,
3160: lx_tp_sch_line_percent,
3161: lx_tp_rule_percent,
3162: lx_tp_job_id,
3163: lx_cc_markup_basecode FROM Pa_Fi_Amount_Dtls_Tmp WHERE
3164: Tp_Error_Code IS NULL;
3165:
3166: l_tp_array_size := l_fi_date_tab.count;
3167:

Line 3357: UPDATE Pa_Fi_Amount_Dtls_Tmp SET

3353: END IF;
3354: /* dbms_output.put_line('aft calling trf price'); */
3355:
3356: FORALL l_trf_upd IN 1 .. l_fi_date_tab.COUNT
3357: UPDATE Pa_Fi_Amount_Dtls_Tmp SET
3358: TP_TXN_CURRENCY_CODE_out = lx_denom_tp_currcode(l_trf_upd),
3359: TXN_TRANSFER_PRICE = lx_denom_tp_amt(l_trf_upd),
3360: PROJECT_TP_RATE_DATE = lx_proj_tp_rate_date(l_trf_upd),
3361: PROJECT_TP_RATE_TYPE = lx_proj_tp_rate_type(l_trf_upd),

Line 3653: lx_cc_markup_basecode FROM Pa_Fi_Amount_Dtls_Tmp;

3649: lx_tp_bill_markup_percent,
3650: lx_tp_sch_line_percent,
3651: lx_tp_rule_percent,
3652: lx_tp_job_id,
3653: lx_cc_markup_basecode FROM Pa_Fi_Amount_Dtls_Tmp;
3654:
3655: FOR l_trf_err_idx IN 1 .. l_fi_id_tab.COUNT LOOP
3656: IF lx_tp_error_code(l_trf_err_idx) IS NOT NULL AND
3657: lx_tp_error_code(l_trf_err_idx) <> 'E' THEN