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.PA_BC_COSTING dependencies on PA_COST_DISTRIBUTION_LINES

Line 26: g_created_by pa_cost_distribution_lines.created_by%TYPE := FND_GLOBAL.USER_ID;

22:
23: /*
24: * Package level variables.
25: */
26: g_created_by pa_cost_distribution_lines.created_by%TYPE := FND_GLOBAL.USER_ID;
27: g_last_updated_by pa_expenditure_items.last_updated_by%TYPE := FND_GLOBAL.USER_ID;
28: g_last_update_login pa_expenditure_items.last_update_login%TYPE := FND_GLOBAL.LOGIN_ID;
29: g_request_id pa_cost_distribution_lines.request_id%TYPE ;
30: g_program_application_id pa_cost_distribution_lines.program_application_id%TYPE := FND_GLOBAL.PROG_APPL_ID;

Line 29: g_request_id pa_cost_distribution_lines.request_id%TYPE ;

25: */
26: g_created_by pa_cost_distribution_lines.created_by%TYPE := FND_GLOBAL.USER_ID;
27: g_last_updated_by pa_expenditure_items.last_updated_by%TYPE := FND_GLOBAL.USER_ID;
28: g_last_update_login pa_expenditure_items.last_update_login%TYPE := FND_GLOBAL.LOGIN_ID;
29: g_request_id pa_cost_distribution_lines.request_id%TYPE ;
30: g_program_application_id pa_cost_distribution_lines.program_application_id%TYPE := FND_GLOBAL.PROG_APPL_ID;
31: g_program_id pa_cost_distribution_lines.program_id%TYPE := FND_GLOBAL.CONC_PROGRAM_ID;
32: g_packet_id pa_bc_packets.packet_id%TYPE;
33: g_sob_id pa_implementations.set_of_books_id%TYPE;

Line 30: g_program_application_id pa_cost_distribution_lines.program_application_id%TYPE := FND_GLOBAL.PROG_APPL_ID;

26: g_created_by pa_cost_distribution_lines.created_by%TYPE := FND_GLOBAL.USER_ID;
27: g_last_updated_by pa_expenditure_items.last_updated_by%TYPE := FND_GLOBAL.USER_ID;
28: g_last_update_login pa_expenditure_items.last_update_login%TYPE := FND_GLOBAL.LOGIN_ID;
29: g_request_id pa_cost_distribution_lines.request_id%TYPE ;
30: g_program_application_id pa_cost_distribution_lines.program_application_id%TYPE := FND_GLOBAL.PROG_APPL_ID;
31: g_program_id pa_cost_distribution_lines.program_id%TYPE := FND_GLOBAL.CONC_PROGRAM_ID;
32: g_packet_id pa_bc_packets.packet_id%TYPE;
33: g_sob_id pa_implementations.set_of_books_id%TYPE;
34:

Line 31: g_program_id pa_cost_distribution_lines.program_id%TYPE := FND_GLOBAL.CONC_PROGRAM_ID;

27: g_last_updated_by pa_expenditure_items.last_updated_by%TYPE := FND_GLOBAL.USER_ID;
28: g_last_update_login pa_expenditure_items.last_update_login%TYPE := FND_GLOBAL.LOGIN_ID;
29: g_request_id pa_cost_distribution_lines.request_id%TYPE ;
30: g_program_application_id pa_cost_distribution_lines.program_application_id%TYPE := FND_GLOBAL.PROG_APPL_ID;
31: g_program_id pa_cost_distribution_lines.program_id%TYPE := FND_GLOBAL.CONC_PROGRAM_ID;
32: g_packet_id pa_bc_packets.packet_id%TYPE;
33: g_sob_id pa_implementations.set_of_books_id%TYPE;
34:
35: /*

Line 190: ,pa_cost_distribution_lines_all cdl

186: ,'EXP' pkt_reference1
187: ,cdl.expenditure_item_id pkt_reference2
188: ,cdl.line_num pkt_reference3
189: FROM pa_expenditure_items_all ei
190: ,pa_cost_distribution_lines_all cdl
191: ,pa_project_types_all pt
192: ,pa_projects_all p
193: ,pa_expenditures exp
194: ,pa_budget_versions bv

Line 452: FROM pa_cost_distribution_lines_all cdl

448: ,l_document_line_id_tab(l_this_fetch+1)
449: ,l_pkt_reference1_tab(l_this_fetch+1)
450: ,l_pkt_reference2_tab(l_this_fetch+1)
451: ,l_pkt_reference3_tab(l_this_fetch+1)
452: FROM pa_cost_distribution_lines_all cdl
453: ,pa_project_types_all pt
454: ,pa_projects_all p
455: ,pa_budget_versions bv
456: ,pa_budgetary_control_options pbct

Line 915: l_prev_project_id pa_cost_distribution_lines.project_id%TYPE;

911: l_records_processed NUMBER := 0;
912: g_request_id NUMBER := 0;
913: l_debug_stage VARCHAR2(2000);
914:
915: l_prev_project_id pa_cost_distribution_lines.project_id%TYPE;
916: l_prev_flag VARCHAR2(1);
917: l_budget_version_id pa_bc_packets.budget_version_id%TYPE;
918: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
919: l_entry_level_code pa_budget_versions.budget_entry_method_code%TYPE;

Line 921: l_budget_ccid pa_cost_distribution_lines.budget_ccid%TYPE;

917: l_budget_version_id pa_bc_packets.budget_version_id%TYPE;
918: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
919: l_entry_level_code pa_budget_versions.budget_entry_method_code%TYPE;
920: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
921: l_budget_ccid pa_cost_distribution_lines.budget_ccid%TYPE;
922: l_budget_line_id pa_cost_distribution_lines.budget_line_id%TYPE;
923: l_prev_reslist_id Number;
924: l_fnd_reqd_flag VARCHAR2(1);
925:

Line 922: l_budget_line_id pa_cost_distribution_lines.budget_line_id%TYPE;

918: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
919: l_entry_level_code pa_budget_versions.budget_entry_method_code%TYPE;
920: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
921: l_budget_ccid pa_cost_distribution_lines.budget_ccid%TYPE;
922: l_budget_line_id pa_cost_distribution_lines.budget_line_id%TYPE;
923: l_prev_reslist_id Number;
924: l_fnd_reqd_flag VARCHAR2(1);
925:
926: l_return_status VARCHAR2(1);

Line 1318: UPDATE pa_cost_distribution_lines_all cdl

1314: l_debug_stage := TO_CHAR(l_stage) || ':ORACLE error occurred while Bulk updating BC columns in CDL.' ;
1315:
1316: l_stage := 600;
1317: FORALL l_counter IN 1 .. l_records_processed
1318: UPDATE pa_cost_distribution_lines_all cdl
1319: SET cdl.budget_ccid = l_budget_ccid_tab(l_counter)
1320: --r12
1321: ,cdl.budget_version_id = l_budget_ver_id_tab(l_counter)
1322: ,cdl.budget_line_id = l_budget_line_id_tab(l_counter)

Line 1356: DELETE FROM pa_cost_distribution_lines cdl

1352: * Delete the CDLs which failed resource-mapping.
1353: */
1354: l_stage := 800;
1355: FORALL l_counter IN 1 .. l_records_processed
1356: DELETE FROM pa_cost_distribution_lines cdl
1357: WHERE cdl.rowid = l_cdl_rowid_tab(l_counter)
1358: AND l_budget_ccid_tab(l_counter) IS NULL
1359: ;
1360:

Line 1471: FROM pa_cost_distribution_lines cdl

1467: */
1468: l_stage := 300;
1469: FORALL i IN l_rejected_eiid_tab.FIRST .. l_rejected_eiid_tab.LAST
1470: DELETE
1471: FROM pa_cost_distribution_lines cdl
1472: WHERE cdl.request_id = g_request_id
1473: AND cdl.expenditure_item_id = l_rejected_eiid_tab(i)
1474: AND NVL(cdl.reversed_flag, 'N') <> 'Y'
1475: AND cdl.transfer_status_code <> 'V'

Line 1527: UPDATE pa_cost_distribution_lines cdl

1523: * when setting reversed_flag to 'Y'. So, we can make use of that.
1524: */
1525: l_stage := 400;
1526: FORALL i IN l_rejected_eiid_tab.FIRST .. l_rejected_eiid_tab.LAST
1527: UPDATE pa_cost_distribution_lines cdl
1528: SET cdl.reversed_flag = NULL
1529: WHERE NVL(cdl.reversed_flag, 'N') = 'Y'
1530: AND cdl.request_id = g_request_id
1531: AND cdl.expenditure_item_id = l_rejected_eiid_tab(i)

Line 1549: UPDATE pa_cost_distribution_lines cdl

1545: | the parent raw line. |
1546: +=======================================================================*/
1547: l_stage := 500;
1548: FORALL i IN l_del_cdl_eiid_tab.FIRST .. l_del_cdl_eiid_tab.LAST
1549: UPDATE pa_cost_distribution_lines cdl
1550: SET cdl.denom_burdened_change = cdl.denom_burdened_change - l_del_cdl_dbc_tab(i)
1551: ,cdl.acct_burdened_change = cdl.acct_burdened_change - l_del_cdl_abc_tab(i)
1552: ,cdl.projfunc_burdened_change = cdl.projfunc_burdened_change - l_del_cdl_pfbc_tab(i)
1553: ,cdl.project_burdened_change = cdl.project_burdened_change - l_del_cdl_pbc_tab(i)

