APPS.EGO_AG_BULKLOAD_PVT dependencies on FND_FORM_FUNCTIONS

Line 2382: FROM fnd_form_functions

2378:
2379: /*Set the View Privilege ID when the View Privilege Name or User View privilege name is given*/
2380: UPDATE ego_attr_groups_dl_interface eagdl
2381: SET eagdl.view_privilege_id = (SELECT function_id
2382: FROM fnd_form_functions
2383: WHERE function_name = eagdl.view_privilege_name),
2384: last_updated_by = G_USER_ID,
2385: last_update_date = SYSDATE,
2386: last_update_login = G_LOGIN_ID

Line 2395: FROM fnd_form_functions_vl

2391: OR (set_process_id = G_SET_PROCESS_ID));
2392:
2393: UPDATE ego_attr_groups_dl_interface eagdl
2394: SET view_privilege_id = (SELECT function_id
2395: FROM fnd_form_functions_vl
2396: WHERE user_function_name = eagdl.user_view_priv_name),
2397: last_updated_by = G_USER_ID,
2398: last_update_date = SYSDATE,
2399: last_update_login = G_LOGIN_ID

Line 2413: FROM fnd_form_functions

2409:
2410: /*Set the Edit Privilege ID when the Edit Privilege Name or user edit priviledge name is given*/
2411: UPDATE ego_attr_groups_dl_interface eagdl
2412: SET edit_privilege_id = (SELECT function_id
2413: FROM fnd_form_functions
2414: WHERE function_name = eagdl.edit_privilege_name),
2415: last_updated_by = G_USER_ID,
2416: last_update_date = SYSDATE,
2417: last_update_login = G_LOGIN_ID

Line 2426: FROM fnd_form_functions_vl

2422: OR (set_process_id = G_SET_PROCESS_ID));
2423:
2424: UPDATE ego_attr_groups_dl_interface eagdl
2425: SET edit_privilege_id = (SELECT function_id
2426: FROM fnd_form_functions_vl
2427: WHERE user_function_name = eagdl.user_edit_priv_name),
2428: last_updated_by = G_USER_ID,
2429: last_update_date = SYSDATE,
2430: last_update_login = G_LOGIN_ID

Line 2755: FROM fnd_form_functions_vl

2751:
2752: /*Set the View Privilege when the id is given*/
2753: UPDATE ego_attr_groups_dl_interface eagdl
2754: SET (view_privilege_name,user_view_priv_name) = (SELECT function_name, user_function_name
2755: FROM fnd_form_functions_vl
2756: WHERE function_id = eagdl.view_privilege_id),
2757: last_updated_by = G_USER_ID,
2758: last_update_date = SYSDATE,
2759: last_update_login = G_LOGIN_ID

Line 2772: FROM fnd_form_functions_vl

2768:
2769: /*Set the Edit Privilege when the id is given*/
2770: UPDATE ego_attr_groups_dl_interface eagdl
2771: SET (edit_privilege_name,user_edit_priv_name) = (SELECT function_name, user_function_name
2772: FROM fnd_form_functions_vl
2773: WHERE function_id = eagdl.edit_privilege_id),
2774: last_updated_by = G_USER_ID,
2775: last_update_date = SYSDATE,
2776: last_update_login = G_LOGIN_ID

Line 3961: FROM fnd_form_functions

3957: AND P_agdl_tbl(i).view_privilege_name <> G_NULL_CHAR) THEN
3958: BEGIN
3959: SELECT function_id
3960: INTO P_agdl_tbl(i).view_privilege_id
3961: FROM fnd_form_functions
3962: WHERE function_name = P_agdl_tbl(i).view_privilege_name;
3963: EXCEPTION
3964: WHEN no_data_found THEN
3965: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||P_agdl_tbl(i).transaction_id||' (AG,DL,VS) = ('

Line 4006: FROM fnd_form_functions

4002: AND P_agdl_tbl(i).edit_privilege_name <> G_NULL_CHAR) THEN
4003: BEGIN
4004: SELECT function_id
4005: INTO P_agdl_tbl(i).edit_privilege_id
4006: FROM fnd_form_functions
4007: WHERE function_name = P_agdl_tbl(i).edit_privilege_name;
4008: EXCEPTION
4009: WHEN no_data_found THEN
4010: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||P_agdl_tbl(i).transaction_id||' (AG,DL,VS) = ('

Line 5537: FROM fnd_form_functions

5533: AND P_agdl_tbl(i).view_privilege_name IS NULL) THEN
5534: BEGIN
5535: SELECT function_name
5536: INTO P_agdl_tbl(i).view_privilege_name
5537: FROM fnd_form_functions
5538: WHERE function_id = P_agdl_tbl(i).view_privilege_id;
5539: EXCEPTION
5540: WHEN no_data_found THEN
5541: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'View Privilege provided is invalid');

Line 5574: FROM fnd_form_functions

5570: AND P_agdl_tbl(i).edit_privilege_name IS NULL) THEN
5571: BEGIN
5572: SELECT function_name
5573: INTO P_agdl_tbl(i).edit_privilege_name
5574: FROM fnd_form_functions
5575: WHERE function_id = P_agdl_tbl(i).edit_privilege_id;
5576: EXCEPTION
5577: WHEN no_data_found THEN
5578: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Edit Privilege provided is invalid');