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_RBS_UTILS dependencies on PA_RBS_ELEMENTS

Line 2423: FROM pa_rbs_elements ele, pa_rbs_element_names_vl tl

2419: *********************************************************/
2420: Cursor c_element_name
2421: IS
2422: SELECT tl.resource_name
2423: FROM pa_rbs_elements ele, pa_rbs_element_names_vl tl
2424: WHERE ele.RBS_ELEMENT_NAME_ID = tl.RBS_ELEMENT_NAME_ID
2425: CONNECT BY PRIOR ele.parent_element_id = ele.rbs_element_id
2426: START WITH ele.rbs_element_id = p_rbs_element_id
2427: ORDER BY rbs_level DESC;

Line 2624: 'PA_RBS_ELEMENTS_TEMP',

2620:
2621: --For bug 4045542, 4887312
2622: /*
2623: FND_STATS.SET_TABLE_STATS('PA',
2624: 'PA_RBS_ELEMENTS_TEMP',
2625: 100,
2626: 10,
2627: 100);
2628: */

Line 2633: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RBS_ELEMENTS_TEMP',100,10,100);

2629: --End of bug 4045542, 4887312
2630: -- Proper Fix for 4887312 *** RAMURTHY 03/01/06 02:33 pm ***
2631: -- It solves the issue above wrt commit by the FND_STATS.SET_TABLE_STATS call
2632:
2633: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RBS_ELEMENTS_TEMP',100,10,100);
2634:
2635: -- End fix 4887312
2636:
2637:

Line 2991: SELECT PA_RBS_ELEMENTS_S.nextval

2987: ELSE
2988: --dbms_output.put_line('Populate_RBS_Element_Name Success');
2989: -- Continue by creating RBS elements.
2990: -- First create top node for the version:
2991: SELECT PA_RBS_ELEMENTS_S.nextval
2992: INTO l_top_node_id from dual;
2993:
2994: SELECT PA_RBS_ELEMENT_IDENTIFIER_S.nextval
2995: INTO l_rbs_identifier_id from dual;

