APPS.IGS_FI_WAV_DTLS_WF dependencies on IGS_CA_INST_ALL

Line 41: CURSOR cur_cal_desc(c_cal_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,

37: uudayapr 10/27/2005 Bug 4704177 Added the workflow parameter P_FIN_AID_ADMIN to
38: pass the Notifying user based on the profile Value
39: IGS_FI_WAV_NOTIFY_USER
40: ***************************************************************** */
41: CURSOR cur_cal_desc(c_cal_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
42: c_n_load_ci_seq_number IN igs_ca_inst_all.sequence_number%TYPE
43: ) IS
44: SELECT description
45: FROM IGS_CA_INST_ALL

Line 42: c_n_load_ci_seq_number IN igs_ca_inst_all.sequence_number%TYPE

38: pass the Notifying user based on the profile Value
39: IGS_FI_WAV_NOTIFY_USER
40: ***************************************************************** */
41: CURSOR cur_cal_desc(c_cal_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
42: c_n_load_ci_seq_number IN igs_ca_inst_all.sequence_number%TYPE
43: ) IS
44: SELECT description
45: FROM IGS_CA_INST_ALL
46: WHERE cal_type = c_cal_load_cal_type

Line 45: FROM IGS_CA_INST_ALL

41: CURSOR cur_cal_desc(c_cal_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
42: c_n_load_ci_seq_number IN igs_ca_inst_all.sequence_number%TYPE
43: ) IS
44: SELECT description
45: FROM IGS_CA_INST_ALL
46: WHERE cal_type = c_cal_load_cal_type
47: AND sequence_number = c_n_load_ci_seq_number;
48:
49: CURSOR cur_person_details(c_n_person_id IN hz_parties.party_id%TYPE) IS

Line 64: l_c_load_cal_type igs_ca_inst_all.cal_type%TYPE;

60: SELECT igs_fi_wav_wf_trans_fa_s.NEXTVAL
61: FROM sys.dual;
62:
63: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
64: l_c_load_cal_type igs_ca_inst_all.cal_type%TYPE;
65: l_n_load_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
66: l_v_message_name fnd_new_messages.message_name%TYPE;
67: l_b_returnflag BOOLEAN;
68:

Line 65: l_n_load_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;

61: FROM sys.dual;
62:
63: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
64: l_c_load_cal_type igs_ca_inst_all.cal_type%TYPE;
65: l_n_load_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
66: l_v_message_name fnd_new_messages.message_name%TYPE;
67: l_b_returnflag BOOLEAN;
68:
69: l_v_load_description igs_ca_inst_all.description%TYPE;

Line 69: l_v_load_description igs_ca_inst_all.description%TYPE;

65: l_n_load_ci_seq_number igs_ca_inst_all.sequence_number%TYPE;
66: l_v_message_name fnd_new_messages.message_name%TYPE;
67: l_b_returnflag BOOLEAN;
68:
69: l_v_load_description igs_ca_inst_all.description%TYPE;
70: l_cur_person_details cur_person_details%ROWTYPE;
71: l_cur_alt_person_id cur_alt_person_id%ROWTYPE;
72: ln_seq_val NUMBER;
73: lv_raise_event VARCHAR2(100);