APPS.EGO_PUB_FWK_PK dependencies on EGO_PUB_BAT_STATUS_B

Line 386: INSERT INTO Ego_Pub_Bat_Status_B

382:
383:
384: l_stmt_num := 30;
385: FORALL i in t_batch_ent_obj_id.FIRST..t_batch_ent_obj_id.LAST
386: INSERT INTO Ego_Pub_Bat_Status_B
387: (
388: Batch_Id
389: ,System_Code
390: ,Batch_Entity_Object_id

Line 415: ||' ' || sql%rowcount || ' rows are inserted into EGO_PUB_BAT_STATUS_B.');

411: );
412: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
413: ,p_module => 'EGO_PUB_FWK_PK.process_entities'
414: ,p_message => 'lStmtNum=' || to_char(l_stmt_num)
415: ||' ' || sql%rowcount || ' rows are inserted into EGO_PUB_BAT_STATUS_B.');
416:
417: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
418: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
419: ,p_message => 'Exit EGO_PUB_FWK_PK.process_entities successfully... '

Line 905: from Ego_Pub_Bat_status_b

901: ret_err_msg_lang = USERENV('LANG')
902: where (batch_id,
903: system_Code) not in (select batch_id,
904: system_code
905: from Ego_Pub_Bat_status_b
906: where batch_id = p_batch_id)
907: and batch_id = p_batch_id
908: and process_flag is null;
909:

Line 970: FROM ego_pub_bat_status_b

966: (SELECT
967: batch_entity_object_id,
968: batch_id,
969: system_code
970: FROM ego_pub_bat_status_b
971: WHERE batch_id = p_batch_id)
972: AND batch_id = p_batch_id
973: and process_flag is null;
974:

Line 1061: UPDATE ego_pub_bat_status_b

1057: IF p_mode = C_BATCH_MODE THEN
1058:
1059: l_stmt_num := 65;
1060: FORALL i IN t_batch_id.FIRST .. t_batch_id.LAST
1061: UPDATE ego_pub_bat_status_b
1062: SET status_code = t_status(i),
1063: message = t_message(i)
1064: WHERE batch_id = t_batch_id(i);
1065:

Line 1070: UPDATE ego_pub_bat_status_b

1066: ELSIF p_mode = C_BATCH_SYSTEM_MODE THEN
1067:
1068: l_stmt_num := 70;
1069: FORALL i IN t_batch_id.FIRST .. t_batch_id.LAST
1070: UPDATE ego_pub_bat_status_b
1071: SET status_code = t_status(i),
1072: message = t_message(i)
1073: WHERE batch_id = t_batch_id(i)
1074: AND system_code = t_system_code(i);

Line 1080: UPDATE ego_pub_bat_status_b

1076: ELSIF p_mode = C_BATCH_SYSTEM_ENTITY_MODE THEN
1077:
1078: l_stmt_num := 80;
1079: FORALL i IN t_batch_id.FIRST .. t_batch_id.LAST
1080: UPDATE ego_pub_bat_status_b
1081: SET status_code = t_status(i),
1082: message = t_message(i)
1083: WHERE batch_entity_object_id = t_batch_ent_obj_id(i)
1084: AND batch_id = t_batch_id(i)

Line 2651: from EGO_PUB_BAT_STATUS_B

2647: return ;
2648: end;
2649: begin
2650: select distinct batch_id into l_batch_id
2651: from EGO_PUB_BAT_STATUS_B
2652: where batch_id = p_batch_id and STATUS_CODE = C_STATUS_DRAFT;
2653: exception
2654: when no_data_found then
2655: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2691: update EGO_PUB_BAT_STATUS_B set STATUS_CODE = C_STATUS_SUBMITTED

2687: SAVEPOINT PUB_BAT_STATUS_CHANGE;
2688: update EGO_PUB_BAT_HDR_B set PUBLISHED_BY = l_party_id, BATCH_CREATION_DATE = sysdate
2689: where batch_id = l_batch_id;
2690:
2691: update EGO_PUB_BAT_STATUS_B set STATUS_CODE = C_STATUS_SUBMITTED
2692: where batch_id = l_batch_id and STATUS_CODE <> C_STATUS_SUBMITTED;
2693:
2694: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
2695: ,p_module => l_module_name

Line 3238: insert into EGO_PUB_BAT_STATUS_B (

3234: end if;
3235: -- insert batch status for each entity, system pair
3236: for i in 1..l_batch_entity_obj_ids.count loop
3237: for j in 1..l_target_systems.count loop
3238: insert into EGO_PUB_BAT_STATUS_B (
3239: batch_id,
3240: system_code,
3241: batch_entity_object_id,
3242: status_code,

Line 3511: from EGO_PUB_BAT_STATUS_B

3507: raise EGO_PUB_BATCH_NOT_CREATOR;
3508: end if;
3509:
3510: select status_code into l_status
3511: from EGO_PUB_BAT_STATUS_B
3512: where batch_id = l_batch_id and rownum = 1;
3513: if (l_status <> EGO_PUB_FWK_PK.C_STATUS_DRAFT) then
3514: raise EGO_PUB_BATCH_NOT_DRAFT;
3515: end if;