APPS.IGS_AD_WRKFLOW_PKG dependencies on IGS_AD_APPL

Line 1059: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.incmpl_appl',

1055: -- wf_event.AddParameterToList ( p_Name => 'IA_INCOM_APPL_URL',p_Value => l_incomplt_appl_url, p_parameterlist=>l_parameter_list_t);
1056:
1057: -- raise the event
1058:
1059: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.incmpl_appl',
1060: p_event_key => l_itemKey,
1061: p_parameters => l_parameter_list_t);
1062:
1063: l_parameter_list_t.delete;

Line 1084: l_url varchar2(4000) := 'http://qapache.us.oracle.com:16526/OA_HTML/OA.jsp?akRegionCode=IGS_AD_APPL_INCOMPLETE_PAGE&akRegionApplicationId=8405';

1080: l_person_id VARCHAR2(30);
1081: -- l_profile_value VARCHAR2(200) := FND_PROFILE.VALUE('APPS_JSP_AGENT');
1082:
1083:
1084: l_url varchar2(4000) := 'http://qapache.us.oracle.com:16526/OA_HTML/OA.jsp?akRegionCode=IGS_AD_APPL_INCOMPLETE_PAGE&akRegionApplicationId=8405';
1085: l_value varchar2(100);
1086:
1087: BEGIN
1088: IF (funcmode = 'RUN') THEN

Line 1108: p_appl_id IN igs_ad_appl.application_id%Type,

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,
1111: p_apc IN VARCHAR2,
1112: p_appl_type IN VARCHAR2,

Line 1142: from igs_ad_appl_all a,

1138: l_alt_code_adm igs_ca_inst.alternate_code%TYPE;
1139:
1140: Cursor c_per_adm_req IS
1141: select a.person_id
1142: from igs_ad_appl_all a,
1143: igs_ad_ps_appl_inst_all i,
1144: igs_ad_aplins_admreq r,
1145: igs_tr_item_all t,
1146: igs_tr_type_all ty

Line 1179: from igs_ad_appl_all a,

1175: Group by a.person_id;
1176:
1177: Cursor c_per_post_adm_req IS
1178: select a.person_id
1179: from igs_ad_appl_all a,
1180: igs_ad_ps_appl_inst_all i,
1181: igs_ad_aplins_admreq r,
1182: igs_tr_item_all t,
1183: igs_tr_type_all ty

Line 1220: CURSOR cur_user(cp_person_id igs_ad_appl_all.person_id%TYPE) IS

1216: FROM IGS_CA_INST
1217: WHERE cal_type = cp_cal_type AND
1218: sequence_number = cp_seq_no;
1219:
1220: CURSOR cur_user(cp_person_id igs_ad_appl_all.person_id%TYPE) IS
1221: SELECT user_name, description
1222: FROM FND_USER
1223: WHERE person_party_id = cp_person_id ;
1224:

Line 1567: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.adm_req',

1563:
1564: --
1565: -- raise the event
1566: --
1567: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.adm_req',
1568: p_event_key => l_itemKey,
1569: p_parameters => l_parameter_list_t);
1570:
1571: l_parameter_list_t.delete;

Line 1620: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.post_adm_req',

1616: --
1617: -- raise the event
1618: --
1619:
1620: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.post_adm_req',
1621: p_event_key => l_itemKey,
1622: p_parameters => l_parameter_list_t);
1623:
1624: l_parameter_list_t.delete;