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_TEMP_RES_MAPS_TMP

Line 1985: 1.4 Now insert all possible child level resources in PA_TEMP_RES_MAPS_TMP table and

1981:
1982: 1.3 At this point if parent could not be assigned then the txn should be
1983: assigned to list level unclassified resource.
1984:
1985: 1.4 Now insert all possible child level resources in PA_TEMP_RES_MAPS_TMP table and
1986: their ranks in this table. This is done by matching all attributes of
1987: transactions with corresponding attribute of the child resource.
1988:
1989: 1.5 Fetch all the resources with highest (lowest in magnitude) rank in pl/sql

Line 2000: 2.1 Insert all possible child level resources in PA_TEMP_RES_MAPS_TMP table and their

1996: it may not have any unclassified member under it also. In such case parent is
1997: the resource that should be assigned to the txn.
1998:
1999: 2. In case resource list not categorized then
2000: 2.1 Insert all possible child level resources in PA_TEMP_RES_MAPS_TMP table and their
2001: ranks in this table. This is done by matching all attributes of transactions
2002: with corresponding attribute of the child resource.
2003:
2004: 2.2 Same as 1.5

Line 2016: FROM pa_temp_res_maps_tmp

2012: CURSOR C1 IS
2013: SELECT txn_id
2014: ,resource_list_member_id
2015: ,resource_id
2016: FROM pa_temp_res_maps_tmp
2017: ORDER BY txn_id, rank; /* ORDER BY is important and should not be changed */
2018:
2019: /* This cursor selects parent level unclassified members for the transactions.
2020: This cursor is used to achieve point 1.6 mentioned above.

Line 2433: x_err_stage := 'Deleting from pa_temp_res_maps_tmp table';

2429: AND parent_member_id is not null;
2430:
2431: BEGIN
2432:
2433: x_err_stage := 'Deleting from pa_temp_res_maps_tmp table';
2434: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2435: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2436: END IF;
2437:

Line 2438: DELETE FROM pa_temp_res_maps_tmp;

2434: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2435: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2436: END IF;
2437:
2438: DELETE FROM pa_temp_res_maps_tmp;
2439:
2440: /* Point 1.4 : In following statements we will insert records into temp table
2441: pa_temp_res_maps_tmp table. As one transaction can belong to multiple resources
2442: all such resources with txn_id and rank will be inserted into this table.

Line 2441: pa_temp_res_maps_tmp table. As one transaction can belong to multiple resources

2437:
2438: DELETE FROM pa_temp_res_maps_tmp;
2439:
2440: /* Point 1.4 : In following statements we will insert records into temp table
2441: pa_temp_res_maps_tmp table. As one transaction can belong to multiple resources
2442: all such resources with txn_id and rank will be inserted into this table.
2443: Later only those resources will be picked up which have highest rank
2444: (lowest in magnitude).
2445:

Line 2453: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2449:
2450: FOR C3REC in C3 LOOP
2451: IF C3REC.RESOURCE_TYPE_CODE = 'EMPLOYEE' THEN
2452:
2453: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2454: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2455: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2456: END IF;
2457:

Line 2464: INSERT INTO pa_temp_res_maps_tmp

2460: took hours to come back while these 8 inserts did the same job in few seconds.
2461: These inserts are not modified to dynamic inserts because of performance reasons.
2462: */
2463:
2464: INSERT INTO pa_temp_res_maps_tmp
2465: (SELECT txn_id
2466: , prlm.resource_list_member_id
2467: , prlm.resource_id,
2468: prfr.rank

Line 2489: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2485: END IF;
2486:
2487: ELSIF C3REC.RESOURCE_TYPE_CODE = 'JOB' THEN
2488:
2489: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2490: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2491: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2492: END IF;
2493:

Line 2494: INSERT INTO pa_temp_res_maps_tmp

2490: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2491: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2492: END IF;
2493:
2494: INSERT INTO pa_temp_res_maps_tmp
2495: (SELECT txn_id
2496: , prlm.resource_list_member_id
2497: , prlm.resource_id,
2498: prfr.rank

Line 2519: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2515: END IF;
2516:
2517: ELSIF C3REC.RESOURCE_TYPE_CODE = 'ORGANIZATION' THEN
2518:
2519: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2520: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2521: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2522: END IF;
2523:

Line 2524: INSERT INTO pa_temp_res_maps_tmp

2520: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2521: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2522: END IF;
2523:
2524: INSERT INTO pa_temp_res_maps_tmp
2525: (SELECT txn_id
2526: , prlm.resource_list_member_id
2527: , prlm.resource_id
2528: , prfr.rank

Line 2549: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2545: END IF;
2546:
2547: ELSIF C3REC.RESOURCE_TYPE_CODE = 'REVENUE_CATEGORY' THEN
2548:
2549: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2550: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2551: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2552: END IF;
2553:

Line 2554: INSERT INTO pa_temp_res_maps_tmp

2550: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2551: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2552: END IF;
2553:
2554: INSERT INTO pa_temp_res_maps_tmp
2555: (SELECT txn_id
2556: , prlm.resource_list_member_id
2557: , prlm.resource_id
2558: , prfr.rank

Line 2579: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2575: END IF;
2576:
2577: ELSIF C3REC.RESOURCE_TYPE_CODE = 'VENDOR' THEN
2578:
2579: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2580: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2581: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2582: END IF;
2583:

Line 2584: INSERT INTO pa_temp_res_maps_tmp

2580: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2581: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2582: END IF;
2583:
2584: INSERT INTO pa_temp_res_maps_tmp
2585: (SELECT txn_id
2586: , prlm.resource_list_member_id
2587: , prlm.resource_id
2588: , prfr.rank

Line 2609: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2605: END IF;
2606:
2607: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EXPENDITURE_TYPE' THEN
2608:
2609: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2610: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2611: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2612: END IF;
2613:

Line 2614: INSERT INTO pa_temp_res_maps_tmp

2610: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2611: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2612: END IF;
2613:
2614: INSERT INTO pa_temp_res_maps_tmp
2615: (SELECT txn_id
2616: , prlm.resource_list_member_id
2617: , prlm.resource_id
2618: , prfr.rank

Line 2639: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2635: END IF;
2636:
2637: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EXPENDITURE_CATEGORY' THEN
2638:
2639: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2640: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2641: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2642: END IF;
2643:

Line 2644: INSERT INTO pa_temp_res_maps_tmp

2640: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2641: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2642: END IF;
2643:
2644: INSERT INTO pa_temp_res_maps_tmp
2645: (SELECT txn_id
2646: , prlm.resource_list_member_id
2647: , prlm.resource_id
2648: , prfr.rank

Line 2669: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2665: END IF;
2666:
2667: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EVENT_TYPE' THEN
2668:
2669: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2670: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2671: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2672: END IF;
2673:

Line 2674: INSERT INTO pa_temp_res_maps_tmp

2670: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2671: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2672: END IF;
2673:
2674: INSERT INTO pa_temp_res_maps_tmp
2675: (SELECT txn_id
2676: , prlm.resource_list_member_id
2677: , prlm.resource_id
2678: , prfr.rank

Line 2699: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2695: END IF;
2696:
2697: ELSIF C3REC.RESOURCE_TYPE_CODE = 'PROJECT_ROLE' THEN
2698:
2699: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2700: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2701: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2702: END IF;
2703:

Line 2704: INSERT INTO pa_temp_res_maps_tmp

2700: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2701: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2702: END IF;
2703:
2704: INSERT INTO pa_temp_res_maps_tmp
2705: (SELECT txn_id
2706: , prlm.resource_list_member_id
2707: , prlm.resource_id
2708: , prfr.rank

Line 2756: x_err_stage := 'Deleting from pa_temp_res_maps_tmp table';

2752: WHERE resource_list_id = x_res_list_id
2753: and nvl(migration_code,'-99') <> 'N';
2754:
2755: BEGIN
2756: x_err_stage := 'Deleting from pa_temp_res_maps_tmp table';
2757: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2758: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2759: END IF;
2760:

Line 2761: DELETE FROM pa_temp_res_maps_tmp;

2757: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2758: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2759: END IF;
2760:
2761: DELETE FROM pa_temp_res_maps_tmp;
2762:
2763: /* Point 2.1 : In following statements we will insert records into temp table
2764: pa_temp_res_maps_tmp table. As one transaction can belong to multiple resources
2765: all such resources with txn_id and rank will be inserted into this table.

Line 2764: pa_temp_res_maps_tmp table. As one transaction can belong to multiple resources

2760:
2761: DELETE FROM pa_temp_res_maps_tmp;
2762:
2763: /* Point 2.1 : In following statements we will insert records into temp table
2764: pa_temp_res_maps_tmp table. As one transaction can belong to multiple resources
2765: all such resources with txn_id and rank will be inserted into this table.
2766: Later only those resources will be picked up which have highest rank
2767: (lowest in magnitude).
2768: */

Line 2778: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2774:
2775: FOR C3REC in C3 LOOP
2776: IF C3REC.RESOURCE_TYPE_CODE = 'EMPLOYEE' THEN
2777:
2778: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2779: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2780: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2781: END IF;
2782:

Line 2783: INSERT INTO pa_temp_res_maps_tmp

2779: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2780: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2781: END IF;
2782:
2783: INSERT INTO pa_temp_res_maps_tmp
2784: (SELECT txn_id
2785: , prlm.resource_list_member_id
2786: , prlm.resource_id
2787: , prfr.rank

Line 2807: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2803: END IF;
2804:
2805: ELSIF C3REC.RESOURCE_TYPE_CODE = 'JOB' THEN
2806:
2807: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2808: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2809: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2810: END IF;
2811:

Line 2812: INSERT INTO pa_temp_res_maps_tmp

2808: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2809: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2810: END IF;
2811:
2812: INSERT INTO pa_temp_res_maps_tmp
2813: (SELECT txn_id
2814: , prlm.resource_list_member_id
2815: , prlm.resource_id
2816: , prfr.rank

Line 2836: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2832: END IF;
2833:
2834: ELSIF C3REC.RESOURCE_TYPE_CODE = 'ORGANIZATION' THEN
2835:
2836: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2837: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2838: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2839: END IF;
2840:

Line 2841: INSERT INTO pa_temp_res_maps_tmp

2837: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2838: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2839: END IF;
2840:
2841: INSERT INTO pa_temp_res_maps_tmp
2842: (SELECT txn_id
2843: , prlm.resource_list_member_id
2844: , prlm.resource_id
2845: , prfr.rank

Line 2865: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2861: END IF;
2862:
2863: ELSIF C3REC.RESOURCE_TYPE_CODE = 'REVENUE_CATEGORY' THEN
2864:
2865: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2866: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2867: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2868: END IF;
2869:

Line 2870: INSERT INTO pa_temp_res_maps_tmp

2866: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2867: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2868: END IF;
2869:
2870: INSERT INTO pa_temp_res_maps_tmp
2871: (SELECT txn_id
2872: , prlm.resource_list_member_id
2873: , prlm.resource_id
2874: , prfr.rank

Line 2894: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2890: END IF;
2891:
2892: ELSIF C3REC.RESOURCE_TYPE_CODE = 'VENDOR' THEN
2893:
2894: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2895: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2896: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2897: END IF;
2898:

Line 2899: INSERT INTO pa_temp_res_maps_tmp

2895: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2896: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2897: END IF;
2898:
2899: INSERT INTO pa_temp_res_maps_tmp
2900: (SELECT txn_id
2901: , prlm.resource_list_member_id
2902: , prlm.resource_id
2903: , prfr.rank

Line 2923: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2919: END IF;
2920:
2921: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EXPENDITURE_TYPE' THEN
2922:
2923: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2924: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2925: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2926: END IF;
2927:

Line 2928: INSERT INTO pa_temp_res_maps_tmp

2924: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2925: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2926: END IF;
2927:
2928: INSERT INTO pa_temp_res_maps_tmp
2929: (SELECT txn_id
2930: , prlm.resource_list_member_id
2931: , prlm.resource_id
2932: , prfr.rank

Line 2952: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2948: END IF;
2949:
2950: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EXPENDITURE_CATEGORY' THEN
2951:
2952: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2953: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2954: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2955: END IF;
2956:

Line 2957: INSERT INTO pa_temp_res_maps_tmp

2953: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2954: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2955: END IF;
2956:
2957: INSERT INTO pa_temp_res_maps_tmp
2958: (SELECT txn_id
2959: , prlm.resource_list_member_id
2960: , prlm.resource_id
2961: , prfr.rank

Line 2981: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

2977: END IF;
2978:
2979: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EVENT_TYPE' THEN
2980:
2981: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2982: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2983: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2984: END IF;
2985:

Line 2986: INSERT INTO pa_temp_res_maps_tmp

2982: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2983: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2984: END IF;
2985:
2986: INSERT INTO pa_temp_res_maps_tmp
2987: (SELECT txn_id
2988: , prlm.resource_list_member_id
2989: , prlm.resource_id
2990: , prfr.rank

Line 3010: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);

3006: END IF;
3007:
3008: ELSIF C3REC.RESOURCE_TYPE_CODE = 'PROJECT_ROLE' THEN
3009:
3010: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
3011: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3012: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
3013: END IF;
3014:

Line 3015: INSERT INTO pa_temp_res_maps_tmp

3011: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3012: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
3013: END IF;
3014:
3015: INSERT INTO pa_temp_res_maps_tmp
3016: (SELECT txn_id
3017: , prlm.resource_list_member_id
3018: , prlm.resource_id
3019: , prfr.rank