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_ALLOC_RUN dependencies on PA_ALLOC_RUN_RESOURCE_DET

Line 4788: insert into pa_alloc_run_resource_det (

4784: p_res_list_member_id IN NUMBER,
4785: p_resource_percent IN NUMBER)
4786: IS
4787: BEGIN
4788: insert into pa_alloc_run_resource_det (
4789: rule_id,
4790: run_id,
4791: member_type,
4792: resource_list_member_id,

Line 4814: -- Created procedure to perform BULK INSERT into pa_alloc_run_resource_det.

4810: WHEN OTHERS THEN
4811: RAISE;
4812: END;
4813: -- Bug3149853 .Changes done to enhance performance .
4814: -- Created procedure to perform BULK INSERT into pa_alloc_run_resource_det.
4815: Procedure bulk_ins_alloc_run_res(p_run_id IN NUMBER,
4816: p_rule_id IN NUMBER,
4817: p_member_type IN VARCHAR2,
4818: p_res_list_member_id_tab IN pa_plsql_datatypes.IdTabTyp,

Line 4823: insert into pa_alloc_run_resource_det (

4819: p_resource_percent IN NUMBER)
4820: IS
4821: BEGIN
4822: FORALL i IN p_res_list_member_id_tab.first..p_res_list_member_id_tab.last
4823: insert into pa_alloc_run_resource_det (
4824: rule_id,
4825: run_id,
4826: member_type,
4827: resource_list_member_id,

Line 5484: pa_alloc_run_resource_det parr,

5480: ,G_last_updated_by
5481: ,G_last_update_login
5482: from ----Bug Fix: 3634912 :Changed the order of the tables
5483: pa_alloc_run_targets part,
5484: pa_alloc_run_resource_det parr,
5485: pa_resource_accum_details prad,
5486: pa_txn_accum pta
5487: where pta.txn_accum_id = prad.txn_accum_id
5488: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 5568: from pa_alloc_run_resource_det parr,

5564: ,G_created_by
5565: ,G_last_update_date
5566: ,G_last_updated_by
5567: ,G_last_update_login
5568: from pa_alloc_run_resource_det parr,
5569: pa_alloc_run_targets part,
5570: PA_ALLOC_TXN_ACCUM_RBS_V pta
5571: where pta.Rbs_Element_Id = parr.resource_list_member_id
5572: and pta.Project_id = part.project_id

Line 5669: pa_alloc_run_resource_det parr,

5665: ,G_last_updated_by
5666: ,G_last_update_login
5667: from --Bug Fix: 3634912 : Changed the order of the tables.
5668: pa_alloc_run_targets part,
5669: pa_alloc_run_resource_det parr,
5670: pa_resource_accum_details prad,
5671: pa_txn_accum pta
5672: where pta.txn_accum_id = prad.txn_accum_id
5673: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 5734: from pa_alloc_run_resource_det parr,

5730: ,G_created_by
5731: ,G_last_update_date
5732: ,G_last_updated_by
5733: ,G_last_update_login
5734: from pa_alloc_run_resource_det parr,
5735: pa_alloc_run_targets part,
5736: PA_ALLOC_TXN_ACCUM_RBS_V pta
5737: where pta.Rbs_Element_ID = parr.resource_list_member_id
5738: and pta.Project_id = part.project_id

Line 5804: pa_alloc_run_resource_det parr,

5800: ,G_last_updated_by
5801: ,G_last_update_login
5802: from --Bug Fix: 3634912 : Changed the order of tables
5803: pa_alloc_run_targets part,
5804: pa_alloc_run_resource_det parr,
5805: pa_resource_accum_details prad,
5806: pa_txn_accum pta
5807: where pta.txn_accum_id = prad.txn_accum_id
5808: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 5873: from pa_alloc_run_resource_det parr,

5869: ,G_created_by
5870: ,G_last_update_date
5871: ,G_last_updated_by
5872: ,G_last_update_login
5873: from pa_alloc_run_resource_det parr,
5874: pa_alloc_run_targets part,
5875: PA_ALLOC_TXN_ACCUM_RBS_V pta
5876: where pta.Rbs_Element_ID = parr.resource_list_member_id
5877: and pta.Project_id = part.project_id

Line 5971: pa_alloc_run_resource_det parr,

5967: ,G_last_updated_by
5968: ,G_last_update_login
5969: from -- Bug Fix: 3634912 : Changed the order of tables.
5970: pa_alloc_run_targets part,
5971: pa_alloc_run_resource_det parr,
5972: pa_resource_accum_details prad,
5973: pa_txn_accum pta
5974: where pta.txn_accum_id = prad.txn_accum_id
5975: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 6044: from pa_alloc_run_resource_det parr,

6040: ,G_created_by
6041: ,G_last_update_date
6042: ,G_last_updated_by
6043: ,G_last_update_login
6044: from pa_alloc_run_resource_det parr,
6045: pa_alloc_run_targets part,
6046: PA_ALLOC_TXN_ACCUM_RBS_V pta
6047: where pta.Rbs_Element_Id = parr.resource_list_member_id
6048: and pta.Project_id = part.project_id

Line 6238: pa_alloc_run_resource_det parr,

6234: ,G_last_updated_by
6235: ,G_last_update_login
6236: from --Bug Fix: 3634912 : Changed the order of the tables.
6237: pa_alloc_run_sources pars,
6238: pa_alloc_run_resource_det parr,
6239: pa_resource_accum_details prad,
6240: pa_txn_accum pta
6241: where pta.txn_accum_id = prad.txn_accum_id
6242: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 6339: from pa_alloc_run_resource_det parr,

6335: ,G_created_by
6336: ,G_last_update_date
6337: ,G_last_updated_by
6338: ,G_last_update_login
6339: from pa_alloc_run_resource_det parr,
6340: pa_alloc_run_sources pars,
6341: PA_ALLOC_TXN_ACCUM_RBS_V pta
6342: where pta.Rbs_Element_Id = parr.resource_list_member_id
6343: and pta.Project_id = pars.project_id

Line 6454: pa_alloc_run_resource_det parr,

6450: ,G_last_updated_by
6451: ,G_last_update_login
6452: from -- Bug Fix: 3634912 :Changed the order of the tables.
6453: pa_alloc_run_sources pars,
6454: pa_alloc_run_resource_det parr,
6455: pa_resource_accum_details prad,
6456: pa_txn_accum pta
6457: where pta.txn_accum_id = prad.txn_accum_id
6458: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 6533: from pa_alloc_run_resource_det parr,

6529: ,G_created_by
6530: ,G_last_update_date
6531: ,G_last_updated_by
6532: ,G_last_update_login
6533: from pa_alloc_run_resource_det parr,
6534: pa_alloc_run_sources pars,
6535: PA_ALLOC_TXN_ACCUM_RBS_V pta
6536: where pta.Rbs_Element_ID = parr.resource_list_member_id
6537: and pta.Project_id = pars.project_id

Line 6617: pa_alloc_run_resource_det parr,

6613: ,G_last_updated_by
6614: ,G_last_update_login
6615: from --Bug Fix: 3634912 : Changed the order of the tables.
6616: pa_alloc_run_sources pars,
6617: pa_alloc_run_resource_det parr,
6618: pa_resource_accum_details prad,
6619: pa_txn_accum pta
6620: where pta.txn_accum_id = prad.txn_accum_id
6621: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 6700: from pa_alloc_run_resource_det parr,

6696: ,G_created_by
6697: ,G_last_update_date
6698: ,G_last_updated_by
6699: ,G_last_update_login
6700: from pa_alloc_run_resource_det parr,
6701: pa_alloc_run_sources pars,
6702: PA_ALLOC_TXN_ACCUM_RBS_V pta
6703: where pta.Rbs_Element_Id = parr.resource_list_member_id
6704: and pta.Project_id = pars.project_id

Line 6814: pa_alloc_run_resource_det parr,

6810: ,G_last_updated_by
6811: ,G_last_update_login
6812: from --Bug Fix: 3634912 : Changed the order of the tables
6813: pa_alloc_run_sources pars,
6814: pa_alloc_run_resource_det parr,
6815: pa_resource_accum_details prad,
6816: pa_txn_accum pta
6817: where pta.txn_accum_id = prad.txn_accum_id
6818: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 6902: from pa_alloc_run_resource_det parr,

6898: ,G_created_by
6899: ,G_last_update_date
6900: ,G_last_updated_by
6901: ,G_last_update_login
6902: from pa_alloc_run_resource_det parr,
6903: pa_alloc_run_sources pars,
6904: PA_ALLOC_TXN_ACCUM_RBS_V pta
6905: where pta.Rbs_Element_Id = parr.resource_list_member_id
6906: and pta.Project_id = pars.project_id

Line 7014: from pa_alloc_run_resource_det parr,

7010: ,G_created_by
7011: ,G_last_update_date
7012: ,G_last_updated_by
7013: ,G_last_update_login
7014: from pa_alloc_run_resource_det parr,
7015: pa_alloc_run_targets part,
7016: /*** pa_base_budget_by_pa_period_v pbpp *** commented bug 2619977 */
7017: pa_base_finplan_by_pa_period_v pfpp /* added bug 2619977 */
7018: where Decode (

Line 7080: from pa_alloc_run_resource_det parr,

7076: ,G_created_by
7077: ,G_last_update_date
7078: ,G_last_updated_by
7079: ,G_last_update_login
7080: from pa_alloc_run_resource_det parr,
7081: pa_alloc_run_targets part,
7082: /*** pa_base_budget_by_gl_period_v pbpg *** commented bug 2619977 */
7083: /* pa_base_finplan_by_pa_period_v pfpg added bug 2619977 commented bug 2757875 */
7084: pa_base_finplan_by_gl_period_v pfpg /* added bug 2757875 */

Line 7444: from pa_alloc_run_resource_det

7440: ) ;
7441: BEGIN
7442: select count(*)
7443: into v_resource_count
7444: from pa_alloc_run_resource_det
7445: where rule_id = p_rule_id
7446: and run_id = p_run_id
7447: and member_type = 'S';
7448: if v_resource_count = 0 then

Line 9859: -- Delete Transactions from pa_alloc_run_resource_det

9855: /*Code Changes for Bug No.2984871 start */
9856: Commit;
9857: /*Code Changes for Bug No.2984871 end */
9858: End Loop;
9859: -- Delete Transactions from pa_alloc_run_resource_det
9860: While 1=1 Loop /* Bug 2182563 */
9861: Delete from pa_alloc_run_resource_det
9862: where run_id = p_run_id and rownum < 10001;
9863: /* Commented for Bug 2984871 Commit; */

Line 9861: Delete from pa_alloc_run_resource_det

9857: /*Code Changes for Bug No.2984871 end */
9858: End Loop;
9859: -- Delete Transactions from pa_alloc_run_resource_det
9860: While 1=1 Loop /* Bug 2182563 */
9861: Delete from pa_alloc_run_resource_det
9862: where run_id = p_run_id and rownum < 10001;
9863: /* Commented for Bug 2984871 Commit; */
9864: If Sql%Rowcount = 0 Then
9865: Exit;

Line 10009: -- Delete Transactions from pa_alloc_run_resource_det

10005: /*Code Changes for Bug No.2984871 start */
10006: Commit;
10007: /*Code Changes for Bug No.2984871 end */
10008: End Loop;
10009: -- Delete Transactions from pa_alloc_run_resource_det
10010: While 1=1 Loop /* Bug 2182563 */
10011: Delete from pa_alloc_run_resource_det
10012: where run_id = l_run_id and rownum < 10001;
10013: /* Commented for Bug 2984871 Commit; */

Line 10011: Delete from pa_alloc_run_resource_det

10007: /*Code Changes for Bug No.2984871 end */
10008: End Loop;
10009: -- Delete Transactions from pa_alloc_run_resource_det
10010: While 1=1 Loop /* Bug 2182563 */
10011: Delete from pa_alloc_run_resource_det
10012: where run_id = l_run_id and rownum < 10001;
10013: /* Commented for Bug 2984871 Commit; */
10014: If Sql%Rowcount = 0 Then
10015: Exit;