APPS.EGO_ITEM_PVT dependencies on HZ_PARTIES

Line 347: l_hz_party_type HZ_PARTIES.party_type%TYPE;

343: FUNCTION validate_party (p_party_type IN VARCHAR2
344: ,x_party_id IN OUT NOCOPY NUMBER
345: ,x_party_name IN OUT NOCOPY VARCHAR2
346: ) RETURN BOOLEAN IS
347: l_hz_party_type HZ_PARTIES.party_type%TYPE;
348: l_dummy_char VARCHAR2(32767);
349: BEGIN
350: IF p_party_type IN (EGO_ITEM_PUB.G_USER_PARTY_TYPE
351: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE

Line 372: FROM hz_parties

368: -- validate the party_id passed.
369: BEGIN
370: SELECT party_id, party_name
371: INTO x_party_id, x_party_name
372: FROM hz_parties
373: WHERE party_id = x_party_id
374: AND party_type = l_hz_party_type;
375: RETURN TRUE;
376: EXCEPTION

Line 387: FROM hz_parties

383: -- validate the party_name passed.
384: BEGIN
385: SELECT party_id, party_name
386: INTO x_party_id, x_party_name
387: FROM hz_parties
388: WHERE party_name = x_party_name
389: AND party_type = l_hz_party_type;
390: RETURN TRUE;
391: EXCEPTION

Line 3276: l_owner_party_id hz_parties.party_id%TYPE;

3272: ,p_set_message IN VARCHAR2
3273: ) RETURN BOOLEAN IS
3274: TYPE dynamic_cur IS REF CURSOR;
3275: c_priv_cursor dynamic_cur;
3276: l_owner_party_id hz_parties.party_id%TYPE;
3277: l_owner_party_name hz_parties.party_name%TYPE;
3278: l_sec_predicate VARCHAR2(32767);
3279: l_return_status VARCHAR2(10);
3280: l_select_sql VARCHAR2(32767);

Line 3277: l_owner_party_name hz_parties.party_name%TYPE;

3273: ) RETURN BOOLEAN IS
3274: TYPE dynamic_cur IS REF CURSOR;
3275: c_priv_cursor dynamic_cur;
3276: l_owner_party_id hz_parties.party_id%TYPE;
3277: l_owner_party_name hz_parties.party_name%TYPE;
3278: l_sec_predicate VARCHAR2(32767);
3279: l_return_status VARCHAR2(10);
3280: l_select_sql VARCHAR2(32767);
3281: l_dummy_number NUMBER;

Line 3292: FROM hz_parties

3288: WHERE user_id = cp_user_id;
3289:
3290: CURSOR c_user_party_name (cp_party_id IN NUMBER) IS
3291: SELECT party_name
3292: FROM hz_parties
3293: WHERE party_id = cp_party_id;
3294:
3295:
3296: BEGIN

Line 3451: l_hz_party_type hz_parties.party_type%TYPE;

3447: l_organization_id mtl_system_items_b.organization_id%TYPE;
3448: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
3449: l_approval_status mtl_system_items_b.approval_status%TYPE;
3450: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
3451: l_hz_party_type hz_parties.party_type%TYPE;
3452: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;
3453: l_party_id hz_parties.party_id%TYPE;
3454: l_party_name hz_parties.party_name%TYPE;
3455: l_role_id fnd_menus_vl.menu_id%TYPE;

Line 3453: l_party_id hz_parties.party_id%TYPE;

3449: l_approval_status mtl_system_items_b.approval_status%TYPE;
3450: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
3451: l_hz_party_type hz_parties.party_type%TYPE;
3452: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;
3453: l_party_id hz_parties.party_id%TYPE;
3454: l_party_name hz_parties.party_name%TYPE;
3455: l_role_id fnd_menus_vl.menu_id%TYPE;
3456: l_role_name fnd_menus_vl.menu_name%TYPE;
3457: l_instance_type fnd_grants.instance_type%TYPE;

Line 3454: l_party_name hz_parties.party_name%TYPE;

3450: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
3451: l_hz_party_type hz_parties.party_type%TYPE;
3452: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;
3453: l_party_id hz_parties.party_id%TYPE;
3454: l_party_name hz_parties.party_name%TYPE;
3455: l_role_id fnd_menus_vl.menu_id%TYPE;
3456: l_role_name fnd_menus_vl.menu_name%TYPE;
3457: l_instance_type fnd_grants.instance_type%TYPE;
3458: l_pk1_value fnd_grants.instance_pk1_value%TYPE;