APPS.IGS_AD_WRKFLOW_PKG dependencies on HZ_PARTIES

Line 7: p_person_id IN hz_parties.party_id%TYPE,

3:
4: PROCEDURE Extract_Applications
5: ( errbuf OUT NOCOPY VARCHAR2,
6: retcode OUT NOCOPY NUMBER ,
7: p_person_id IN hz_parties.party_id%TYPE,
8: p_person_id_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
9: p_calendar_details IN VARCHAR2,
10: p_apc IN VARCHAR2,
11: p_appl_type IN VARCHAR2,

Line 22: l_per_num hz_parties.party_number%type;

18: ) IS
19:
20: l_appl_exist VARCHAR2(1);
21: l_user_id NUMBER;
22: l_per_num hz_parties.party_number%type;
23: l_per_num1 hz_parties.party_number%type;
24: l_person_id NUMBER;
25: l_user_name VARCHAR2(100);
26: l_full_name VARCHAR2(1000);

Line 23: l_per_num1 hz_parties.party_number%type;

19:
20: l_appl_exist VARCHAR2(1);
21: l_user_id NUMBER;
22: l_per_num hz_parties.party_number%type;
23: l_per_num1 hz_parties.party_number%type;
24: l_person_id NUMBER;
25: l_user_name VARCHAR2(100);
26: l_full_name VARCHAR2(1000);
27: l_count number := 0;

Line 500: FROM HZ_PARTIES

496: WHERE person_party_id = cp_person_id ;
497:
498: CURSOR c_per_num IS
499: SELECT party_number
500: FROM HZ_PARTIES
501: WHERE party_id = p_person_id ;
502:
503: CURSOR c_per_num1(cp_person_id igs_ss_adm_appl_stg.person_id%TYPE) IS
504: SELECT party_number

Line 505: FROM HZ_PARTIES

501: WHERE party_id = p_person_id ;
502:
503: CURSOR c_per_num1(cp_person_id igs_ss_adm_appl_stg.person_id%TYPE) IS
504: SELECT party_number
505: FROM HZ_PARTIES
506: WHERE party_id = cp_person_id ;
507:
508: BEGIN
509:

Line 1106: p_person_id IN hz_parties.party_id%TYPE,

1102:
1103: PROCEDURE Adm_Application_Req
1104: ( errbuf OUT NOCOPY VARCHAR2,
1105: retcode OUT NOCOPY NUMBER ,
1106: p_person_id IN hz_parties.party_id%TYPE,
1107: p_person_id_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
1108: p_appl_id IN igs_ad_appl.application_id%Type,
1109: p_calendar_details IN VARCHAR2,
1110: p_tracking_type IN VARCHAR2,

Line 1122: l_per_num hz_parties.party_number%type;

1118:
1119: l_appl_exist VARCHAR2(1);
1120: l_user_id NUMBER;
1121: l_person_id NUMBER;
1122: l_per_num hz_parties.party_number%type;
1123: lv_person_id VARCHAR2(300);
1124: l_person_name VARCHAR2(320);
1125: l_display_name VARCHAR2(360);
1126: l_user_name VARCHAR2(100);

Line 1227: FROM HZ_PARTIES

1223: WHERE person_party_id = cp_person_id ;
1224:
1225: CURSOR c_per_num IS
1226: SELECT party_number
1227: FROM HZ_PARTIES
1228: WHERE party_id = p_person_id ;
1229:
1230: BEGIN
1231: