DBA Data[Home] [Help]

APPS.EGO_PUB_WS_ICC dependencies on EGO_PUB_FWK_PK

Line 1748: batch_entity_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_TYPE;

1744:
1745: l_batch_id NUMBER := p_batch_id;
1746: v_index NUMBER;
1747: v_count NUMBER;
1748: batch_entity_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_TYPE;
1749: l_entity_type_id_tbl EGO_PUB_FWK_PK.NUMBER_ARR_TBL_TYPE;
1750: l_entity_type_id NUMBER;
1751:
1752: x_return_status VARCHAR2(1);

Line 1749: l_entity_type_id_tbl EGO_PUB_FWK_PK.NUMBER_ARR_TBL_TYPE;

1745: l_batch_id NUMBER := p_batch_id;
1746: v_index NUMBER;
1747: v_count NUMBER;
1748: batch_entity_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_TYPE;
1749: l_entity_type_id_tbl EGO_PUB_FWK_PK.NUMBER_ARR_TBL_TYPE;
1750: l_entity_type_id NUMBER;
1751:
1752: x_return_status VARCHAR2(1);
1753: x_msg_count NUMBER;

Line 1844: --debug(L_PROC_NAME||' calling procedure EGO_PUB_FWK_PK.add_derived_entities ');

1840: END LOOP; -- end of loop k
1841:
1842: -- Calling the Below API for all the derived entities at a time, i.e in bulk
1843:
1844: --debug(L_PROC_NAME||' calling procedure EGO_PUB_FWK_PK.add_derived_entities ');
1845: EGO_PUB_FWK_PK.add_derived_entities(batch_entity_rec,x_return_status,x_msg_count,x_msg_data);
1846: --debug(L_PROC_NAME||' returned from procedure EGO_PUB_FWK_PK.add_derived_entities ');
1847:
1848: IF (x_return_status <> 'S') THEN

Line 1845: EGO_PUB_FWK_PK.add_derived_entities(batch_entity_rec,x_return_status,x_msg_count,x_msg_data);

1841:
1842: -- Calling the Below API for all the derived entities at a time, i.e in bulk
1843:
1844: --debug(L_PROC_NAME||' calling procedure EGO_PUB_FWK_PK.add_derived_entities ');
1845: EGO_PUB_FWK_PK.add_derived_entities(batch_entity_rec,x_return_status,x_msg_count,x_msg_data);
1846: --debug(L_PROC_NAME||' returned from procedure EGO_PUB_FWK_PK.add_derived_entities ');
1847:
1848: IF (x_return_status <> 'S') THEN
1849: NULL;

Line 1846: --debug(L_PROC_NAME||' returned from procedure EGO_PUB_FWK_PK.add_derived_entities ');

1842: -- Calling the Below API for all the derived entities at a time, i.e in bulk
1843:
1844: --debug(L_PROC_NAME||' calling procedure EGO_PUB_FWK_PK.add_derived_entities ');
1845: EGO_PUB_FWK_PK.add_derived_entities(batch_entity_rec,x_return_status,x_msg_count,x_msg_data);
1846: --debug(L_PROC_NAME||' returned from procedure EGO_PUB_FWK_PK.add_derived_entities ');
1847:
1848: IF (x_return_status <> 'S') THEN
1849: NULL;
1850: --debug(L_PROC_NAME||'EGO_PUB_FWK_PK.add_derived_entities x_return_status=>'||x_return_status);

Line 1850: --debug(L_PROC_NAME||'EGO_PUB_FWK_PK.add_derived_entities x_return_status=>'||x_return_status);

1846: --debug(L_PROC_NAME||' returned from procedure EGO_PUB_FWK_PK.add_derived_entities ');
1847:
1848: IF (x_return_status <> 'S') THEN
1849: NULL;
1850: --debug(L_PROC_NAME||'EGO_PUB_FWK_PK.add_derived_entities x_return_status=>'||x_return_status);
1851: --debug(L_PROC_NAME||'EGO_PUB_FWK_PK.add_derived_entities x_msg_data=>'||x_msg_data);
1852: END IF;
1853: END IF; -- end of if (l_batch_id > -1 and x_return_status = 'S')
1854:

Line 1851: --debug(L_PROC_NAME||'EGO_PUB_FWK_PK.add_derived_entities x_msg_data=>'||x_msg_data);

1847:
1848: IF (x_return_status <> 'S') THEN
1849: NULL;
1850: --debug(L_PROC_NAME||'EGO_PUB_FWK_PK.add_derived_entities x_return_status=>'||x_return_status);
1851: --debug(L_PROC_NAME||'EGO_PUB_FWK_PK.add_derived_entities x_msg_data=>'||x_msg_data);
1852: END IF;
1853: END IF; -- end of if (l_batch_id > -1 and x_return_status = 'S')
1854:
1855: --debug(L_PROC_NAME||' End');

