APPS.PA_ASSET_ALLOCATION_PVT dependencies on PA_PROJECT_ASSET_LINES_ALL

Line 552: UPDATE pa_project_asset_lines_all

548:
549:
550: --Assign current UNASSIGNED asset line to current project asset
551:
552: UPDATE pa_project_asset_lines_all
553: SET project_asset_id = asset_basis_table(i).PROJECT_ASSET_ID,
554: last_update_date = SYSDATE,
555: last_updated_by = v_user,
556: last_update_login = v_login,

Line 568: FROM pa_project_asset_lines_all

564:
565: --Get the current asset cost of the UNASSIGNED asset line in order to determine the remaining amount
566: SELECT current_asset_cost
567: INTO v_current_asset_cost
568: FROM pa_project_asset_lines_all
569: WHERE project_asset_line_id = p_project_asset_line_id;
570:
571: --Call procedure to add this amount to the Grouped CIP Amount of the asset
572: PA_FAXFACE.update_asset_cost

Line 862: FROM pa_project_asset_lines_all

858: --Get CURRENT and not original cost, in case the user has previously done a manual split on the line
859: --This program will allocate the current cost of any UNASSIGNED lines across project assets
860: SELECT current_asset_cost --NOT original_asset_cost, in case of prior manual splits
861: INTO v_original_asset_cost
862: FROM pa_project_asset_lines_all
863: WHERE project_asset_line_id = p_project_asset_line_id;
864:
865: --Initialize allocation variables
866: v_project_asset_line_id := p_project_asset_line_id;

Line 886: UPDATE pa_project_asset_lines_all

882: IF i = asset_basis_table.LAST THEN
883:
884: --Assign current UNASSIGNED asset line to current project asset
885:
886: UPDATE pa_project_asset_lines_all
887: SET project_asset_id = asset_basis_table(i).PROJECT_ASSET_ID,
888: last_update_date = SYSDATE,
889: last_updated_by = v_user,
890: last_update_login = v_login,

Line 903: FROM pa_project_asset_lines_all

899:
900: --Get the current asset cost of the UNASSIGNED asset line in order to determine the remaining amount
901: SELECT current_asset_cost
902: INTO v_current_asset_cost
903: FROM pa_project_asset_lines_all
904: WHERE project_asset_line_id = v_project_asset_line_id;
905:
906: --Call procedure to add this amount to the Grouped CIP Amount of the asset
907: PA_FAXFACE.update_asset_cost

Line 935: FROM pa_project_asset_lines_all

931:
932: --Get the current asset cost of the UNASSIGNED asset line in order to determine the remaining amount
933: SELECT current_asset_cost, project_asset_line_detail_id, rev_proj_asset_line_id, original_asset_cost /*Bug 4914051*/
934: INTO v_current_asset_cost, v_project_asset_line_detail_id, v_rev_proj_asset_line_id, v_orig_cost
935: FROM pa_project_asset_lines_all
936: WHERE project_asset_line_id = v_project_asset_line_id;
937:
938:
939: --Calculate the remaining amount

Line 944: UPDATE pa_project_asset_lines_all

940: v_remaining_cost := v_current_asset_cost - v_current_cost;
941:
942:
943: --Update current UNASSIGNED asset line
944: UPDATE pa_project_asset_lines_all
945: SET project_asset_id = asset_basis_table(i).PROJECT_ASSET_ID,
946: current_asset_cost = v_current_cost,
947: last_update_date = SYSDATE,
948: last_updated_by = v_user,

Line 984: INSERT INTO pa_project_asset_lines_all(

980: FROM SYS.DUAL;
981:
982:
983: --Create new UNASSIGNED asset line
984: INSERT INTO pa_project_asset_lines_all(
985: project_asset_line_id,
986: description,
987: project_asset_id,
988: project_id,

Line 1069: FROM pa_project_asset_lines_all pal_rec

1065: pal_rec.original_asset_id,
1066: pal_rec.line_type,
1067: pal_rec.capital_event_id,
1068: pal_rec.retirement_cost_type
1069: FROM pa_project_asset_lines_all pal_rec
1070: WHERE project_asset_line_id = v_src_project_asset_line_id;
1071:
1072: IF l_mrc_flag = 'Y' THEN /*Bug 4914051*/
1073: PA_FAXFACE.create_alc_proj_asset_lines (v_project_asset_line_id,