APPS.EGO_PUB_FWK_PK dependencies on EGO_PUB_BAT_PARAMS_B

Line 1557: l_param_name EGO_PUB_BAT_PARAMS_B.PARAMETER_NAME%TYPE;

1553: l_has_pub_child varchar2(1) := 'N';
1554: l_struct_name varchar2(100) ;
1555: l_expl_date date;
1556:
1557: l_param_name EGO_PUB_BAT_PARAMS_B.PARAMETER_NAME%TYPE;
1558: l_param_char_val EGO_PUB_BAT_PARAMS_B.CHAR_VALUE%TYPE;
1559: l_param_date_val date;
1560: l_param_num_val number;
1561: l_icc_id number;

Line 1558: l_param_char_val EGO_PUB_BAT_PARAMS_B.CHAR_VALUE%TYPE;

1554: l_struct_name varchar2(100) ;
1555: l_expl_date date;
1556:
1557: l_param_name EGO_PUB_BAT_PARAMS_B.PARAMETER_NAME%TYPE;
1558: l_param_char_val EGO_PUB_BAT_PARAMS_B.CHAR_VALUE%TYPE;
1559: l_param_date_val date;
1560: l_param_num_val number;
1561: l_icc_id number;
1562: l_counter number;

Line 2668: from EGO_PUB_BAT_PARAMS_B

2664: end;
2665:
2666: begin
2667: select date_value into l_expl_date
2668: from EGO_PUB_BAT_PARAMS_B
2669: where type_id = p_batch_id and parameter_name = C_PARAM_EXPLDATE;
2670: exception
2671: when no_data_found then
2672: null; -- it's not item publish

Line 2705: from EGO_PUB_BAT_PARAMS_B

2701: -- params: batch_id, $pub_params, workspace_name, auto_release
2702: if (p_batch_type = C_BATCH_ENTITY_ITEM) THEN
2703: select CASE WHEN (CHAR_VALUE IS NULL) THEN 'N' ELSE 'Y' END
2704: into l_struct_flag
2705: from EGO_PUB_BAT_PARAMS_B
2706: where TYPE_ID = l_batch_id AND PARAMETER_NAME = C_PARAM_STRUCTN;
2707:
2708: l_event_name := 'oracle.apps.ego.item.publishItem';
2709: wf_event.AddParameterToList(p_name => 'STRUCTURE_FLAG'

Line 2718: from EGO_PUB_BAT_PARAMS_B

2714: if (p_batch_type = C_BATCH_ENTITY_ICC) then
2715: l_event_name := 'oracle.apps.ego.item.publishItemCatalogCategory';
2716:
2717: select CHAR_VALUE into l_icc_parent_flag
2718: from EGO_PUB_BAT_PARAMS_B
2719: where TYPE_ID = l_batch_id AND PARAMETER_NAME = C_PARAM_PUBPARENT;
2720:
2721: select CHAR_VALUE into l_icc_child_flag
2722: from EGO_PUB_BAT_PARAMS_B

Line 2722: from EGO_PUB_BAT_PARAMS_B

2718: from EGO_PUB_BAT_PARAMS_B
2719: where TYPE_ID = l_batch_id AND PARAMETER_NAME = C_PARAM_PUBPARENT;
2720:
2721: select CHAR_VALUE into l_icc_child_flag
2722: from EGO_PUB_BAT_PARAMS_B
2723: where TYPE_ID = l_batch_id AND PARAMETER_NAME = C_PARAM_PUBCHILD;
2724:
2725: wf_event.AddParameterToList(p_name => 'publish_parent_hierarchy'
2726: ,p_value => l_icc_parent_flag

Line 3121: insert into EGO_PUB_BAT_PARAMS_B (

3117: For i in 1..l_pub_params.count Loop
3118: debugBatchParam(l_module_name, l_pub_params(i));
3119:
3120: select EGO_PUB_BAT_PARAMS_S1.NEXTVAL into l_type_param_id from dual;
3121: insert into EGO_PUB_BAT_PARAMS_B (
3122: TYPE_PARAM_ID,
3123: TYPE_ID,
3124: TYPE,
3125: PARAMETER_NAME,

Line 3528: from ego_pub_bat_params_b

3524: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3525: ,p_module => l_module_name
3526: ,p_message => 'get meta pub type');
3527: select nvl(char_value, 'PUBLISH') into l_pub_type
3528: from ego_pub_bat_params_b
3529: where type_id = l_batch_id AND PARAMETER_NAME = C_PARAM_PUBTYPE;
3530: end if;
3531:
3532: publish_pvt(l_batch_id, l_batch_type, l_batch_entities,

Line 3704: from EGO_PUB_BAT_PARAMS_B where TYPE_ID = l_batch_id ;

3700: select TYPE, PARAMETER_NAME, DATA_TYPE, DATE_VALUE,
3701: CHAR_VALUE, NUMERIC_VALUE
3702: BULK COLLECT INTO l_param_types, l_param_names, l_param_data_types,
3703: l_param_date_vals, l_param_char_vals, l_param_num_vals
3704: from EGO_PUB_BAT_PARAMS_B where TYPE_ID = l_batch_id ;
3705: l_counter := 1;
3706:
3707: for i in 1..l_param_types.COUNT loop
3708: l_pub_params(l_counter).param_type := l_param_types(i);