Line 2058: call EGO_PUB_FWK_PK.Update_Pub_Status with bat_ent_stat_rec array;

2054: end if on trigger_import=Y
2055: 4) loop on GT
2056: build bat_ent_stat_rec array;
2057: end loop
2058: call EGO_PUB_FWK_PK.Update_Pub_Status with bat_ent_stat_rec array;
2059: 5) End of algorithm.
2060: */
2061:
2062: PROCEDURE Write_Errors_ToBatFwk(p_session_id IN NUMBER,

Line 2079: bat_ent_stat_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_STAT_TYPE;

2075:
2076: v_index NUMBER;
2077: v_count NUMBER;
2078: l_system_code VARCHAR2(40);
2079: bat_ent_stat_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_STAT_TYPE;
2080: x_bat_status_out EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_RSTS_TYPE;
2081:
2082: x_return_status VARCHAR2(1);
2083: x_msg_count NUMBER;

Line 2080: x_bat_status_out EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_RSTS_TYPE;

2076: v_index NUMBER;
2077: v_count NUMBER;
2078: l_system_code VARCHAR2(40);
2079: bat_ent_stat_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_STAT_TYPE;
2080: x_bat_status_out EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_RSTS_TYPE;
2081:
2082: x_return_status VARCHAR2(1);
2083: x_msg_count NUMBER;
2084: x_msg_data VARCHAR2(500);

Line 2654: --debug(L_PROC_NAME||' end of loop on c_pub_bat_gt, calling EGO_PUB_FWK_PK.Update_Pub_Status');

2650: v_index := v_index + 1;
2651: --debug(L_PROC_NAME||' at the end of loop iteration, incremented v_index to :'||v_index);
2652:
2653: END LOOP; /*end of loop on c_pub_bat_gt*/
2654: --debug(L_PROC_NAME||' end of loop on c_pub_bat_gt, calling EGO_PUB_FWK_PK.Update_Pub_Status');
2655:
2656: EGO_PUB_FWK_PK.Update_Pub_Status(l_batch_id, 2, bat_ent_stat_rec,x_bat_status_out,x_return_status,x_msg_count,x_msg_data);
2657: --debug(L_PROC_NAME||' returned from EGO_PUB_FWK_PK.Update_Pub_Status with x_return_status: '||x_return_status);
2658:

Line 2656: EGO_PUB_FWK_PK.Update_Pub_Status(l_batch_id, 2, bat_ent_stat_rec,x_bat_status_out,x_return_status,x_msg_count,x_msg_data);

2652:
2653: END LOOP; /*end of loop on c_pub_bat_gt*/
2654: --debug(L_PROC_NAME||' end of loop on c_pub_bat_gt, calling EGO_PUB_FWK_PK.Update_Pub_Status');
2655:
2656: EGO_PUB_FWK_PK.Update_Pub_Status(l_batch_id, 2, bat_ent_stat_rec,x_bat_status_out,x_return_status,x_msg_count,x_msg_data);
2657: --debug(L_PROC_NAME||' returned from EGO_PUB_FWK_PK.Update_Pub_Status with x_return_status: '||x_return_status);
2658:
2659: -- do we need to get x_bat_status_out (TBL_OF_BAT_ENT_OBJ_RSTS_TYPE --- TABLE OF BAT_ENT_OBJ_RET_STAT_TYPE )
2660: IF (x_return_status <> 'S') THEN

Line 2657: --debug(L_PROC_NAME||' returned from EGO_PUB_FWK_PK.Update_Pub_Status with x_return_status: '||x_return_status);

2653: END LOOP; /*end of loop on c_pub_bat_gt*/
2654: --debug(L_PROC_NAME||' end of loop on c_pub_bat_gt, calling EGO_PUB_FWK_PK.Update_Pub_Status');
2655:
2656: EGO_PUB_FWK_PK.Update_Pub_Status(l_batch_id, 2, bat_ent_stat_rec,x_bat_status_out,x_return_status,x_msg_count,x_msg_data);
2657: --debug(L_PROC_NAME||' returned from EGO_PUB_FWK_PK.Update_Pub_Status with x_return_status: '||x_return_status);
2658:
2659: -- do we need to get x_bat_status_out (TBL_OF_BAT_ENT_OBJ_RSTS_TYPE --- TABLE OF BAT_ENT_OBJ_RET_STAT_TYPE )
2660: IF (x_return_status <> 'S') THEN
2661: --debug(L_PROC_NAME||'return status : ' || x_return_status);