APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_PROJECT_COPY_OVERRIDES

Line 818: --pa_project_copy_overrides with the created template.

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

Line 2582: FROM pa_project_copy_overrides

2578:
2579: CURSOR cur_overrides
2580: IS
2581: SELECT 'x'
2582: FROM pa_project_copy_overrides
2583: WHERE project_id = p_project_id
2584: AND field_name = p_field_name
2585: AND sort_order = p_sort_order;
2586:

Line 2590: FROM pa_project_copy_overrides

2586:
2587: CURSOR cur_chk_sort_order
2588: IS
2589: SELECT 'x'
2590: FROM pa_project_copy_overrides
2591: WHERE project_id = p_project_id
2592: AND sort_order = p_sort_order;
2593:
2594: CURSOR cur_dup_quick_entry

Line 2597: FROM pa_project_copy_overrides

2593:
2594: CURSOR cur_dup_quick_entry
2595: IS
2596: SELECT 'X'
2597: FROM pa_project_copy_overrides
2598: WHERE project_id = p_project_id
2599: AND field_name = p_field_name;
2600:
2601:

Line 2766: INSERT INTO pa_project_copy_overrides

2762: OPEN cur_overrides;
2763: FETCH cur_overrides INTO l_dummy_char;
2764: IF cur_overrides%NOTFOUND
2765: THEN
2766: INSERT INTO pa_project_copy_overrides
2767: ( PROJECT_ID ,
2768: FIELD_NAME ,
2769: DISPLAY_NAME ,
2770: LAST_UPDATE_DATE ,

Line 2883: FROM pa_project_copy_overrides

2879:
2880: CURSOR cur_chk_sort_order
2881: IS
2882: SELECT 'x'
2883: FROM pa_project_copy_overrides
2884: WHERE rowid <> p_row_id
2885: AND project_id = p_project_id
2886: AND sort_order = p_sort_order;
2887:

Line 2891: FROM pa_project_copy_overrides

2887:
2888: CURSOR cur_dup_quick_entry
2889: IS
2890: SELECT 'X'
2891: FROM pa_project_copy_overrides
2892: WHERE rowid <> p_row_id
2893: AND project_id = p_project_id
2894: AND field_name = p_field_name;
2895: BEGIN

Line 3058: UPDATE pa_project_copy_overrides

3054: END IF;
3055: END IF;
3056: END IF;
3057:
3058: UPDATE pa_project_copy_overrides
3059: SET FIELD_NAME = p_field_name ,
3060: DISPLAY_NAME = p_prompt ,
3061: LAST_UPDATE_DATE = SYSDATE ,
3062: LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,

Line 3151: FROM pa_project_copy_overrides

3147:
3148: CURSOR cur_chk_dflt_qe
3149: IS
3150: SELECT field_name
3151: FROM pa_project_copy_overrides
3152: WHERE rowid = p_row_id;
3153:
3154: l_field_name VARCHAR2(80);
3155:

Line 3189: DELETE FROM pa_project_copy_overrides

3185: x_return_status := 'E';
3186: RAISE FND_API.G_EXC_ERROR;
3187: END IF;
3188:
3189: DELETE FROM pa_project_copy_overrides
3190: WHERE rowid = p_row_id;
3191:
3192: x_return_status := FND_API.G_RET_STS_SUCCESS;
3193: