DBA Data[Home] [Help]

APPS.EGO_FUNCTIONS_BULKLOAD_PVT dependencies on DUAL

Line 417: FROM dual

413: BEGIN
414: /* 1. Check if the function is used for Item Number or Description generation of the ICC. */
415: SELECT 1
416: INTO function_is_used
417: FROM dual
418: WHERE EXISTS (SELECT *
419: FROM ego_actions_b
420: WHERE ( function_id = func_header_rec.function_id ));
421: EXCEPTION

Line 429: FROM dual

425: /* 2. Check if the function is used in the Actions on Attribute Groups associated with ICC. */
426: IF (function_is_used=0) THEN
427: BEGIN
428: SELECT 1 INTO function_is_used
429: FROM dual
430: WHERE EXISTS (SELECT * FROM ego_action_displays_b WHERE (prompt_function_id=func_header_rec.function_id
431: AND visibility_func_id=func_header_rec.function_id));
432: EXCEPTION
433: WHEN no_data_found THEN

Line 476: FROM dual;

472: IF ( func_header_rec.process_status <> G_ERROR_RECORD ) THEN
473: IF (func_header_rec.transaction_type=G_CREATE_TRANSACTION) then
474: SELECT ego_functions_s.nextval
475: INTO func_header_rec.function_id
476: FROM dual;
477:
478: INSERT INTO ego_functions_b
479: (function_id,
480: internal_name,

Line 1511: FROM dual;

1507: IF ( func_param_rec.process_status <> G_ERROR_RECORD ) THEN
1508: IF (func_param_rec.transaction_type=G_CREATE_TRANSACTION) THEN
1509: SELECT ego_func_params_s.nextval
1510: INTO func_param_rec.func_param_id
1511: FROM dual;
1512: INSERT INTO ego_func_params_b
1513: (function_id,
1514: func_param_id,
1515: SEQUENCE,