APPS.PA_FAXFACE dependencies on PA_MC_PRJ_AST_LINES_ALL

Line 1154: DELETE PA_MC_PRJ_AST_LINES_ALL

1150:
1151: IF l_mrc_flag = 'Y' THEN
1152: x_err_stage := 'Deleting the ALC project asset line';
1153:
1154: DELETE PA_MC_PRJ_AST_LINES_ALL
1155: WHERE project_asset_line_id = x_project_asset_line_id;
1156: END IF;
1157:
1158: EXCEPTION

Line 6061: FROM PA_MC_PRJ_AST_LINES_ALL

6057: SELECT original_asset_cost,
6058: current_asset_cost
6059: INTO l_orig_asset_cost,
6060: l_curr_asset_cost
6061: FROM PA_MC_PRJ_AST_LINES_ALL
6062: WHERE set_of_books_id = v_alc_ledger.ledger_id
6063: AND project_asset_line_id = x_rev_proj_asset_line_id;
6064:
6065: ELSIF (x_original_asset_cost <> x_current_asset_cost) THEN

Line 6075: FROM PA_MC_PRJ_AST_LINES_ALL

6071: SELECT original_asset_cost,
6072: sum(current_asset_cost)
6073: INTO l_orig_asset_cost,
6074: l_curr_asset_cost
6075: FROM PA_MC_PRJ_AST_LINES_ALL
6076: WHERE set_of_books_id = v_alc_ledger.ledger_id
6077: AND project_asset_line_detail_id = x_project_asset_line_detail_id
6078: GROUP BY original_asset_cost;
6079:

Line 6097: INSERT into PA_MC_PRJ_AST_LINES_ALL

6093: l_curr_asset_cost := l_orig_asset_cost;
6094:
6095: END IF;
6096:
6097: INSERT into PA_MC_PRJ_AST_LINES_ALL
6098: (
6099: SET_OF_BOOKS_ID,
6100: PROJECT_ASSET_LINE_ID,
6101: ORIGINAL_ASSET_COST,

Line 6145: UPDATE PA_MC_PRJ_AST_LINES_ALL

6141: begin
6142:
6143: FOR v_alc_ledger IN c_alc_ledger LOOP
6144:
6145: UPDATE PA_MC_PRJ_AST_LINES_ALL
6146: SET current_asset_cost = pa_mc_currency_pkg.CurrRound((l_cost_ratio*original_asset_cost),
6147: v_alc_ledger.currency_code)
6148: WHERE project_asset_line_id = x_project_asset_line_id
6149: AND set_of_books_id = v_alc_ledger.ledger_id;

Line 6189: FROM PA_MC_PRJ_AST_LINES_ALL

6185: l_exchange_rate := 0;
6186: ELSE
6187: SELECT current_asset_cost
6188: INTO l_fixed_assets_alc_cost
6189: FROM PA_MC_PRJ_AST_LINES_ALL
6190: WHERE project_asset_line_id = x_project_asset_line_id
6191: AND set_of_books_id = v_alc_ledger.ledger_id;
6192:
6193: l_exchange_rate := l_fixed_assets_alc_cost/x_fixed_assets_cost;