APPS.PA_FAXFACE dependencies on PA_MC_PRJ_AST_LINES_ALL

Line 1212: DELETE PA_MC_PRJ_AST_LINES_ALL

1208:
1209: IF l_mrc_flag = 'Y' THEN
1210: x_err_stage := 'Deleting the ALC project asset line';
1211:
1212: DELETE PA_MC_PRJ_AST_LINES_ALL
1213: WHERE project_asset_line_id = x_project_asset_line_id;
1214: END IF;
1215:
1216: EXCEPTION

Line 6508: FROM PA_MC_PRJ_AST_LINES_ALL

6504: -- current_asset_cost commented as part of the bug 14128696
6505: current_asset_cost*-1 -- added as part of the bug 14128696
6506: INTO l_orig_asset_cost,
6507: l_curr_asset_cost
6508: FROM PA_MC_PRJ_AST_LINES_ALL
6509: WHERE set_of_books_id = v_alc_ledger.ledger_id
6510: AND project_asset_line_id = x_rev_proj_asset_line_id;
6511:
6512: ELSIF (x_original_asset_cost <> x_current_asset_cost) THEN

Line 6522: FROM PA_MC_PRJ_AST_LINES_ALL

6518: SELECT original_asset_cost,
6519: sum(current_asset_cost)
6520: INTO l_orig_asset_cost,
6521: l_curr_asset_cost
6522: FROM PA_MC_PRJ_AST_LINES_ALL
6523: WHERE set_of_books_id = v_alc_ledger.ledger_id
6524: AND project_asset_line_detail_id = x_project_asset_line_detail_id
6525: GROUP BY original_asset_cost;
6526:

Line 6544: INSERT into PA_MC_PRJ_AST_LINES_ALL

6540: l_curr_asset_cost := l_orig_asset_cost;
6541:
6542: END IF;
6543:
6544: INSERT into PA_MC_PRJ_AST_LINES_ALL
6545: (
6546: SET_OF_BOOKS_ID,
6547: PROJECT_ASSET_LINE_ID,
6548: ORIGINAL_ASSET_COST,

Line 6592: UPDATE PA_MC_PRJ_AST_LINES_ALL

6588: begin
6589:
6590: FOR v_alc_ledger IN c_alc_ledger LOOP
6591:
6592: UPDATE PA_MC_PRJ_AST_LINES_ALL
6593: SET current_asset_cost = pa_mc_currency_pkg.CurrRound((l_cost_ratio*original_asset_cost),
6594: v_alc_ledger.currency_code)
6595: WHERE project_asset_line_id = x_project_asset_line_id
6596: AND set_of_books_id = v_alc_ledger.ledger_id;

Line 6636: FROM PA_MC_PRJ_AST_LINES_ALL

6632: l_exchange_rate := 0;
6633: ELSE
6634: SELECT current_asset_cost
6635: INTO l_fixed_assets_alc_cost
6636: FROM PA_MC_PRJ_AST_LINES_ALL
6637: WHERE project_asset_line_id = x_project_asset_line_id
6638: AND set_of_books_id = v_alc_ledger.ledger_id;
6639:
6640: l_exchange_rate := l_fixed_assets_alc_cost/x_fixed_assets_cost;