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_RES_ACCUMS dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 549: -- In case of 'None' Group Resource type, the table pa_resource_lists_all_bg

545: RETURN NULL;
546: END get_resource_rank;
547:
548: -- This function returns the group resource_type_code for the given resoure list
549: -- In case of 'None' Group Resource type, the table pa_resource_lists_all_bg
550: -- will not join to the pa_resource_types table
551:
552: FUNCTION get_group_resource_type_code
553: (x_resource_list_id IN NUMBER)

Line 569: pa_resource_lists_all_bg rl

565: INTO
566: x_group_resource_type_code
567: FROM
568: pa_resource_types rt,
569: pa_resource_lists_all_bg rl
570: WHERE
571: rl.resource_list_id = x_resource_list_id
572: and nvl(rl.migration_code,'-99') <> 'N'
573: AND rl.group_resource_type_id = rt.resource_type_id

Line 803: pa_resource_lists_all_bg rl,

799: rta.resource_format_id,
800: rt.resource_type_code
801: , rl.job_group_id
802: FROM
803: pa_resource_lists_all_bg rl,
804: pa_resource_list_members rlm,
805: pa_resource_txn_attributes rta,
806: pa_resources r,
807: pa_resource_types rt,

Line 854: pa_resource_lists_all_bg rl,

850: rtac.resource_format_id,
851: rtc.resource_type_code
852: , rl.job_group_id
853: FROM
854: pa_resource_lists_all_bg rl,
855: pa_resource_list_members rlmc,
856: pa_resource_list_members rlmp,
857: pa_resource_txn_attributes rtac,
858: pa_resource_txn_attributes rtap,

Line 1594: /* Bug 3812290 Added pa_resource_lists_all_bg for the below cursor c1 */

1590:
1591: /* In case x_res_list_id is null then do mapping for all
1592: resource lists attached to the project */
1593:
1594: /* Bug 3812290 Added pa_resource_lists_all_bg for the below cursor c1 */
1595:
1596: CURSOR C1 IS
1597: SELECT prla.resource_list_id
1598: ,prla.resource_list_assignment_id

Line 1600: pa_resource_lists_all_bg res

1596: CURSOR C1 IS
1597: SELECT prla.resource_list_id
1598: ,prla.resource_list_assignment_id
1599: FROM pa_resource_list_assignments prla,
1600: pa_resource_lists_all_bg res
1601: WHERE prla.resource_list_id = nvl(x_res_list_id,prla.resource_list_id)
1602: AND prla.project_id = x_project_id
1603: AND res.resource_list_id = prla.resource_list_id
1604: AND NVL(res.MIGRATION_CODE,'-99') <> 'N';

Line 1949: l_rl_job_group_id pa_resource_lists_all_bg.job_group_id%type;

1945:
1946: l_unclassified_rlm_id NUMBER;
1947: l_unclassified_res_id NUMBER;
1948: l_group_resource_type_id NUMBER;
1949: l_rl_job_group_id pa_resource_lists_all_bg.job_group_id%type;
1950:
1951: /* According to guidelines from Performance group
1952: plsql table size should never exceed 200 */
1953:

Line 1967: l_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%type;

1963:
1964: l_resource_member_id_tbl L_RESOURCE_MEMBER_ID_TBL_TYP := L_RESOURCE_MEMBER_ID_TBL_TYP();
1965: l_resource_id_tbl L_RESOURCE_ID_TBL_TYP := L_RESOURCE_ID_TBL_TYP();
1966: l_txn_id_tbl L_TXN_ID_TABLE_TYP := L_TXN_ID_TABLE_TYP();
1967: l_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%type;
1968:
1969: /* Logical Flow of this API
1970:
1971: 1. In case resource list to which mapping needs to be done is grouped.

Line 2060: FROM pa_resource_lists_all_bg prl

2056: , l_unclassified_rlm_id
2057: , l_unclassified_res_id
2058: , l_rl_job_group_id
2059: , l_uncategorized_flag
2060: FROM pa_resource_lists_all_bg prl
2061: ,pa_resource_list_members prlm
2062: WHERE prl.resource_list_id = x_resource_list_id
2063: AND prl.resource_list_id = prlm.resource_list_id
2064: and nvl(prl.migration_code,'-99') <> 'N'

Line 2327: (x_res_list_id IN pa_resource_lists_all_bg.resource_list_id%type,

2323: RAISE;
2324: END new_map_txns;
2325:
2326: PROCEDURE update_parents_mem_id
2327: (x_res_list_id IN pa_resource_lists_all_bg.resource_list_id%type,
2328: x_err_stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2329: x_err_code OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
2330: BEGIN
2331:

Line 2414: (x_res_list_id IN pa_resource_lists_all_bg.resource_list_id%type,

2410: RAISE;
2411: END update_parents_mem_id;
2412:
2413: PROCEDURE ins_temp_res_map_grp
2414: (x_res_list_id IN pa_resource_lists_all_bg.resource_list_id%type,
2415: x_rl_job_grp_id IN pa_resource_lists_all_bg.job_group_id%type,
2416: x_err_stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2417: x_err_code OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
2418:

Line 2415: x_rl_job_grp_id IN pa_resource_lists_all_bg.job_group_id%type,

2411: END update_parents_mem_id;
2412:
2413: PROCEDURE ins_temp_res_map_grp
2414: (x_res_list_id IN pa_resource_lists_all_bg.resource_list_id%type,
2415: x_rl_job_grp_id IN pa_resource_lists_all_bg.job_group_id%type,
2416: x_err_stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2417: x_err_code OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
2418:
2419: /* This cursor select distinct resource types defined in the resource list at

Line 2739: (x_res_list_id IN pa_resource_lists_all_bg.resource_list_id%type,

2735: RAISE;
2736: END ins_temp_res_map_grp;
2737:
2738: PROCEDURE ins_temp_res_map_ungrp
2739: (x_res_list_id IN pa_resource_lists_all_bg.resource_list_id%type,
2740: x_rl_job_grp_id IN pa_resource_lists_all_bg.job_group_id%type,
2741: x_err_stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2742: x_err_code OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
2743:

Line 2740: x_rl_job_grp_id IN pa_resource_lists_all_bg.job_group_id%type,

2736: END ins_temp_res_map_grp;
2737:
2738: PROCEDURE ins_temp_res_map_ungrp
2739: (x_res_list_id IN pa_resource_lists_all_bg.resource_list_id%type,
2740: x_rl_job_grp_id IN pa_resource_lists_all_bg.job_group_id%type,
2741: x_err_stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2742: x_err_code OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
2743:
2744: /* This cursor select distinct resource types defined in the resource list at