APPS.EGO_ODI_PUB dependencies on EGO_PUB_BAT_PARAMS_B

Line 1379: SELECT CHAR_VALUE INTO l_structure_name FROM EGO_PUB_BAT_PARAMS_B

1375:
1376: SELECT party_name INTO l_user_name
1377: FROM EGO_USER_V WHERE USER_ID = FND_GLOBAL.USER_ID;
1378:
1379: SELECT CHAR_VALUE INTO l_structure_name FROM EGO_PUB_BAT_PARAMS_B
1380: WHERE type_id=l_batch_id AND Upper(parameter_name) ='STRUCTURE_NAME';
1381:
1382: UPDATE EGO_PUB_BAT_STATUS_B
1383: SET STATUS_CODE = 'F' , MESSAGE = 'User ' || l_user_name ||' does not have the publilsh privilege on few components of the structure ' ||

Line 2672: from Ego_Pub_Bat_Params_B

2668:
2669: --retrieving levels_to_explode
2670: select to_char(numeric_value)
2671: into l_config_option
2672: from Ego_Pub_Bat_Params_B
2673: where type_id = l_batch_id
2674: and parameter_name = 'LEVELS_TO_EXPLODE';
2675:
2676: --updating value of config parameter

Line 2687: from Ego_Pub_Bat_Params_B

2683:
2684: --retrieving EXPLODE_STD_BOM
2685: select char_value
2686: into l_config_option
2687: from Ego_Pub_Bat_Params_B
2688: where type_id = l_batch_id
2689: and parameter_name = 'EXPLODE_STD_BOM';
2690:
2691: --updating value of config parameter

Line 2705: from Ego_Pub_Bat_Params_B

2701:
2702: --Check if parameter EXPLODE_OPTION exists
2703: select to_char(count(*))
2704: into l_config_option
2705: from Ego_Pub_Bat_Params_B
2706: where type_id = l_batch_id
2707: and parameter_name = 'EXPLODE_OPTION';
2708:
2709: IF l_config_option = '0' THEN

Line 2722: from Ego_Pub_Bat_Params_B

2718: ELSE
2719: --retrieving EXPLODE_OPTION
2720: select to_char(NUMERIC_VALUE) --Bug 12984722(FP of bug 12984605) : Read from NUMERIC_VALUE instead of CHAR_VALUE
2721: into l_config_option
2722: from Ego_Pub_Bat_Params_B
2723: where type_id = l_batch_id
2724: and parameter_name = 'EXPLODE_OPTION';
2725:
2726: --updating EXPLOSION_OPTION

Line 6317: SELECT Upper(CHAR_VALUE) INTO l_parent_hier FROM EGO_PUB_BAT_PARAMS_b WHERE type_id=l_batch_id AND Upper(parameter_name) ='PUBLISHPARENT';

6313:
6314:
6315: /* FIND OUT PARENT AND CHILD ICC's also need to publish
6316: It will return TRUE if need to publish else FALSE */
6317: SELECT Upper(CHAR_VALUE) INTO l_parent_hier FROM EGO_PUB_BAT_PARAMS_b WHERE type_id=l_batch_id AND Upper(parameter_name) ='PUBLISHPARENT';
6318: SELECT Upper(CHAR_VALUE) INTO l_child_hier FROM EGO_PUB_BAT_PARAMS_b WHERE type_id=l_batch_id AND Upper(parameter_name) ='PUBLISHCHILD';
6319:
6320: ELSE
6321:

Line 6318: SELECT Upper(CHAR_VALUE) INTO l_child_hier FROM EGO_PUB_BAT_PARAMS_b WHERE type_id=l_batch_id AND Upper(parameter_name) ='PUBLISHCHILD';

6314:
6315: /* FIND OUT PARENT AND CHILD ICC's also need to publish
6316: It will return TRUE if need to publish else FALSE */
6317: SELECT Upper(CHAR_VALUE) INTO l_parent_hier FROM EGO_PUB_BAT_PARAMS_b WHERE type_id=l_batch_id AND Upper(parameter_name) ='PUBLISHPARENT';
6318: SELECT Upper(CHAR_VALUE) INTO l_child_hier FROM EGO_PUB_BAT_PARAMS_b WHERE type_id=l_batch_id AND Upper(parameter_name) ='PUBLISHCHILD';
6319:
6320: ELSE
6321:
6322: /*Extract value into array if ICCId node exist in Input table*/