Line 1619: * The transfer_status_code Join is used to make use of PA_COST_DISTRIBUTION_LINES_N2

1615: * To distinguish a new line from a reversal line, the parent_bc_packet_id
1616: * is inserted as -1 for a new line.
1617: * For a reversal line, the value will be NULL.
1618: *
1619: * The transfer_status_code Join is used to make use of PA_COST_DISTRIBUTION_LINES_N2
1620: * index.
1621: *
1622: * burden_cost_flag is populated 'N' for Raw line.
1623: */

Line 2033: l_prev_project_id pa_cost_distribution_lines.project_id%TYPE;

2029: l_debug_mode VARCHAR2(1) := 'N';
2030: l_records_processed NUMBER := 0;
2031: l_cdls_deleted NUMBER := 0;
2032:
2033: l_prev_project_id pa_cost_distribution_lines.project_id%TYPE;
2034: l_prev_flag VARCHAR2(1);
2035: l_budget_version_id pa_bc_packets.budget_version_id%TYPE;
2036: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2037: l_entry_level_code pa_budget_versions.budget_entry_method_code%TYPE; --???

Line 2039: l_budget_ccid pa_cost_distribution_lines.budget_ccid%TYPE;

2035: l_budget_version_id pa_bc_packets.budget_version_id%TYPE;
2036: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2037: l_entry_level_code pa_budget_versions.budget_entry_method_code%TYPE; --???
2038: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
2039: l_budget_ccid pa_cost_distribution_lines.budget_ccid%TYPE;
2040:
2041: l_fnd_reqd_flag VARCHAR2(1);
2042:
2043: g_request_id NUMBER;

Line 2057: FROM pa_cost_distribution_lines cdl

2053: IS
2054: SELECT cdl.expenditure_item_id expenditure_item_id
2055: ,cdl.budget_ccid budget_ccid
2056: ,cdl.line_num line_num
2057: FROM pa_cost_distribution_lines cdl
2058: ,pa_expenditure_items ei
2059: WHERE (ei.system_linkage_function IN ('VI')
2060: --FP M changes
2061: OR (ei.system_linkage_function in ('ST','OT') AND ei.po_line_id IS NOT NULL))

Line 2083: FROM pa_cost_distribution_lines cdl

2079: CURSOR c2( p_cur_eiid IN NUMBER
2080: ,p_cur_request_id IN NUMBER)
2081: IS
2082: SELECT cdl.dr_code_combination_id
2083: FROM pa_cost_distribution_lines cdl
2084: WHERE cdl.expenditure_item_id = p_cur_eiid
2085: AND cdl.request_id = p_cur_request_id
2086: AND cdl.line_type = 'D'
2087: ;

Line 2228: FROM pa_cost_distribution_lines cdl

2224: * Delete errored CDLs.
2225: */
2226: FORALL i IN 1 .. l_expenditure_item_id_tab.LAST
2227: DELETE
2228: FROM pa_cost_distribution_lines cdl
2229: WHERE cdl.line_type IN ('C', 'D')
2230: AND cdl.request_id = g_request_id
2231: AND cdl.expenditure_item_id = l_expenditure_item_id_tab(i)
2232: AND l_cost_dist_rejection_code_tab(i) IS NOT NULL

Line 2333: ,pa_cost_distribution_lines_all cdl

2329: ,'EXP' reference1
2330: ,cdl.expenditure_item_id reference2
2331: ,cdl.line_num reference3
2332: FROM pa_expenditure_items_all ei
2333: ,pa_cost_distribution_lines_all cdl
2334: ,pa_project_types_all pt
2335: ,pa_projects_all p
2336: ,pa_expenditures exp
2337: ,pa_budget_versions bv

Line 2587: FROM pa_cost_distribution_lines_all cdl

2583: ,l_budget_version_id_tab(l_this_fetch+1)
2584: ,l_pkt_reference1_Tab(l_this_fetch+1)
2585: ,l_pkt_reference2_Tab(l_this_fetch+1)
2586: ,l_pkt_reference3_Tab(l_this_fetch+1)
2587: FROM pa_cost_distribution_lines_all cdl
2588: ,pa_project_types_all pt
2589: ,pa_projects_all p
2590: ,pa_budget_versions bv
2591: ,pa_budgetary_control_options pbct