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 4811: insert into pa_alloc_run_resource_det (

4807: p_res_list_member_id IN NUMBER,
4808: p_resource_percent IN NUMBER)
4809: IS
4810: BEGIN
4811: insert into pa_alloc_run_resource_det (
4812: rule_id,
4813: run_id,
4814: member_type,
4815: resource_list_member_id,

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

4833: WHEN OTHERS THEN
4834: RAISE;
4835: END;
4836: -- Bug3149853 .Changes done to enhance performance .
4837: -- Created procedure to perform BULK INSERT into pa_alloc_run_resource_det.
4838: Procedure bulk_ins_alloc_run_res(p_run_id IN NUMBER,
4839: p_rule_id IN NUMBER,
4840: p_member_type IN VARCHAR2,
4841: p_res_list_member_id_tab IN pa_plsql_datatypes.IdTabTyp,

Line 4846: insert into pa_alloc_run_resource_det (

4842: p_resource_percent IN NUMBER)
4843: IS
4844: BEGIN
4845: FORALL i IN p_res_list_member_id_tab.first..p_res_list_member_id_tab.last
4846: insert into pa_alloc_run_resource_det (
4847: rule_id,
4848: run_id,
4849: member_type,
4850: resource_list_member_id,

Line 5507: pa_alloc_run_resource_det parr,

5503: ,G_last_updated_by
5504: ,G_last_update_login
5505: from ----Bug Fix: 3634912 :Changed the order of the tables
5506: pa_alloc_run_targets part,
5507: pa_alloc_run_resource_det parr,
5508: pa_resource_accum_details prad,
5509: pa_txn_accum pta
5510: where pta.txn_accum_id = prad.txn_accum_id
5511: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 5591: from pa_alloc_run_resource_det parr,

5587: ,G_created_by
5588: ,G_last_update_date
5589: ,G_last_updated_by
5590: ,G_last_update_login
5591: from pa_alloc_run_resource_det parr,
5592: pa_alloc_run_targets part,
5593: PA_ALLOC_TXN_ACCUM_RBS_V pta
5594: where pta.Rbs_Element_Id = parr.resource_list_member_id
5595: and pta.Project_id = part.project_id

Line 5692: pa_alloc_run_resource_det parr,

5688: ,G_last_updated_by
5689: ,G_last_update_login
5690: from --Bug Fix: 3634912 : Changed the order of the tables.
5691: pa_alloc_run_targets part,
5692: pa_alloc_run_resource_det parr,
5693: pa_resource_accum_details prad,
5694: pa_txn_accum pta
5695: where pta.txn_accum_id = prad.txn_accum_id
5696: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 5757: from pa_alloc_run_resource_det parr,

5753: ,G_created_by
5754: ,G_last_update_date
5755: ,G_last_updated_by
5756: ,G_last_update_login
5757: from pa_alloc_run_resource_det parr,
5758: pa_alloc_run_targets part,
5759: PA_ALLOC_TXN_ACCUM_RBS_V pta
5760: where pta.Rbs_Element_ID = parr.resource_list_member_id
5761: and pta.Project_id = part.project_id

Line 5827: pa_alloc_run_resource_det parr,

5823: ,G_last_updated_by
5824: ,G_last_update_login
5825: from --Bug Fix: 3634912 : Changed the order of tables
5826: pa_alloc_run_targets part,
5827: pa_alloc_run_resource_det parr,
5828: pa_resource_accum_details prad,
5829: pa_txn_accum pta
5830: where pta.txn_accum_id = prad.txn_accum_id
5831: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 5896: from pa_alloc_run_resource_det parr,

5892: ,G_created_by
5893: ,G_last_update_date
5894: ,G_last_updated_by
5895: ,G_last_update_login
5896: from pa_alloc_run_resource_det parr,
5897: pa_alloc_run_targets part,
5898: PA_ALLOC_TXN_ACCUM_RBS_V pta
5899: where pta.Rbs_Element_ID = parr.resource_list_member_id
5900: and pta.Project_id = part.project_id

Line 5994: pa_alloc_run_resource_det parr,

5990: ,G_last_updated_by
5991: ,G_last_update_login
5992: from -- Bug Fix: 3634912 : Changed the order of tables.
5993: pa_alloc_run_targets part,
5994: pa_alloc_run_resource_det parr,
5995: pa_resource_accum_details prad,
5996: pa_txn_accum pta
5997: where pta.txn_accum_id = prad.txn_accum_id
5998: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 6067: from pa_alloc_run_resource_det parr,

6063: ,G_created_by
6064: ,G_last_update_date
6065: ,G_last_updated_by
6066: ,G_last_update_login
6067: from pa_alloc_run_resource_det parr,
6068: pa_alloc_run_targets part,
6069: PA_ALLOC_TXN_ACCUM_RBS_V pta
6070: where pta.Rbs_Element_Id = parr.resource_list_member_id
6071: and pta.Project_id = part.project_id

Line 6261: pa_alloc_run_resource_det parr,

6257: ,G_last_updated_by
6258: ,G_last_update_login
6259: from --Bug Fix: 3634912 : Changed the order of the tables.
6260: pa_alloc_run_sources pars,
6261: pa_alloc_run_resource_det parr,
6262: pa_resource_accum_details prad,
6263: pa_txn_accum pta
6264: where pta.txn_accum_id = prad.txn_accum_id
6265: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 6362: from pa_alloc_run_resource_det parr,

6358: ,G_created_by
6359: ,G_last_update_date
6360: ,G_last_updated_by
6361: ,G_last_update_login
6362: from pa_alloc_run_resource_det parr,
6363: pa_alloc_run_sources pars,
6364: PA_ALLOC_TXN_ACCUM_RBS_V pta
6365: where pta.Rbs_Element_Id = parr.resource_list_member_id
6366: and pta.Project_id = pars.project_id

Line 6477: pa_alloc_run_resource_det parr,

6473: ,G_last_updated_by
6474: ,G_last_update_login
6475: from -- Bug Fix: 3634912 :Changed the order of the tables.
6476: pa_alloc_run_sources pars,
6477: pa_alloc_run_resource_det parr,
6478: pa_resource_accum_details prad,
6479: pa_txn_accum pta
6480: where pta.txn_accum_id = prad.txn_accum_id
6481: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 6556: from pa_alloc_run_resource_det parr,

6552: ,G_created_by
6553: ,G_last_update_date
6554: ,G_last_updated_by
6555: ,G_last_update_login
6556: from pa_alloc_run_resource_det parr,
6557: pa_alloc_run_sources pars,
6558: PA_ALLOC_TXN_ACCUM_RBS_V pta
6559: where pta.Rbs_Element_ID = parr.resource_list_member_id
6560: and pta.Project_id = pars.project_id

Line 6640: pa_alloc_run_resource_det parr,

6636: ,G_last_updated_by
6637: ,G_last_update_login
6638: from --Bug Fix: 3634912 : Changed the order of the tables.
6639: pa_alloc_run_sources pars,
6640: pa_alloc_run_resource_det parr,
6641: pa_resource_accum_details prad,
6642: pa_txn_accum pta
6643: where pta.txn_accum_id = prad.txn_accum_id
6644: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 6723: from pa_alloc_run_resource_det parr,

6719: ,G_created_by
6720: ,G_last_update_date
6721: ,G_last_updated_by
6722: ,G_last_update_login
6723: from pa_alloc_run_resource_det parr,
6724: pa_alloc_run_sources pars,
6725: PA_ALLOC_TXN_ACCUM_RBS_V pta
6726: where pta.Rbs_Element_Id = parr.resource_list_member_id
6727: and pta.Project_id = pars.project_id

Line 6837: pa_alloc_run_resource_det parr,

6833: ,G_last_updated_by
6834: ,G_last_update_login
6835: from --Bug Fix: 3634912 : Changed the order of the tables
6836: pa_alloc_run_sources pars,
6837: pa_alloc_run_resource_det parr,
6838: pa_resource_accum_details prad,
6839: pa_txn_accum pta
6840: where pta.txn_accum_id = prad.txn_accum_id
6841: and prad.Resource_list_member_id = parr.resource_list_member_id

Line 6925: from pa_alloc_run_resource_det parr,

6921: ,G_created_by
6922: ,G_last_update_date
6923: ,G_last_updated_by
6924: ,G_last_update_login
6925: from pa_alloc_run_resource_det parr,
6926: pa_alloc_run_sources pars,
6927: PA_ALLOC_TXN_ACCUM_RBS_V pta
6928: where pta.Rbs_Element_Id = parr.resource_list_member_id
6929: and pta.Project_id = pars.project_id

Line 7037: from pa_alloc_run_resource_det parr,

7033: ,G_created_by
7034: ,G_last_update_date
7035: ,G_last_updated_by
7036: ,G_last_update_login
7037: from pa_alloc_run_resource_det parr,
7038: pa_alloc_run_targets part,
7039: /*** pa_base_budget_by_pa_period_v pbpp *** commented bug 2619977 */
7040: pa_base_finplan_by_pa_period_v pfpp /* added bug 2619977 */
7041: where Decode (

Line 7103: from pa_alloc_run_resource_det parr,

7099: ,G_created_by
7100: ,G_last_update_date
7101: ,G_last_updated_by
7102: ,G_last_update_login
7103: from pa_alloc_run_resource_det parr,
7104: pa_alloc_run_targets part,
7105: /*** pa_base_budget_by_gl_period_v pbpg *** commented bug 2619977 */
7106: /* pa_base_finplan_by_pa_period_v pfpg added bug 2619977 commented bug 2757875 */
7107: pa_base_finplan_by_gl_period_v pfpg /* added bug 2757875 */

Line 7505: from pa_alloc_run_resource_det

7501: ) ;
7502: BEGIN
7503: select count(*)
7504: into v_resource_count
7505: from pa_alloc_run_resource_det
7506: where rule_id = p_rule_id
7507: and run_id = p_run_id
7508: and member_type = 'S';
7509: if v_resource_count = 0 then

Line 9964: -- Delete Transactions from pa_alloc_run_resource_det

9960: /*Code Changes for Bug No.2984871 start */
9961: Commit;
9962: /*Code Changes for Bug No.2984871 end */
9963: End Loop;
9964: -- Delete Transactions from pa_alloc_run_resource_det
9965: While 1=1 Loop /* Bug 2182563 */
9966: Delete from pa_alloc_run_resource_det
9967: where run_id = p_run_id and rownum < 10001;
9968: /* Commented for Bug 2984871 Commit; */

Line 9966: Delete from pa_alloc_run_resource_det

9962: /*Code Changes for Bug No.2984871 end */
9963: End Loop;
9964: -- Delete Transactions from pa_alloc_run_resource_det
9965: While 1=1 Loop /* Bug 2182563 */
9966: Delete from pa_alloc_run_resource_det
9967: where run_id = p_run_id and rownum < 10001;
9968: /* Commented for Bug 2984871 Commit; */
9969: If Sql%Rowcount = 0 Then
9970: Exit;

Line 10114: -- Delete Transactions from pa_alloc_run_resource_det

10110: /*Code Changes for Bug No.2984871 start */
10111: Commit;
10112: /*Code Changes for Bug No.2984871 end */
10113: End Loop;
10114: -- Delete Transactions from pa_alloc_run_resource_det
10115: While 1=1 Loop /* Bug 2182563 */
10116: Delete from pa_alloc_run_resource_det
10117: where run_id = l_run_id and rownum < 10001;
10118: /* Commented for Bug 2984871 Commit; */

Line 10116: Delete from pa_alloc_run_resource_det

10112: /*Code Changes for Bug No.2984871 end */
10113: End Loop;
10114: -- Delete Transactions from pa_alloc_run_resource_det
10115: While 1=1 Loop /* Bug 2182563 */
10116: Delete from pa_alloc_run_resource_det
10117: where run_id = l_run_id and rownum < 10001;
10118: /* Commented for Bug 2984871 Commit; */
10119: If Sql%Rowcount = 0 Then
10120: Exit;