APPS.EGO_PUB_WS_WRAPPER dependencies on EGO_PUB_FWK_PK

Line 27: bat_ent_stat_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_STAT_TYPE;

23: l_odi_entscename VARCHAR2(40) := p_odi_entscename;
24: l_batch_id NUMBER;
25: l_batch_search_str VARCHAR2(1000);
26: l_system_search_str VARCHAR2(1000);
27: bat_ent_stat_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_STAT_TYPE;
28: x_bat_status_out EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_RSTS_TYPE;
29:
30: x_return_status VARCHAR2(1);
31: x_msg_count NUMBER;

Line 28: x_bat_status_out EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_RSTS_TYPE;

24: l_batch_id NUMBER;
25: l_batch_search_str VARCHAR2(1000);
26: l_system_search_str VARCHAR2(1000);
27: bat_ent_stat_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_STAT_TYPE;
28: x_bat_status_out EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_RSTS_TYPE;
29:
30: x_return_status VARCHAR2(1);
31: x_msg_count NUMBER;
32: x_msg_data VARCHAR2(500);

Line 120: -- call to ego_pub_fwk_pk - update_pub_status - api in batch mode equal to zero

116:
117:
118: -- once the web service call happens, for the sync entity,
119: -- for all input entities of the batch, and batch systems the process status would be - In Process
120: -- call to ego_pub_fwk_pk - update_pub_status - api in batch mode equal to zero
121: -- which will update status for all entities for all systems of the batch
122:
123: bat_ent_stat_rec(1).batch_id := l_batch_id;
124: bat_ent_stat_rec(1).pk1_value := NULL;

Line 132: EGO_PUB_FWK_PK.Update_Pub_Status(l_batch_id, 0, bat_ent_stat_rec,x_bat_status_out,x_return_status,x_msg_count,x_msg_data);

128: bat_ent_stat_rec(1).pk5_value := NULL;
129: bat_ent_stat_rec(1).system_code := NULL;
130: bat_ent_stat_rec(1).status := 'I';
131: bat_ent_stat_rec(1).message := NULL;
132: EGO_PUB_FWK_PK.Update_Pub_Status(l_batch_id, 0, bat_ent_stat_rec,x_bat_status_out,x_return_status,x_msg_count,x_msg_data);
133:
134: END IF;
135:
136: l_system_search_str := EGO_PUB_WS_UTIL.Get_System_Search_Str(l_odi_entscename);

Line 159: bat_ent_stat_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_STAT_TYPE;

155: l_mode VARCHAR2(10) := NULL;
156: l_batch_id NUMBER;
157: l_message VARCHAR2(2000) := NULL;
158:
159: bat_ent_stat_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_STAT_TYPE;
160:
161: x_bat_status_out EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_RSTS_TYPE;
162: x_return_status VARCHAR2(1) := NULL;
163: x_msg_count NUMBER;

Line 161: x_bat_status_out EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_RSTS_TYPE;

157: l_message VARCHAR2(2000) := NULL;
158:
159: bat_ent_stat_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_STAT_TYPE;
160:
161: x_bat_status_out EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_RSTS_TYPE;
162: x_return_status VARCHAR2(1) := NULL;
163: x_msg_count NUMBER;
164: x_msg_data VARCHAR2(500) := NULL;
165:

Line 172: -- call to ego_pub_fwk_pk - update_pub_status - api in batch mode equal to one

168: -- and the user provided system code does not exist in ODI (context code)
169: -- for all input entities of the batch, and the only selected, batch system,
170: -- the process status would be - Failed with relevant error message.
171:
172: -- call to ego_pub_fwk_pk - update_pub_status - api in batch mode equal to one
173: -- which will update status for all entities for the provided systems of the batch
174: BEGIN
175: SELECT CHAR_VALUE
176: INTO l_mode

Line 214: EGO_PUB_FWK_PK.Update_Pub_Status(l_batch_id, 1, bat_ent_stat_rec,x_bat_status_out,x_return_status,x_msg_count,x_msg_data);

210: bat_ent_stat_rec(1).pk5_value := NULL;
211: bat_ent_stat_rec(1).system_code := p_system_code;
212: bat_ent_stat_rec(1).status := 'F';
213: bat_ent_stat_rec(1).message := l_message;
214: EGO_PUB_FWK_PK.Update_Pub_Status(l_batch_id, 1, bat_ent_stat_rec,x_bat_status_out,x_return_status,x_msg_count,x_msg_data);
215: END IF;
216:
217: END Update_Batch_System_Status;
218: