APPS.EGO_PUB_FWK_PK dependencies on EGO_PUB_BAT_HDR_B

Line 765: from Ego_Pub_Bat_Hdr_B

761: Begin
762:
763: Select batch_id
764: into l_batch_id
765: from Ego_Pub_Bat_Hdr_B
766: where batch_id = p_batch_Id;
767: Exception
768: When No_Data_Found THEN
769: RAISE EGO_NO_HEADER;

Line 2635: from EGO_PUB_BAT_HDR_B

2631: */
2632: if p_check_priv then
2633: begin
2634: select batch_id into l_batch_id
2635: from EGO_PUB_BAT_HDR_B
2636: where batch_id = p_batch_id and created_by = l_user_id;
2637: exception
2638: when no_data_found then
2639: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2688: update EGO_PUB_BAT_HDR_B set PUBLISHED_BY = l_party_id, BATCH_CREATION_DATE = sysdate

2684: SELECT nvl(customer_id , person_party_id) into l_party_id
2685: FROM fnd_user WHERE user_id = l_user_id;
2686:
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;

Line 2985: select 1 into l_name_ct from EGO_PUB_BAT_HDR_B

2981: raise EGO_PUB_BATCHTYPE_INVL;
2982: END IF;
2983:
2984: begin
2985: select 1 into l_name_ct from EGO_PUB_BAT_HDR_B
2986: where batch_name = p_batch_name;
2987: if l_name_ct >= 1 then
2988: raise EGO_PUB_BATCHNAME_DUP;
2989: end if;

Line 3087: insert into EGO_PUB_BAT_HDR_B (

3083: -- insert data into batch tables
3084: -- header, params, entities, target systems, status(entities*systems)
3085: select EGO_PUB_BAT_HDR_S1.nextVal into l_batch_id from dual;
3086: -- insert batch header with batch_name and batch_type, batch doesn't has tl tables
3087: insert into EGO_PUB_BAT_HDR_B (
3088: BATCH_ID,
3089: BATCH_NAME,
3090: BATCH_TYPE,
3091: PUBLISHED_BY,

Line 3490: from ego_pub_bat_hdr_b

3486: begin
3487: if (l_batch_name is not null and l_batch_id is not null) then
3488: select batch_id, batch_type, created_by
3489: into l_batch_id, l_batch_type, l_creator_id
3490: from ego_pub_bat_hdr_b
3491: where batch_name = l_batch_name and batch_id = l_batch_id;
3492: elsif (l_batch_name is not null and l_batch_id is null) then
3493: select batch_id, batch_type, created_by
3494: into l_batch_id, l_batch_type, l_creator_id

Line 3495: from ego_pub_bat_hdr_b

3491: where batch_name = l_batch_name and batch_id = l_batch_id;
3492: elsif (l_batch_name is not null and l_batch_id is null) then
3493: select batch_id, batch_type, created_by
3494: into l_batch_id, l_batch_type, l_creator_id
3495: from ego_pub_bat_hdr_b
3496: where batch_name = l_batch_name ;
3497: elsif (l_batch_name is null and l_batch_id is not null) then
3498: select batch_id, batch_type, created_by
3499: into l_batch_id, l_batch_type, l_creator_id

Line 3500: from ego_pub_bat_hdr_b

3496: where batch_name = l_batch_name ;
3497: elsif (l_batch_name is null and l_batch_id is not null) then
3498: select batch_id, batch_type, created_by
3499: into l_batch_id, l_batch_type, l_creator_id
3500: from ego_pub_bat_hdr_b
3501: where batch_id = l_batch_id;
3502: else
3503: raise no_data_found;
3504: end if;

Line 3683: from ego_pub_bat_hdr_b

3679: begin
3680: if (p_batch_name is not null and p_batch_id is not null) then
3681: select batch_id, batch_name, batch_type
3682: into l_batch_id, l_batch_name, l_batch_type
3683: from ego_pub_bat_hdr_b
3684: where batch_name = p_batch_name and batch_id = p_batch_id;
3685: elsif (p_batch_name is not null and p_batch_id is null) then
3686: select batch_id, batch_name, batch_type
3687: into l_batch_id, l_batch_name, l_batch_type

Line 3688: from ego_pub_bat_hdr_b

3684: where batch_name = p_batch_name and batch_id = p_batch_id;
3685: elsif (p_batch_name is not null and p_batch_id is null) then
3686: select batch_id, batch_name, batch_type
3687: into l_batch_id, l_batch_name, l_batch_type
3688: from ego_pub_bat_hdr_b
3689: where batch_name = p_batch_name ;
3690: elsif (p_batch_name is null and p_batch_id is not null) then
3691: select batch_id, batch_name, batch_type
3692: into l_batch_id, l_batch_name, l_batch_type

Line 3693: from ego_pub_bat_hdr_b

3689: where batch_name = p_batch_name ;
3690: elsif (p_batch_name is null and p_batch_id is not null) then
3691: select batch_id, batch_name, batch_type
3692: into l_batch_id, l_batch_name, l_batch_type
3693: from ego_pub_bat_hdr_b
3694: where batch_id = p_batch_id;
3695: else
3696: raise no_data_found;
3697: end if;

Line 3747: from ego_pub_bat_hdr_b

3743: -- if the batch is copied, add a counter to the name
3744: l_counter := 0;
3745: l_batch_name := l_batch_name || '_copy';
3746: select count(1) into l_counter
3747: from ego_pub_bat_hdr_b
3748: where batch_name like l_batch_name || '%';
3749:
3750: if (l_counter > 0) then
3751: l_batch_name := l_batch_name || to_char(l_counter + 1);

Line 3874: from ego_pub_bat_hdr_b

3870:
3871: begin
3872: if (l_batch_name is not null and l_batch_id is not null) then
3873: select batch_id into l_batch_id
3874: from ego_pub_bat_hdr_b
3875: where batch_name = l_batch_name and batch_id = l_batch_id;
3876: elsif (l_batch_name is not null and l_batch_id is null) then
3877: select batch_id into l_batch_id
3878: from ego_pub_bat_hdr_b

Line 3878: from ego_pub_bat_hdr_b

3874: from ego_pub_bat_hdr_b
3875: where batch_name = l_batch_name and batch_id = l_batch_id;
3876: elsif (l_batch_name is not null and l_batch_id is null) then
3877: select batch_id into l_batch_id
3878: from ego_pub_bat_hdr_b
3879: where batch_name = l_batch_name ;
3880: elsif (l_batch_name is null and l_batch_id is not null) then
3881: select batch_id into l_batch_id
3882: from ego_pub_bat_hdr_b

Line 3882: from ego_pub_bat_hdr_b

3878: from ego_pub_bat_hdr_b
3879: where batch_name = l_batch_name ;
3880: elsif (l_batch_name is null and l_batch_id is not null) then
3881: select batch_id into l_batch_id
3882: from ego_pub_bat_hdr_b
3883: where batch_id = l_batch_id;
3884: else
3885: raise no_data_found;
3886: end if;