eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_SS_EN_WRAPPERS dependencies on WF_PARAMETER_LIST_T

Line 1804: l_wf_parameter_list_t WF_PARAMETER_LIST_T := wf_parameter_list_t();

1800: CURSOR cur_cal_desc IS SELECT description FROM igs_ca_inst WHERE cal_type = p_load_cal_type
1801: AND sequence_number = p_load_sequence_number;
1802:
1803: l_cur_seq_val cur_seq_val%ROWTYPE;
1804: l_wf_parameter_list_t WF_PARAMETER_LIST_T := wf_parameter_list_t();
1805: l_wf_installed fnd_lookups.lookup_code%TYPE;
1806: l_wf_role VARCHAR2(100);
1807: l_cal_desc IGS_CA_INST.DESCRIPTION%TYPE;
1808:

Line 1830: wf_event.addparametertolist(P_NAME => 'STUDENT_ID' ,P_VALUE => p_person_id ,P_PARAMETERLIST => l_wf_parameter_list_t);

1826: OPEN cur_cal_desc;
1827: FETCH cur_cal_desc INTO l_cal_desc;
1828: CLOSE cur_cal_desc;
1829: -- set the event parameters
1830: wf_event.addparametertolist(P_NAME => 'STUDENT_ID' ,P_VALUE => p_person_id ,P_PARAMETERLIST => l_wf_parameter_list_t);
1831: wf_event.addparametertolist(P_NAME => 'UOO_IDS' ,P_VALUE => p_uoo_ids ,P_PARAMETERLIST => l_wf_parameter_list_t);
1832: wf_event.addparametertolist(P_NAME => 'CAL_TYPE' ,P_VALUE => p_load_cal_type ,P_PARAMETERLIST => l_wf_parameter_list_t);
1833: wf_event.addparametertolist(P_NAME => 'CAL_SEQUENCE_NUMBER' ,P_VALUE => p_load_sequence_number ,P_PARAMETERLIST => l_wf_parameter_list_t);
1834: wf_event.addparametertolist(P_NAME => 'PROGRAM_CD' ,P_VALUE => p_program_cd ,P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1831: wf_event.addparametertolist(P_NAME => 'UOO_IDS' ,P_VALUE => p_uoo_ids ,P_PARAMETERLIST => l_wf_parameter_list_t);

1827: FETCH cur_cal_desc INTO l_cal_desc;
1828: CLOSE cur_cal_desc;
1829: -- set the event parameters
1830: wf_event.addparametertolist(P_NAME => 'STUDENT_ID' ,P_VALUE => p_person_id ,P_PARAMETERLIST => l_wf_parameter_list_t);
1831: wf_event.addparametertolist(P_NAME => 'UOO_IDS' ,P_VALUE => p_uoo_ids ,P_PARAMETERLIST => l_wf_parameter_list_t);
1832: wf_event.addparametertolist(P_NAME => 'CAL_TYPE' ,P_VALUE => p_load_cal_type ,P_PARAMETERLIST => l_wf_parameter_list_t);
1833: wf_event.addparametertolist(P_NAME => 'CAL_SEQUENCE_NUMBER' ,P_VALUE => p_load_sequence_number ,P_PARAMETERLIST => l_wf_parameter_list_t);
1834: wf_event.addparametertolist(P_NAME => 'PROGRAM_CD' ,P_VALUE => p_program_cd ,P_PARAMETERLIST => l_wf_parameter_list_t);
1835: wf_event.addparametertolist(P_NAME => 'DROP_DATE' ,P_VALUE => p_drop_date ,P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1832: wf_event.addparametertolist(P_NAME => 'CAL_TYPE' ,P_VALUE => p_load_cal_type ,P_PARAMETERLIST => l_wf_parameter_list_t);

1828: CLOSE cur_cal_desc;
1829: -- set the event parameters
1830: wf_event.addparametertolist(P_NAME => 'STUDENT_ID' ,P_VALUE => p_person_id ,P_PARAMETERLIST => l_wf_parameter_list_t);
1831: wf_event.addparametertolist(P_NAME => 'UOO_IDS' ,P_VALUE => p_uoo_ids ,P_PARAMETERLIST => l_wf_parameter_list_t);
1832: wf_event.addparametertolist(P_NAME => 'CAL_TYPE' ,P_VALUE => p_load_cal_type ,P_PARAMETERLIST => l_wf_parameter_list_t);
1833: wf_event.addparametertolist(P_NAME => 'CAL_SEQUENCE_NUMBER' ,P_VALUE => p_load_sequence_number ,P_PARAMETERLIST => l_wf_parameter_list_t);
1834: wf_event.addparametertolist(P_NAME => 'PROGRAM_CD' ,P_VALUE => p_program_cd ,P_PARAMETERLIST => l_wf_parameter_list_t);
1835: wf_event.addparametertolist(P_NAME => 'DROP_DATE' ,P_VALUE => p_drop_date ,P_PARAMETERLIST => l_wf_parameter_list_t);
1836: wf_event.addparametertolist(P_NAME => 'OLD_CP' ,P_VALUE => NVL(p_old_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1833: wf_event.addparametertolist(P_NAME => 'CAL_SEQUENCE_NUMBER' ,P_VALUE => p_load_sequence_number ,P_PARAMETERLIST => l_wf_parameter_list_t);

1829: -- set the event parameters
1830: wf_event.addparametertolist(P_NAME => 'STUDENT_ID' ,P_VALUE => p_person_id ,P_PARAMETERLIST => l_wf_parameter_list_t);
1831: wf_event.addparametertolist(P_NAME => 'UOO_IDS' ,P_VALUE => p_uoo_ids ,P_PARAMETERLIST => l_wf_parameter_list_t);
1832: wf_event.addparametertolist(P_NAME => 'CAL_TYPE' ,P_VALUE => p_load_cal_type ,P_PARAMETERLIST => l_wf_parameter_list_t);
1833: wf_event.addparametertolist(P_NAME => 'CAL_SEQUENCE_NUMBER' ,P_VALUE => p_load_sequence_number ,P_PARAMETERLIST => l_wf_parameter_list_t);
1834: wf_event.addparametertolist(P_NAME => 'PROGRAM_CD' ,P_VALUE => p_program_cd ,P_PARAMETERLIST => l_wf_parameter_list_t);
1835: wf_event.addparametertolist(P_NAME => 'DROP_DATE' ,P_VALUE => p_drop_date ,P_PARAMETERLIST => l_wf_parameter_list_t);
1836: wf_event.addparametertolist(P_NAME => 'OLD_CP' ,P_VALUE => NVL(p_old_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1834: wf_event.addparametertolist(P_NAME => 'PROGRAM_CD' ,P_VALUE => p_program_cd ,P_PARAMETERLIST => l_wf_parameter_list_t);

1830: wf_event.addparametertolist(P_NAME => 'STUDENT_ID' ,P_VALUE => p_person_id ,P_PARAMETERLIST => l_wf_parameter_list_t);
1831: wf_event.addparametertolist(P_NAME => 'UOO_IDS' ,P_VALUE => p_uoo_ids ,P_PARAMETERLIST => l_wf_parameter_list_t);
1832: wf_event.addparametertolist(P_NAME => 'CAL_TYPE' ,P_VALUE => p_load_cal_type ,P_PARAMETERLIST => l_wf_parameter_list_t);
1833: wf_event.addparametertolist(P_NAME => 'CAL_SEQUENCE_NUMBER' ,P_VALUE => p_load_sequence_number ,P_PARAMETERLIST => l_wf_parameter_list_t);
1834: wf_event.addparametertolist(P_NAME => 'PROGRAM_CD' ,P_VALUE => p_program_cd ,P_PARAMETERLIST => l_wf_parameter_list_t);
1835: wf_event.addparametertolist(P_NAME => 'DROP_DATE' ,P_VALUE => p_drop_date ,P_PARAMETERLIST => l_wf_parameter_list_t);
1836: wf_event.addparametertolist(P_NAME => 'OLD_CP' ,P_VALUE => NVL(p_old_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1838: wf_event.addparametertolist(P_NAME => 'P_WF_ROLE' ,P_VALUE => l_wf_role ,P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1835: wf_event.addparametertolist(P_NAME => 'DROP_DATE' ,P_VALUE => p_drop_date ,P_PARAMETERLIST => l_wf_parameter_list_t);

1831: wf_event.addparametertolist(P_NAME => 'UOO_IDS' ,P_VALUE => p_uoo_ids ,P_PARAMETERLIST => l_wf_parameter_list_t);
1832: wf_event.addparametertolist(P_NAME => 'CAL_TYPE' ,P_VALUE => p_load_cal_type ,P_PARAMETERLIST => l_wf_parameter_list_t);
1833: wf_event.addparametertolist(P_NAME => 'CAL_SEQUENCE_NUMBER' ,P_VALUE => p_load_sequence_number ,P_PARAMETERLIST => l_wf_parameter_list_t);
1834: wf_event.addparametertolist(P_NAME => 'PROGRAM_CD' ,P_VALUE => p_program_cd ,P_PARAMETERLIST => l_wf_parameter_list_t);
1835: wf_event.addparametertolist(P_NAME => 'DROP_DATE' ,P_VALUE => p_drop_date ,P_PARAMETERLIST => l_wf_parameter_list_t);
1836: wf_event.addparametertolist(P_NAME => 'OLD_CP' ,P_VALUE => NVL(p_old_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1838: wf_event.addparametertolist(P_NAME => 'P_WF_ROLE' ,P_VALUE => l_wf_role ,P_PARAMETERLIST => l_wf_parameter_list_t);
1839: wf_event.addparametertolist(P_NAME => 'CAL_DESC' ,P_VALUE => l_cal_desc ,P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1836: wf_event.addparametertolist(P_NAME => 'OLD_CP' ,P_VALUE => NVL(p_old_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);

1832: wf_event.addparametertolist(P_NAME => 'CAL_TYPE' ,P_VALUE => p_load_cal_type ,P_PARAMETERLIST => l_wf_parameter_list_t);
1833: wf_event.addparametertolist(P_NAME => 'CAL_SEQUENCE_NUMBER' ,P_VALUE => p_load_sequence_number ,P_PARAMETERLIST => l_wf_parameter_list_t);
1834: wf_event.addparametertolist(P_NAME => 'PROGRAM_CD' ,P_VALUE => p_program_cd ,P_PARAMETERLIST => l_wf_parameter_list_t);
1835: wf_event.addparametertolist(P_NAME => 'DROP_DATE' ,P_VALUE => p_drop_date ,P_PARAMETERLIST => l_wf_parameter_list_t);
1836: wf_event.addparametertolist(P_NAME => 'OLD_CP' ,P_VALUE => NVL(p_old_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1838: wf_event.addparametertolist(P_NAME => 'P_WF_ROLE' ,P_VALUE => l_wf_role ,P_PARAMETERLIST => l_wf_parameter_list_t);
1839: wf_event.addparametertolist(P_NAME => 'CAL_DESC' ,P_VALUE => l_cal_desc ,P_PARAMETERLIST => l_wf_parameter_list_t);
1840: wf_event.addparametertolist(P_NAME => 'REASON' ,P_VALUE => igs_en_su_attempt_pkg.pkg_reason ,P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);

1833: wf_event.addparametertolist(P_NAME => 'CAL_SEQUENCE_NUMBER' ,P_VALUE => p_load_sequence_number ,P_PARAMETERLIST => l_wf_parameter_list_t);
1834: wf_event.addparametertolist(P_NAME => 'PROGRAM_CD' ,P_VALUE => p_program_cd ,P_PARAMETERLIST => l_wf_parameter_list_t);
1835: wf_event.addparametertolist(P_NAME => 'DROP_DATE' ,P_VALUE => p_drop_date ,P_PARAMETERLIST => l_wf_parameter_list_t);
1836: wf_event.addparametertolist(P_NAME => 'OLD_CP' ,P_VALUE => NVL(p_old_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1838: wf_event.addparametertolist(P_NAME => 'P_WF_ROLE' ,P_VALUE => l_wf_role ,P_PARAMETERLIST => l_wf_parameter_list_t);
1839: wf_event.addparametertolist(P_NAME => 'CAL_DESC' ,P_VALUE => l_cal_desc ,P_PARAMETERLIST => l_wf_parameter_list_t);
1840: wf_event.addparametertolist(P_NAME => 'REASON' ,P_VALUE => igs_en_su_attempt_pkg.pkg_reason ,P_PARAMETERLIST => l_wf_parameter_list_t);
1841: wf_event.addparametertolist(P_NAME => 'SOURCE_OF_DROP' ,P_VALUE => igs_en_su_attempt_pkg.pkg_source_of_drop ,P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1838: wf_event.addparametertolist(P_NAME => 'P_WF_ROLE' ,P_VALUE => l_wf_role ,P_PARAMETERLIST => l_wf_parameter_list_t);

1834: wf_event.addparametertolist(P_NAME => 'PROGRAM_CD' ,P_VALUE => p_program_cd ,P_PARAMETERLIST => l_wf_parameter_list_t);
1835: wf_event.addparametertolist(P_NAME => 'DROP_DATE' ,P_VALUE => p_drop_date ,P_PARAMETERLIST => l_wf_parameter_list_t);
1836: wf_event.addparametertolist(P_NAME => 'OLD_CP' ,P_VALUE => NVL(p_old_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1838: wf_event.addparametertolist(P_NAME => 'P_WF_ROLE' ,P_VALUE => l_wf_role ,P_PARAMETERLIST => l_wf_parameter_list_t);
1839: wf_event.addparametertolist(P_NAME => 'CAL_DESC' ,P_VALUE => l_cal_desc ,P_PARAMETERLIST => l_wf_parameter_list_t);
1840: wf_event.addparametertolist(P_NAME => 'REASON' ,P_VALUE => igs_en_su_attempt_pkg.pkg_reason ,P_PARAMETERLIST => l_wf_parameter_list_t);
1841: wf_event.addparametertolist(P_NAME => 'SOURCE_OF_DROP' ,P_VALUE => igs_en_su_attempt_pkg.pkg_source_of_drop ,P_PARAMETERLIST => l_wf_parameter_list_t);
1842:

Line 1839: wf_event.addparametertolist(P_NAME => 'CAL_DESC' ,P_VALUE => l_cal_desc ,P_PARAMETERLIST => l_wf_parameter_list_t);

1835: wf_event.addparametertolist(P_NAME => 'DROP_DATE' ,P_VALUE => p_drop_date ,P_PARAMETERLIST => l_wf_parameter_list_t);
1836: wf_event.addparametertolist(P_NAME => 'OLD_CP' ,P_VALUE => NVL(p_old_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1838: wf_event.addparametertolist(P_NAME => 'P_WF_ROLE' ,P_VALUE => l_wf_role ,P_PARAMETERLIST => l_wf_parameter_list_t);
1839: wf_event.addparametertolist(P_NAME => 'CAL_DESC' ,P_VALUE => l_cal_desc ,P_PARAMETERLIST => l_wf_parameter_list_t);
1840: wf_event.addparametertolist(P_NAME => 'REASON' ,P_VALUE => igs_en_su_attempt_pkg.pkg_reason ,P_PARAMETERLIST => l_wf_parameter_list_t);
1841: wf_event.addparametertolist(P_NAME => 'SOURCE_OF_DROP' ,P_VALUE => igs_en_su_attempt_pkg.pkg_source_of_drop ,P_PARAMETERLIST => l_wf_parameter_list_t);
1842:
1843: -- raise the event

Line 1840: wf_event.addparametertolist(P_NAME => 'REASON' ,P_VALUE => igs_en_su_attempt_pkg.pkg_reason ,P_PARAMETERLIST => l_wf_parameter_list_t);

1836: wf_event.addparametertolist(P_NAME => 'OLD_CP' ,P_VALUE => NVL(p_old_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1838: wf_event.addparametertolist(P_NAME => 'P_WF_ROLE' ,P_VALUE => l_wf_role ,P_PARAMETERLIST => l_wf_parameter_list_t);
1839: wf_event.addparametertolist(P_NAME => 'CAL_DESC' ,P_VALUE => l_cal_desc ,P_PARAMETERLIST => l_wf_parameter_list_t);
1840: wf_event.addparametertolist(P_NAME => 'REASON' ,P_VALUE => igs_en_su_attempt_pkg.pkg_reason ,P_PARAMETERLIST => l_wf_parameter_list_t);
1841: wf_event.addparametertolist(P_NAME => 'SOURCE_OF_DROP' ,P_VALUE => igs_en_su_attempt_pkg.pkg_source_of_drop ,P_PARAMETERLIST => l_wf_parameter_list_t);
1842:
1843: -- raise the event
1844: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.dropnotification',

Line 1841: wf_event.addparametertolist(P_NAME => 'SOURCE_OF_DROP' ,P_VALUE => igs_en_su_attempt_pkg.pkg_source_of_drop ,P_PARAMETERLIST => l_wf_parameter_list_t);

1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1838: wf_event.addparametertolist(P_NAME => 'P_WF_ROLE' ,P_VALUE => l_wf_role ,P_PARAMETERLIST => l_wf_parameter_list_t);
1839: wf_event.addparametertolist(P_NAME => 'CAL_DESC' ,P_VALUE => l_cal_desc ,P_PARAMETERLIST => l_wf_parameter_list_t);
1840: wf_event.addparametertolist(P_NAME => 'REASON' ,P_VALUE => igs_en_su_attempt_pkg.pkg_reason ,P_PARAMETERLIST => l_wf_parameter_list_t);
1841: wf_event.addparametertolist(P_NAME => 'SOURCE_OF_DROP' ,P_VALUE => igs_en_su_attempt_pkg.pkg_source_of_drop ,P_PARAMETERLIST => l_wf_parameter_list_t);
1842:
1843: -- raise the event
1844: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.dropnotification',
1845: p_event_key =>'oracle.apps.igs.en.dropnotification'||l_cur_seq_val.seq_val,

Line 1847: p_parameters=>l_wf_parameter_list_t);

1843: -- raise the event
1844: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.dropnotification',
1845: p_event_key =>'oracle.apps.igs.en.dropnotification'||l_cur_seq_val.seq_val,
1846: p_event_data=>NULL,
1847: p_parameters=>l_wf_parameter_list_t);
1848: END IF;
1849: p_return_status := 'TRUE';
1850: END drop_all_workflow;
1851:

Line 1886: l_wf_parameter_list_t WF_PARAMETER_LIST_T:=wf_parameter_list_t();

1882: SELECT igs_en_wf_trans_notif_s.nextval seq_val
1883: FROM DUAL;
1884:
1885: l_cur_seq_val cur_seq_val%ROWTYPE;
1886: l_wf_parameter_list_t WF_PARAMETER_LIST_T:=wf_parameter_list_t();
1887: l_wf_installed fnd_lookups.lookup_code%TYPE;
1888: BEGIN
1889: -- get the profile value that is set for checking if workflow is installed
1890: fnd_profile.get('IGS_WF_ENABLE',l_wf_installed);

Line 1900: wf_event.addparametertolist(p_Name=>'SOURCE_UOO_IDS' ,p_Value=>p_source_uoo_ids ,p_Parameterlist =>l_wf_parameter_list_t);

1896: FETCH cur_seq_val INTO l_cur_seq_val;
1897: CLOSE cur_seq_val;
1898:
1899: -- set the event parameters
1900: wf_event.addparametertolist(p_Name=>'SOURCE_UOO_IDS' ,p_Value=>p_source_uoo_ids ,p_Parameterlist =>l_wf_parameter_list_t);
1901: wf_event.addparametertolist(p_Name=>'DEST_UOO_IDS' ,p_Value=>p_dest_uoo_ids ,p_Parameterlist =>l_wf_parameter_list_t);
1902: wf_event.addparametertolist(p_Name=>'STUDENT_ID' ,p_Value=>p_person_id ,p_Parameterlist =>l_wf_parameter_list_t);
1903: wf_event.addparametertolist(p_Name=>'CAL_TYPE' ,p_Value=>p_load_cal_type ,p_Parameterlist =>l_wf_parameter_list_t);
1904: wf_event.addparametertolist(p_Name=>'CAL_SEQUENCE_NUMBER' ,p_Value=>p_load_sequence_number ,p_Parameterlist =>l_wf_parameter_list_t);

Line 1901: wf_event.addparametertolist(p_Name=>'DEST_UOO_IDS' ,p_Value=>p_dest_uoo_ids ,p_Parameterlist =>l_wf_parameter_list_t);

1897: CLOSE cur_seq_val;
1898:
1899: -- set the event parameters
1900: wf_event.addparametertolist(p_Name=>'SOURCE_UOO_IDS' ,p_Value=>p_source_uoo_ids ,p_Parameterlist =>l_wf_parameter_list_t);
1901: wf_event.addparametertolist(p_Name=>'DEST_UOO_IDS' ,p_Value=>p_dest_uoo_ids ,p_Parameterlist =>l_wf_parameter_list_t);
1902: wf_event.addparametertolist(p_Name=>'STUDENT_ID' ,p_Value=>p_person_id ,p_Parameterlist =>l_wf_parameter_list_t);
1903: wf_event.addparametertolist(p_Name=>'CAL_TYPE' ,p_Value=>p_load_cal_type ,p_Parameterlist =>l_wf_parameter_list_t);
1904: wf_event.addparametertolist(p_Name=>'CAL_SEQUENCE_NUMBER' ,p_Value=>p_load_sequence_number ,p_Parameterlist =>l_wf_parameter_list_t);
1905: wf_event.addparametertolist(p_Name=>'PROGRAM_CD' ,p_Value=>p_program_cd ,p_Parameterlist =>l_wf_parameter_list_t);

Line 1902: wf_event.addparametertolist(p_Name=>'STUDENT_ID' ,p_Value=>p_person_id ,p_Parameterlist =>l_wf_parameter_list_t);

1898:
1899: -- set the event parameters
1900: wf_event.addparametertolist(p_Name=>'SOURCE_UOO_IDS' ,p_Value=>p_source_uoo_ids ,p_Parameterlist =>l_wf_parameter_list_t);
1901: wf_event.addparametertolist(p_Name=>'DEST_UOO_IDS' ,p_Value=>p_dest_uoo_ids ,p_Parameterlist =>l_wf_parameter_list_t);
1902: wf_event.addparametertolist(p_Name=>'STUDENT_ID' ,p_Value=>p_person_id ,p_Parameterlist =>l_wf_parameter_list_t);
1903: wf_event.addparametertolist(p_Name=>'CAL_TYPE' ,p_Value=>p_load_cal_type ,p_Parameterlist =>l_wf_parameter_list_t);
1904: wf_event.addparametertolist(p_Name=>'CAL_SEQUENCE_NUMBER' ,p_Value=>p_load_sequence_number ,p_Parameterlist =>l_wf_parameter_list_t);
1905: wf_event.addparametertolist(p_Name=>'PROGRAM_CD' ,p_Value=>p_program_cd ,p_Parameterlist =>l_wf_parameter_list_t);
1906: wf_event.addparametertolist(p_Name=>'UNIT_ATTEMPT_STATUS' ,p_Value=>p_unit_attempt_status ,p_Parameterlist =>l_wf_parameter_list_t);

Line 1903: wf_event.addparametertolist(p_Name=>'CAL_TYPE' ,p_Value=>p_load_cal_type ,p_Parameterlist =>l_wf_parameter_list_t);

1899: -- set the event parameters
1900: wf_event.addparametertolist(p_Name=>'SOURCE_UOO_IDS' ,p_Value=>p_source_uoo_ids ,p_Parameterlist =>l_wf_parameter_list_t);
1901: wf_event.addparametertolist(p_Name=>'DEST_UOO_IDS' ,p_Value=>p_dest_uoo_ids ,p_Parameterlist =>l_wf_parameter_list_t);
1902: wf_event.addparametertolist(p_Name=>'STUDENT_ID' ,p_Value=>p_person_id ,p_Parameterlist =>l_wf_parameter_list_t);
1903: wf_event.addparametertolist(p_Name=>'CAL_TYPE' ,p_Value=>p_load_cal_type ,p_Parameterlist =>l_wf_parameter_list_t);
1904: wf_event.addparametertolist(p_Name=>'CAL_SEQUENCE_NUMBER' ,p_Value=>p_load_sequence_number ,p_Parameterlist =>l_wf_parameter_list_t);
1905: wf_event.addparametertolist(p_Name=>'PROGRAM_CD' ,p_Value=>p_program_cd ,p_Parameterlist =>l_wf_parameter_list_t);
1906: wf_event.addparametertolist(p_Name=>'UNIT_ATTEMPT_STATUS' ,p_Value=>p_unit_attempt_status ,p_Parameterlist =>l_wf_parameter_list_t);
1907: wf_event.addparametertolist(p_Name=>'REASON' ,p_Value=>p_reason ,p_Parameterlist =>l_wf_parameter_list_t);

Line 1904: wf_event.addparametertolist(p_Name=>'CAL_SEQUENCE_NUMBER' ,p_Value=>p_load_sequence_number ,p_Parameterlist =>l_wf_parameter_list_t);

1900: wf_event.addparametertolist(p_Name=>'SOURCE_UOO_IDS' ,p_Value=>p_source_uoo_ids ,p_Parameterlist =>l_wf_parameter_list_t);
1901: wf_event.addparametertolist(p_Name=>'DEST_UOO_IDS' ,p_Value=>p_dest_uoo_ids ,p_Parameterlist =>l_wf_parameter_list_t);
1902: wf_event.addparametertolist(p_Name=>'STUDENT_ID' ,p_Value=>p_person_id ,p_Parameterlist =>l_wf_parameter_list_t);
1903: wf_event.addparametertolist(p_Name=>'CAL_TYPE' ,p_Value=>p_load_cal_type ,p_Parameterlist =>l_wf_parameter_list_t);
1904: wf_event.addparametertolist(p_Name=>'CAL_SEQUENCE_NUMBER' ,p_Value=>p_load_sequence_number ,p_Parameterlist =>l_wf_parameter_list_t);
1905: wf_event.addparametertolist(p_Name=>'PROGRAM_CD' ,p_Value=>p_program_cd ,p_Parameterlist =>l_wf_parameter_list_t);
1906: wf_event.addparametertolist(p_Name=>'UNIT_ATTEMPT_STATUS' ,p_Value=>p_unit_attempt_status ,p_Parameterlist =>l_wf_parameter_list_t);
1907: wf_event.addparametertolist(p_Name=>'REASON' ,p_Value=>p_reason ,p_Parameterlist =>l_wf_parameter_list_t);
1908:

Line 1905: wf_event.addparametertolist(p_Name=>'PROGRAM_CD' ,p_Value=>p_program_cd ,p_Parameterlist =>l_wf_parameter_list_t);

1901: wf_event.addparametertolist(p_Name=>'DEST_UOO_IDS' ,p_Value=>p_dest_uoo_ids ,p_Parameterlist =>l_wf_parameter_list_t);
1902: wf_event.addparametertolist(p_Name=>'STUDENT_ID' ,p_Value=>p_person_id ,p_Parameterlist =>l_wf_parameter_list_t);
1903: wf_event.addparametertolist(p_Name=>'CAL_TYPE' ,p_Value=>p_load_cal_type ,p_Parameterlist =>l_wf_parameter_list_t);
1904: wf_event.addparametertolist(p_Name=>'CAL_SEQUENCE_NUMBER' ,p_Value=>p_load_sequence_number ,p_Parameterlist =>l_wf_parameter_list_t);
1905: wf_event.addparametertolist(p_Name=>'PROGRAM_CD' ,p_Value=>p_program_cd ,p_Parameterlist =>l_wf_parameter_list_t);
1906: wf_event.addparametertolist(p_Name=>'UNIT_ATTEMPT_STATUS' ,p_Value=>p_unit_attempt_status ,p_Parameterlist =>l_wf_parameter_list_t);
1907: wf_event.addparametertolist(p_Name=>'REASON' ,p_Value=>p_reason ,p_Parameterlist =>l_wf_parameter_list_t);
1908:
1909: -- raise the event

Line 1906: wf_event.addparametertolist(p_Name=>'UNIT_ATTEMPT_STATUS' ,p_Value=>p_unit_attempt_status ,p_Parameterlist =>l_wf_parameter_list_t);

1902: wf_event.addparametertolist(p_Name=>'STUDENT_ID' ,p_Value=>p_person_id ,p_Parameterlist =>l_wf_parameter_list_t);
1903: wf_event.addparametertolist(p_Name=>'CAL_TYPE' ,p_Value=>p_load_cal_type ,p_Parameterlist =>l_wf_parameter_list_t);
1904: wf_event.addparametertolist(p_Name=>'CAL_SEQUENCE_NUMBER' ,p_Value=>p_load_sequence_number ,p_Parameterlist =>l_wf_parameter_list_t);
1905: wf_event.addparametertolist(p_Name=>'PROGRAM_CD' ,p_Value=>p_program_cd ,p_Parameterlist =>l_wf_parameter_list_t);
1906: wf_event.addparametertolist(p_Name=>'UNIT_ATTEMPT_STATUS' ,p_Value=>p_unit_attempt_status ,p_Parameterlist =>l_wf_parameter_list_t);
1907: wf_event.addparametertolist(p_Name=>'REASON' ,p_Value=>p_reason ,p_Parameterlist =>l_wf_parameter_list_t);
1908:
1909: -- raise the event
1910: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.transfernotification',

Line 1907: wf_event.addparametertolist(p_Name=>'REASON' ,p_Value=>p_reason ,p_Parameterlist =>l_wf_parameter_list_t);

1903: wf_event.addparametertolist(p_Name=>'CAL_TYPE' ,p_Value=>p_load_cal_type ,p_Parameterlist =>l_wf_parameter_list_t);
1904: wf_event.addparametertolist(p_Name=>'CAL_SEQUENCE_NUMBER' ,p_Value=>p_load_sequence_number ,p_Parameterlist =>l_wf_parameter_list_t);
1905: wf_event.addparametertolist(p_Name=>'PROGRAM_CD' ,p_Value=>p_program_cd ,p_Parameterlist =>l_wf_parameter_list_t);
1906: wf_event.addparametertolist(p_Name=>'UNIT_ATTEMPT_STATUS' ,p_Value=>p_unit_attempt_status ,p_Parameterlist =>l_wf_parameter_list_t);
1907: wf_event.addparametertolist(p_Name=>'REASON' ,p_Value=>p_reason ,p_Parameterlist =>l_wf_parameter_list_t);
1908:
1909: -- raise the event
1910: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.transfernotification',
1911: p_event_key =>'oracle.apps.igs.en.transfernotification'||l_cur_seq_val.seq_val,

Line 1913: p_parameters=>l_wf_parameter_list_t);

1909: -- raise the event
1910: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.transfernotification',
1911: p_event_key =>'oracle.apps.igs.en.transfernotification'||l_cur_seq_val.seq_val,
1912: p_event_data=>NULL,
1913: p_parameters=>l_wf_parameter_list_t);
1914: END IF;
1915: p_return_status := 'TRUE';
1916: END transfer_workflow;
1917: