APPS.PA_RBS_UTILS dependencies on PA_RBS_ELEMENTS_TEMP

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(PJI_UTILS.GET_PA_SCHEMA_NAME,'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: -- Bug 8261905, Replaced 'PA' by PJI_UTILS.GET_PA_SCHEMA_NAME
2633: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RBS_ELEMENTS_TEMP',100,10,100);
2634:
2635: -- End fix 4887312
2636:
2637:

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 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 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 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 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 ');