DBA Data[Home] [Help]

APPS.EGO_ITEM_PEOPLE_IMPORT_PKG dependencies on HZ_PARTIES

Line 26: -- Seeded value for all_users (group available in hz_parties)

22:
23: --Indicates the object id (set using g_Fnd_Object_Name)
24: G_FND_OBJECT_ID fnd_objects.object_id%TYPE;
25:
26: -- Seeded value for all_users (group available in hz_parties)
27: G_ALL_USERS_PARTY_ID PLS_INTEGER := -1000;
28:
29: -- Batch size that needs to be processed
30: G_BATCH_SIZE NUMBER;

Line 364: FROM hz_parties

360: -- IN : object_name
361: --
362: CURSOR c_all_users_party_id IS
363: SELECT party_id
364: FROM hz_parties
365: WHERE party_type = 'GLOBAL'
366: AND party_name = 'All Users';
367:
368: BEGIN

Line 1663: l_login_party_id hz_parties.party_id%TYPE;

1659: l_token_tbl_one Error_Handler.Token_Tbl_Type;
1660: l_token_tbl_two Error_Handler.Token_Tbl_Type;
1661: l_token_tbl_three Error_Handler.Token_Tbl_Type;
1662:
1663: l_login_party_id hz_parties.party_id%TYPE;
1664: l_login_party_name VARCHAR2(240);
1665: l_ipi_lines_count NUMBER;
1666: l_loop_count NUMBER;
1667: l_transaction_id_min NUMBER;