APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_PROJECT_COPY_OVERRIDES

Line 823: --pa_project_copy_overrides with the created template.

819: raise FND_API.G_EXC_ERROR;
820: END IF;
821:
822: --Call Add quick entry api to add two default quick entries( SEGMENT1 and NAME ) in
823: --pa_project_copy_overrides with the created template.
824: DECLARE
825: CURSOR cur_copy_overrides
826: IS
827: SELECT lookup_code, meaning

Line 2587: FROM pa_project_copy_overrides

2583:
2584: CURSOR cur_overrides
2585: IS
2586: SELECT 'x'
2587: FROM pa_project_copy_overrides
2588: WHERE project_id = p_project_id
2589: AND field_name = p_field_name
2590: AND sort_order = p_sort_order;
2591:

Line 2595: FROM pa_project_copy_overrides

2591:
2592: CURSOR cur_chk_sort_order
2593: IS
2594: SELECT 'x'
2595: FROM pa_project_copy_overrides
2596: WHERE project_id = p_project_id
2597: AND sort_order = p_sort_order;
2598:
2599: CURSOR cur_dup_quick_entry

Line 2602: FROM pa_project_copy_overrides

2598:
2599: CURSOR cur_dup_quick_entry
2600: IS
2601: SELECT 'X'
2602: FROM pa_project_copy_overrides
2603: WHERE project_id = p_project_id
2604: AND field_name = p_field_name;
2605:
2606:

Line 2771: INSERT INTO pa_project_copy_overrides

2767: OPEN cur_overrides;
2768: FETCH cur_overrides INTO l_dummy_char;
2769: IF cur_overrides%NOTFOUND
2770: THEN
2771: INSERT INTO pa_project_copy_overrides
2772: ( PROJECT_ID ,
2773: FIELD_NAME ,
2774: DISPLAY_NAME ,
2775: LAST_UPDATE_DATE ,

Line 2888: FROM pa_project_copy_overrides

2884:
2885: CURSOR cur_chk_sort_order
2886: IS
2887: SELECT 'x'
2888: FROM pa_project_copy_overrides
2889: WHERE rowid <> p_row_id
2890: AND project_id = p_project_id
2891: AND sort_order = p_sort_order;
2892:

Line 2896: FROM pa_project_copy_overrides

2892:
2893: CURSOR cur_dup_quick_entry
2894: IS
2895: SELECT 'X'
2896: FROM pa_project_copy_overrides
2897: WHERE rowid <> p_row_id
2898: AND project_id = p_project_id
2899: AND field_name = p_field_name;
2900: BEGIN

Line 3063: UPDATE pa_project_copy_overrides

3059: END IF;
3060: END IF;
3061: END IF;
3062:
3063: UPDATE pa_project_copy_overrides
3064: SET FIELD_NAME = p_field_name ,
3065: DISPLAY_NAME = p_prompt ,
3066: LAST_UPDATE_DATE = SYSDATE ,
3067: LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,

Line 3156: FROM pa_project_copy_overrides

3152:
3153: CURSOR cur_chk_dflt_qe
3154: IS
3155: SELECT field_name
3156: FROM pa_project_copy_overrides
3157: WHERE rowid = p_row_id;
3158:
3159: l_field_name VARCHAR2(80);
3160:

Line 3194: DELETE FROM pa_project_copy_overrides

3190: x_return_status := 'E';
3191: RAISE FND_API.G_EXC_ERROR;
3192: END IF;
3193:
3194: DELETE FROM pa_project_copy_overrides
3195: WHERE rowid = p_row_id;
3196:
3197: x_return_status := FND_API.G_RET_STS_SUCCESS;
3198: