APPS.IGS_PS_WF_EVENT_PKG dependencies on IGS_CA_INST

Line 326: l_c_cal_type igs_ca_inst.cal_type%TYPE;

322: l_wf_event_t WF_EVENT_T;
323: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
324:
325: l_c_user_name fnd_user.user_name%TYPE:=fnd_global.user_name;
326: l_c_cal_type igs_ca_inst.cal_type%TYPE;
327: l_n_cal_seq_num igs_ca_inst.sequence_number%TYPE;
328:
329: /* Cursor to find the setup in the Employment Category*/
330:

Line 327: l_n_cal_seq_num igs_ca_inst.sequence_number%TYPE;

323: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
324:
325: l_c_user_name fnd_user.user_name%TYPE:=fnd_global.user_name;
326: l_c_cal_type igs_ca_inst.cal_type%TYPE;
327: l_n_cal_seq_num igs_ca_inst.sequence_number%TYPE;
328:
329: /* Cursor to find the setup in the Employment Category*/
330:
331: CURSOR c_emp_cat_setup IS

Line 497: l_c_cal_type igs_ca_inst.cal_type%TYPE;

493: AS
494: l_c_document VARCHAR2(32000);
495: l_c_itemtype VARCHAR2(100);
496: l_c_itemkey WF_ITEM_ATTRIBUTE_VALUES.ITEM_KEY%TYPE;
497: l_c_cal_type igs_ca_inst.cal_type%TYPE;
498: l_n_cal_seq_num igs_ca_inst.sequence_number%TYPE;
499: l_n_tot_fac_wl NUMBER:=0;
500: l_n_exp_wl NUMBER(10,2):=0;
501: l_n_cntr NUMBER(5):=0;

Line 498: l_n_cal_seq_num igs_ca_inst.sequence_number%TYPE;

494: l_c_document VARCHAR2(32000);
495: l_c_itemtype VARCHAR2(100);
496: l_c_itemkey WF_ITEM_ATTRIBUTE_VALUES.ITEM_KEY%TYPE;
497: l_c_cal_type igs_ca_inst.cal_type%TYPE;
498: l_n_cal_seq_num igs_ca_inst.sequence_number%TYPE;
499: l_n_tot_fac_wl NUMBER:=0;
500: l_n_exp_wl NUMBER(10,2):=0;
501: l_n_cntr NUMBER(5):=0;
502:

Line 527: PROCEDURE print_fac_list(p_n_person_id hz_parties.party_id%TYPE,p_c_cal_type igs_ca_inst.cal_type%TYPE,p_n_cal_seq_num igs_ca_inst.sequence_number%TYPE) AS

523: TRUNC(SYSDATE) BETWEEN peo.effective_start_date AND peo.effective_end_date;
524:
525: l_n_person_id hz_parties.party_id%TYPE;
526:
527: PROCEDURE print_fac_list(p_n_person_id hz_parties.party_id%TYPE,p_c_cal_type igs_ca_inst.cal_type%TYPE,p_n_cal_seq_num igs_ca_inst.sequence_number%TYPE) AS
528:
529: /* Cursor to get the person name */
530:
531: CURSOR c_person_name(cp_n_person_id hz_parties.party_id%TYPE) IS