DBA Data[Home] [Help]

APPS.EGO_ODI_PUB dependencies on EGO_PUB_BAT_HDR_B

Line 1047: from EGO_PUB_BAT_HDR_B

1043:
1044: --retrieving user_id and responsibility
1045: select created_by, responsibility_id
1046: into l_user_id,l_responsibility_id
1047: from EGO_PUB_BAT_HDR_B
1048: where batch_id = l_batch_id;
1049:
1050: --retrieving responsibility_id
1051: Select application_id

Line 2555: from EGO_PUB_BAT_HDR_B

2551:
2552: --retrieving user_id and responsibility
2553: select created_by, responsibility_id
2554: into l_user_id, l_responsibility_id
2555: from EGO_PUB_BAT_HDR_B
2556: where batch_id = l_batch_id;
2557:
2558: --retrieving user name
2559: select USER_NAME

Line 6960: FROM EGO_PUB_BAT_HDR_B

6956:
6957:
6958: SELECT created_by, responsibility_id
6959: INTO l_user_id,l_resp_id
6960: FROM EGO_PUB_BAT_HDR_B
6961: WHERE batch_id = l_batch_id;
6962:
6963: EXCEPTION
6964: WHEN No_Data_Found THEN

Line 7163: FROM ego_pub_bat_hdr_b

7159: --Validate if passed in Batch_Id to webservices are valid.
7160: CURSOR cur_batch
7161: IS
7162: SELECT Count(batch_id) batch_exist
7163: FROM ego_pub_bat_hdr_b
7164: WHERE BATCH_ID= p_batch_id;
7165:
7166: --Cursor for versioned ICC
7167: CURSOR cur_ver_icc(cp_item_catalog_group_id NUMBER,