APPS.EGO_ITEM_PVT dependencies on HZ_PARTIES

Line 343: l_hz_party_type HZ_PARTIES.party_type%TYPE;

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

Line 368: FROM hz_parties

364: -- validate the party_id passed.
365: BEGIN
366: SELECT party_id, party_name
367: INTO x_party_id, x_party_name
368: FROM hz_parties
369: WHERE party_id = x_party_id
370: AND party_type = l_hz_party_type;
371: RETURN TRUE;
372: EXCEPTION

Line 383: FROM hz_parties

379: -- validate the party_name passed.
380: BEGIN
381: SELECT party_id, party_name
382: INTO x_party_id, x_party_name
383: FROM hz_parties
384: WHERE party_name = x_party_name
385: AND party_type = l_hz_party_type;
386: RETURN TRUE;
387: EXCEPTION

Line 3016: l_owner_party_id hz_parties.party_id%TYPE;

3012: ,p_set_message IN VARCHAR2
3013: ) RETURN BOOLEAN IS
3014: TYPE dynamic_cur IS REF CURSOR;
3015: c_priv_cursor dynamic_cur;
3016: l_owner_party_id hz_parties.party_id%TYPE;
3017: l_owner_party_name hz_parties.party_name%TYPE;
3018: l_sec_predicate VARCHAR2(32767);
3019: l_return_status VARCHAR2(10);
3020: l_select_sql VARCHAR2(32767);

Line 3017: l_owner_party_name hz_parties.party_name%TYPE;

3013: ) RETURN BOOLEAN IS
3014: TYPE dynamic_cur IS REF CURSOR;
3015: c_priv_cursor dynamic_cur;
3016: l_owner_party_id hz_parties.party_id%TYPE;
3017: l_owner_party_name hz_parties.party_name%TYPE;
3018: l_sec_predicate VARCHAR2(32767);
3019: l_return_status VARCHAR2(10);
3020: l_select_sql VARCHAR2(32767);
3021: l_dummy_number NUMBER;

Line 3032: FROM hz_parties

3028: WHERE user_id = cp_user_id;
3029:
3030: CURSOR c_user_party_name (cp_party_id IN NUMBER) IS
3031: SELECT party_name
3032: FROM hz_parties
3033: WHERE party_id = cp_party_id;
3034:
3035:
3036: BEGIN

Line 3191: l_hz_party_type hz_parties.party_type%TYPE;

3187: l_organization_id mtl_system_items_b.organization_id%TYPE;
3188: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
3189: l_approval_status mtl_system_items_b.approval_status%TYPE;
3190: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
3191: l_hz_party_type hz_parties.party_type%TYPE;
3192: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;
3193: l_party_id hz_parties.party_id%TYPE;
3194: l_party_name hz_parties.party_name%TYPE;
3195: l_role_id fnd_menus_vl.menu_id%TYPE;

Line 3193: l_party_id hz_parties.party_id%TYPE;

3189: l_approval_status mtl_system_items_b.approval_status%TYPE;
3190: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
3191: l_hz_party_type hz_parties.party_type%TYPE;
3192: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;
3193: l_party_id hz_parties.party_id%TYPE;
3194: l_party_name hz_parties.party_name%TYPE;
3195: l_role_id fnd_menus_vl.menu_id%TYPE;
3196: l_role_name fnd_menus_vl.menu_name%TYPE;
3197: l_instance_type fnd_grants.instance_type%TYPE;

Line 3194: l_party_name hz_parties.party_name%TYPE;

3190: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
3191: l_hz_party_type hz_parties.party_type%TYPE;
3192: l_instance_set_id fnd_object_instance_sets.instance_set_id%TYPE;
3193: l_party_id hz_parties.party_id%TYPE;
3194: l_party_name hz_parties.party_name%TYPE;
3195: l_role_id fnd_menus_vl.menu_id%TYPE;
3196: l_role_name fnd_menus_vl.menu_name%TYPE;
3197: l_instance_type fnd_grants.instance_type%TYPE;
3198: l_pk1_value fnd_grants.instance_pk1_value%TYPE;