Line 3003: INSERT INTO PA_RBS_ELEMENTS (

2999: FROM pa_rbs_element_names_b
3000: WHERE resource_source_id = l_rbs_version_id
3001: AND resource_type_id = -1;
3002:
3003: INSERT INTO PA_RBS_ELEMENTS (
3004: RBS_Element_Id,
3005: Rbs_Element_Name_Id,
3006: RBS_Version_Id,
3007: Outline_Number,

Line 3057: SELECT PA_RBS_ELEMENTS_S.nextval

3053:
3054: l_outline_number := to_char(to_number(l_outline_number)
3055: + 1);
3056:
3057: SELECT PA_RBS_ELEMENTS_S.nextval
3058: INTO l_rbs_element_id from dual;
3059:
3060: SELECT PA_RBS_ELEMENT_IDENTIFIER_S.nextval
3061: INTO l_rbs_identifier_id from dual;

Line 3114: INSERT INTO PA_RBS_ELEMENTS (

3110: END;
3111:
3112: --dbms_output.put_line('l_element_name_id is: ' || l_element_name_id);
3113:
3114: INSERT INTO PA_RBS_ELEMENTS (
3115: RBS_Element_Id,
3116: Rbs_Element_Name_Id,
3117: RBS_Version_Id,
3118: Outline_Number,

Line 3189: SELECT PA_RBS_ELEMENTS_S.nextval

3185: l_revenue_category_id := NULL;
3186: l_event_type_id := NULL;
3187: l_expenditure_type_id := NULL;
3188:
3189: SELECT PA_RBS_ELEMENTS_S.nextval
3190: INTO l_rbs_element_id from dual;
3191:
3192: SELECT PA_RBS_ELEMENT_IDENTIFIER_S.nextval
3193: INTO l_rbs_identifier_id from dual;

Line 3216: FROM pa_rbs_elements

3212: SELECT (rbs_level + 1), expenditure_category_id,
3213: revenue_category_id
3214: INTO l_rbs_level, l_expenditure_category_id,
3215: l_revenue_category_id
3216: FROM pa_rbs_elements
3217: WHERE rbs_element_id = l_parent_element_id;
3218: ELSE
3219: l_parent_element_id := l_top_node_id;
3220: l_rbs_level := 2;

Line 3226: FROM pa_rbs_elements

3222:
3223:
3224: IF l_parent_element_id IS NOT NULL THEN
3225: SELECT outline_number INTO l_parent_outline_number
3226: FROM pa_rbs_elements
3227: WHERE rbs_element_id = l_parent_element_id;
3228: --dbms_output.put_line('l_parent_outline_number is : ' || l_parent_outline_number);
3229: END IF;
3230:

Line 3313: INSERT INTO PA_RBS_ELEMENTS (

3309: l_child_outline_number;
3310: l_child_outline_number := l_child_outline_number + 1;
3311: END IF;
3312:
3313: INSERT INTO PA_RBS_ELEMENTS (
3314: RBS_Element_Id,
3315: Rbs_Element_Name_Id,
3316: RBS_Version_Id,
3317: Outline_Number,

Line 3387: delete from Pa_Rbs_Elements_Temp;

3383: -- END LOOP; -- Versions loop (frozen and working)
3384:
3385: -- Create frozen version elements again but with user_created_flag
3386: -- as 'Y'
3387: delete from Pa_Rbs_Elements_Temp;
3388: Insert Into Pa_Rbs_Elements_Temp(
3389: New_Element_Id,
3390: Old_Element_Id,
3391: Old_Parent_Element_Id,

Line 3388: Insert Into Pa_Rbs_Elements_Temp(

3384:
3385: -- Create frozen version elements again but with user_created_flag
3386: -- as 'Y'
3387: delete from Pa_Rbs_Elements_Temp;
3388: Insert Into Pa_Rbs_Elements_Temp(
3389: New_Element_Id,
3390: Old_Element_Id,
3391: Old_Parent_Element_Id,
3392: New_Parent_Element_Id )

Line 3394: Pa_Rbs_Elements_S.NextVal,

3390: Old_Element_Id,
3391: Old_Parent_Element_Id,
3392: New_Parent_Element_Id )
3393: (Select
3394: Pa_Rbs_Elements_S.NextVal,
3395: Rbs_Element_Id,
3396: Parent_Element_Id,
3397: Null
3398: From

Line 3399: Pa_Rbs_Elements

3395: Rbs_Element_Id,
3396: Parent_Element_Id,
3397: Null
3398: From
3399: Pa_Rbs_Elements
3400: Where
3401: Rbs_Version_Id = l_rbs_version_id
3402: and user_created_flag = 'N' );
3403:

Line 3404: Update Pa_Rbs_Elements_Temp Tmp1

3400: Where
3401: Rbs_Version_Id = l_rbs_version_id
3402: and user_created_flag = 'N' );
3403:
3404: Update Pa_Rbs_Elements_Temp Tmp1
3405: Set New_Parent_Element_Id =
3406: (Select
3407: New_Element_Id
3408: From

Line 3409: Pa_Rbs_Elements_Temp Tmp2

3405: Set New_Parent_Element_Id =
3406: (Select
3407: New_Element_Id
3408: From
3409: Pa_Rbs_Elements_Temp Tmp2
3410: Where
3411: Tmp1.Old_Parent_Element_Id = Tmp2.Old_Element_Id);
3412:
3413: --dbms_output.put_line('Updated into Temp');

Line 3417: Insert Into Pa_Rbs_Elements

3413: --dbms_output.put_line('Updated into Temp');
3414:
3415: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
3416: to remove the GSCC Warning File.Sql.33 */
3417: Insert Into Pa_Rbs_Elements
3418: (
3419: RBS_ELEMENT_ID,
3420: RBS_ELEMENT_NAME_ID,
3421: RBS_VERSION_ID,

Line 3499: Pa_Rbs_Elements Rbs_Elements,

3495: Pa_Rbs_Versions_Pvt.G_Created_By,
3496: Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
3497: 1
3498: From
3499: Pa_Rbs_Elements Rbs_Elements,
3500: Pa_Rbs_Elements_Temp Tmp
3501: Where
3502: Tmp.Old_Element_Id = Rbs_Elements.Rbs_Element_Id;
3503:

Line 3500: Pa_Rbs_Elements_Temp Tmp

3496: Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
3497: 1
3498: From
3499: Pa_Rbs_Elements Rbs_Elements,
3500: Pa_Rbs_Elements_Temp Tmp
3501: Where
3502: Tmp.Old_Element_Id = Rbs_Elements.Rbs_Element_Id;
3503:
3504: -- Call API to populate mapping rules and mapping denorm tables.

Line 3671: delete from Pa_Rbs_Elements_Temp;

3667: END LOOP; -- End RBS V TL names Loop Version
3668:
3669: --dbms_output.put_line('Created RBS Working : ' || l_rbs_version_id);
3670:
3671: delete from Pa_Rbs_Elements_Temp;
3672: Insert Into Pa_Rbs_Elements_Temp(
3673: New_Element_Id,
3674: Old_Element_Id,
3675: Old_Parent_Element_Id,

Line 3672: Insert Into Pa_Rbs_Elements_Temp(

3668:
3669: --dbms_output.put_line('Created RBS Working : ' || l_rbs_version_id);
3670:
3671: delete from Pa_Rbs_Elements_Temp;
3672: Insert Into Pa_Rbs_Elements_Temp(
3673: New_Element_Id,
3674: Old_Element_Id,
3675: Old_Parent_Element_Id,
3676: New_Parent_Element_Id )

Line 3678: Pa_Rbs_Elements_S.NextVal,

3674: Old_Element_Id,
3675: Old_Parent_Element_Id,
3676: New_Parent_Element_Id )
3677: (Select
3678: Pa_Rbs_Elements_S.NextVal,
3679: Rbs_Element_Id,
3680: Parent_Element_Id,
3681: Null
3682: From

Line 3683: Pa_Rbs_Elements

3679: Rbs_Element_Id,
3680: Parent_Element_Id,
3681: Null
3682: From
3683: Pa_Rbs_Elements
3684: Where
3685: Rbs_Version_Id = l_Rbs_Version_From_Id
3686: and user_created_flag = 'Y' );
3687:

Line 3689: Update Pa_Rbs_Elements_Temp Tmp1

3685: Rbs_Version_Id = l_Rbs_Version_From_Id
3686: and user_created_flag = 'Y' );
3687:
3688: --dbms_output.put_line('Inserted into Temp');
3689: Update Pa_Rbs_Elements_Temp Tmp1
3690: Set New_Parent_Element_Id =
3691: (Select
3692: New_Element_Id
3693: From

Line 3694: Pa_Rbs_Elements_Temp Tmp2

3690: Set New_Parent_Element_Id =
3691: (Select
3692: New_Element_Id
3693: From
3694: Pa_Rbs_Elements_Temp Tmp2
3695: Where
3696: Tmp1.Old_Parent_Element_Id = Tmp2.Old_Element_Id);
3697:
3698: --dbms_output.put_line('Updated into Temp');

Line 3701: Insert Into Pa_Rbs_Elements

3697:
3698: --dbms_output.put_line('Updated into Temp');
3699: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
3700: to remove the GSCC Warning File.Sql.33 */
3701: Insert Into Pa_Rbs_Elements
3702: (
3703: RBS_ELEMENT_ID,
3704: RBS_ELEMENT_NAME_ID,
3705: RBS_VERSION_ID,

Line 3783: Pa_Rbs_Elements Rbs_Elements,

3779: Pa_Rbs_Versions_Pvt.G_Created_By,
3780: Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
3781: 1
3782: From
3783: Pa_Rbs_Elements Rbs_Elements,
3784: Pa_Rbs_Elements_Temp Tmp
3785: Where
3786: Tmp.Old_Element_Id = Rbs_Elements.Rbs_Element_Id;
3787:

Line 3784: Pa_Rbs_Elements_Temp Tmp

3780: Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
3781: 1
3782: From
3783: Pa_Rbs_Elements Rbs_Elements,
3784: Pa_Rbs_Elements_Temp Tmp
3785: Where
3786: Tmp.Old_Element_Id = Rbs_Elements.Rbs_Element_Id;
3787:
3788: --dbms_output.put_line('Craeted Elemenst ');

Line 3797: Update Pa_Rbs_Elements

3793: X_Return_Status => x_return_status);
3794:
3795: If x_return_status = Fnd_Api.G_Ret_Sts_Success Then
3796:
3797: Update Pa_Rbs_Elements
3798: Set Rbs_Element_Name_Id = l_New_Element_Name_Id,
3799: Resource_Source_Id = l_rbs_version_id
3800: Where Rbs_Version_Id = l_rbs_version_id
3801: And Resource_Type_Id = -1