DBA Data[Home] [Help]

APPS.IGS_AS_GRD_ATT_BE_PKG dependencies on WF_EVENT

Line 37: l_event_t wf_event_t;

33: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
34: p_grading_period_cd IN igs_as_su_stmptout.grading_period_cd%TYPE
35: )
36: IS
37: l_event_t wf_event_t;
38: l_parameter_list_t wf_parameter_list_t;
39: l_itemKey varchar2(100);
40:
41: CURSOR cur_seq IS

Line 49: -- initialize the wf_event_t object

45: BEGIN
46: --Changing Date to Character
47: -- l_request_date := TO_CHAR(p_request_date,'DD-MON-YY');
48: --
49: -- initialize the wf_event_t object
50: --
51: wf_event_t.Initialize(l_event_t);
52: --
53: -- set the event name

Line 51: wf_event_t.Initialize(l_event_t);

47: -- l_request_date := TO_CHAR(p_request_date,'DD-MON-YY');
48: --
49: -- initialize the wf_event_t object
50: --
51: wf_event_t.Initialize(l_event_t);
52: --
53: -- set the event name
54: --
55: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmcg');

Line 55: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmcg');

51: wf_event_t.Initialize(l_event_t);
52: --
53: -- set the event name
54: --
55: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmcg');
56: --
57: -- set the event key but before the select a number from sequence
58: --
59:

Line 68: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmcg'||l_key );

64: CLOSE cur_seq ;
65:
66:
67:
68: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmcg'||l_key );
69: --
70: -- set the parameter list
71: --
72: -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );

Line 73: -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );

69: --
70: -- set the parameter list
71: --
72: -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );
73: -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );
74: --
75: -- now add the parameters to the parameter list
76: --
77:

Line 78: wf_event.AddParameterToList ( p_Name => 'PERSON_ID',p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);

74: --
75: -- now add the parameters to the parameter list
76: --
77:
78: wf_event.AddParameterToList ( p_Name => 'PERSON_ID',p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
79: wf_event.AddParameterToList ( p_Name => 'PERSON_NAME',p_Value => p_person_name,p_parameterlist=>l_parameter_list_t);
80: wf_event.AddParameterToList ( p_Name => 'PERSON_NUMBER',p_Value => p_person_number,p_parameterlist=>l_parameter_list_t);
81: wf_event.AddParameterToList ( p_Name => 'COURSE_CD',p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
82: wf_event.AddParameterToList ( p_Name => 'UNIT_CODE',p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);

Line 79: wf_event.AddParameterToList ( p_Name => 'PERSON_NAME',p_Value => p_person_name,p_parameterlist=>l_parameter_list_t);

75: -- now add the parameters to the parameter list
76: --
77:
78: wf_event.AddParameterToList ( p_Name => 'PERSON_ID',p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
79: wf_event.AddParameterToList ( p_Name => 'PERSON_NAME',p_Value => p_person_name,p_parameterlist=>l_parameter_list_t);
80: wf_event.AddParameterToList ( p_Name => 'PERSON_NUMBER',p_Value => p_person_number,p_parameterlist=>l_parameter_list_t);
81: wf_event.AddParameterToList ( p_Name => 'COURSE_CD',p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
82: wf_event.AddParameterToList ( p_Name => 'UNIT_CODE',p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
83: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION',p_Value => p_unit_section,p_parameterlist=>l_parameter_list_t);

Line 80: wf_event.AddParameterToList ( p_Name => 'PERSON_NUMBER',p_Value => p_person_number,p_parameterlist=>l_parameter_list_t);

76: --
77:
78: wf_event.AddParameterToList ( p_Name => 'PERSON_ID',p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
79: wf_event.AddParameterToList ( p_Name => 'PERSON_NAME',p_Value => p_person_name,p_parameterlist=>l_parameter_list_t);
80: wf_event.AddParameterToList ( p_Name => 'PERSON_NUMBER',p_Value => p_person_number,p_parameterlist=>l_parameter_list_t);
81: wf_event.AddParameterToList ( p_Name => 'COURSE_CD',p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
82: wf_event.AddParameterToList ( p_Name => 'UNIT_CODE',p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
83: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION',p_Value => p_unit_section,p_parameterlist=>l_parameter_list_t);
84: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE',p_Value => p_title,p_parameterlist=>l_parameter_list_t);

Line 81: wf_event.AddParameterToList ( p_Name => 'COURSE_CD',p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);

77:
78: wf_event.AddParameterToList ( p_Name => 'PERSON_ID',p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
79: wf_event.AddParameterToList ( p_Name => 'PERSON_NAME',p_Value => p_person_name,p_parameterlist=>l_parameter_list_t);
80: wf_event.AddParameterToList ( p_Name => 'PERSON_NUMBER',p_Value => p_person_number,p_parameterlist=>l_parameter_list_t);
81: wf_event.AddParameterToList ( p_Name => 'COURSE_CD',p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
82: wf_event.AddParameterToList ( p_Name => 'UNIT_CODE',p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
83: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION',p_Value => p_unit_section,p_parameterlist=>l_parameter_list_t);
84: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE',p_Value => p_title,p_parameterlist=>l_parameter_list_t);
85: wf_event.AddParameterToList ( p_Name => 'GRADING_SCHEMA',p_Value => p_grading_schema,p_parameterlist=>l_parameter_list_t);

Line 82: wf_event.AddParameterToList ( p_Name => 'UNIT_CODE',p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);

78: wf_event.AddParameterToList ( p_Name => 'PERSON_ID',p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
79: wf_event.AddParameterToList ( p_Name => 'PERSON_NAME',p_Value => p_person_name,p_parameterlist=>l_parameter_list_t);
80: wf_event.AddParameterToList ( p_Name => 'PERSON_NUMBER',p_Value => p_person_number,p_parameterlist=>l_parameter_list_t);
81: wf_event.AddParameterToList ( p_Name => 'COURSE_CD',p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
82: wf_event.AddParameterToList ( p_Name => 'UNIT_CODE',p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
83: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION',p_Value => p_unit_section,p_parameterlist=>l_parameter_list_t);
84: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE',p_Value => p_title,p_parameterlist=>l_parameter_list_t);
85: wf_event.AddParameterToList ( p_Name => 'GRADING_SCHEMA',p_Value => p_grading_schema,p_parameterlist=>l_parameter_list_t);
86: wf_event.AddParameterToList ( p_Name => 'CURRENT_MARK',p_Value => p_current_mark,p_parameterlist=>l_parameter_list_t);

Line 83: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION',p_Value => p_unit_section,p_parameterlist=>l_parameter_list_t);

79: wf_event.AddParameterToList ( p_Name => 'PERSON_NAME',p_Value => p_person_name,p_parameterlist=>l_parameter_list_t);
80: wf_event.AddParameterToList ( p_Name => 'PERSON_NUMBER',p_Value => p_person_number,p_parameterlist=>l_parameter_list_t);
81: wf_event.AddParameterToList ( p_Name => 'COURSE_CD',p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
82: wf_event.AddParameterToList ( p_Name => 'UNIT_CODE',p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
83: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION',p_Value => p_unit_section,p_parameterlist=>l_parameter_list_t);
84: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE',p_Value => p_title,p_parameterlist=>l_parameter_list_t);
85: wf_event.AddParameterToList ( p_Name => 'GRADING_SCHEMA',p_Value => p_grading_schema,p_parameterlist=>l_parameter_list_t);
86: wf_event.AddParameterToList ( p_Name => 'CURRENT_MARK',p_Value => p_current_mark,p_parameterlist=>l_parameter_list_t);
87: wf_event.AddParameterToList ( p_Name => 'CURRENT_GRADE',p_Value => p_current_grade,p_parameterlist=>l_parameter_list_t);

Line 84: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE',p_Value => p_title,p_parameterlist=>l_parameter_list_t);

80: wf_event.AddParameterToList ( p_Name => 'PERSON_NUMBER',p_Value => p_person_number,p_parameterlist=>l_parameter_list_t);
81: wf_event.AddParameterToList ( p_Name => 'COURSE_CD',p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
82: wf_event.AddParameterToList ( p_Name => 'UNIT_CODE',p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
83: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION',p_Value => p_unit_section,p_parameterlist=>l_parameter_list_t);
84: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE',p_Value => p_title,p_parameterlist=>l_parameter_list_t);
85: wf_event.AddParameterToList ( p_Name => 'GRADING_SCHEMA',p_Value => p_grading_schema,p_parameterlist=>l_parameter_list_t);
86: wf_event.AddParameterToList ( p_Name => 'CURRENT_MARK',p_Value => p_current_mark,p_parameterlist=>l_parameter_list_t);
87: wf_event.AddParameterToList ( p_Name => 'CURRENT_GRADE',p_Value => p_current_grade,p_parameterlist=>l_parameter_list_t);
88: wf_event.AddParameterToList ( p_Name => 'CHANGE_MARK',p_Value => p_change_mark,p_parameterlist=>l_parameter_list_t);

Line 85: wf_event.AddParameterToList ( p_Name => 'GRADING_SCHEMA',p_Value => p_grading_schema,p_parameterlist=>l_parameter_list_t);

81: wf_event.AddParameterToList ( p_Name => 'COURSE_CD',p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
82: wf_event.AddParameterToList ( p_Name => 'UNIT_CODE',p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
83: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION',p_Value => p_unit_section,p_parameterlist=>l_parameter_list_t);
84: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE',p_Value => p_title,p_parameterlist=>l_parameter_list_t);
85: wf_event.AddParameterToList ( p_Name => 'GRADING_SCHEMA',p_Value => p_grading_schema,p_parameterlist=>l_parameter_list_t);
86: wf_event.AddParameterToList ( p_Name => 'CURRENT_MARK',p_Value => p_current_mark,p_parameterlist=>l_parameter_list_t);
87: wf_event.AddParameterToList ( p_Name => 'CURRENT_GRADE',p_Value => p_current_grade,p_parameterlist=>l_parameter_list_t);
88: wf_event.AddParameterToList ( p_Name => 'CHANGE_MARK',p_Value => p_change_mark,p_parameterlist=>l_parameter_list_t);
89: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE',p_Value => p_change_grade,p_parameterlist=>l_parameter_list_t);

Line 86: wf_event.AddParameterToList ( p_Name => 'CURRENT_MARK',p_Value => p_current_mark,p_parameterlist=>l_parameter_list_t);

82: wf_event.AddParameterToList ( p_Name => 'UNIT_CODE',p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
83: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION',p_Value => p_unit_section,p_parameterlist=>l_parameter_list_t);
84: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE',p_Value => p_title,p_parameterlist=>l_parameter_list_t);
85: wf_event.AddParameterToList ( p_Name => 'GRADING_SCHEMA',p_Value => p_grading_schema,p_parameterlist=>l_parameter_list_t);
86: wf_event.AddParameterToList ( p_Name => 'CURRENT_MARK',p_Value => p_current_mark,p_parameterlist=>l_parameter_list_t);
87: wf_event.AddParameterToList ( p_Name => 'CURRENT_GRADE',p_Value => p_current_grade,p_parameterlist=>l_parameter_list_t);
88: wf_event.AddParameterToList ( p_Name => 'CHANGE_MARK',p_Value => p_change_mark,p_parameterlist=>l_parameter_list_t);
89: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE',p_Value => p_change_grade,p_parameterlist=>l_parameter_list_t);
90: wf_event.AddParameterToList ( p_Name => 'REQUESTER_ID',p_Value => p_requester_id,p_parameterlist=>l_parameter_list_t);

Line 87: wf_event.AddParameterToList ( p_Name => 'CURRENT_GRADE',p_Value => p_current_grade,p_parameterlist=>l_parameter_list_t);

83: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION',p_Value => p_unit_section,p_parameterlist=>l_parameter_list_t);
84: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE',p_Value => p_title,p_parameterlist=>l_parameter_list_t);
85: wf_event.AddParameterToList ( p_Name => 'GRADING_SCHEMA',p_Value => p_grading_schema,p_parameterlist=>l_parameter_list_t);
86: wf_event.AddParameterToList ( p_Name => 'CURRENT_MARK',p_Value => p_current_mark,p_parameterlist=>l_parameter_list_t);
87: wf_event.AddParameterToList ( p_Name => 'CURRENT_GRADE',p_Value => p_current_grade,p_parameterlist=>l_parameter_list_t);
88: wf_event.AddParameterToList ( p_Name => 'CHANGE_MARK',p_Value => p_change_mark,p_parameterlist=>l_parameter_list_t);
89: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE',p_Value => p_change_grade,p_parameterlist=>l_parameter_list_t);
90: wf_event.AddParameterToList ( p_Name => 'REQUESTER_ID',p_Value => p_requester_id,p_parameterlist=>l_parameter_list_t);
91: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NAME',p_Value => p_requester_name,p_parameterlist=>l_parameter_list_t);

Line 88: wf_event.AddParameterToList ( p_Name => 'CHANGE_MARK',p_Value => p_change_mark,p_parameterlist=>l_parameter_list_t);

84: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE',p_Value => p_title,p_parameterlist=>l_parameter_list_t);
85: wf_event.AddParameterToList ( p_Name => 'GRADING_SCHEMA',p_Value => p_grading_schema,p_parameterlist=>l_parameter_list_t);
86: wf_event.AddParameterToList ( p_Name => 'CURRENT_MARK',p_Value => p_current_mark,p_parameterlist=>l_parameter_list_t);
87: wf_event.AddParameterToList ( p_Name => 'CURRENT_GRADE',p_Value => p_current_grade,p_parameterlist=>l_parameter_list_t);
88: wf_event.AddParameterToList ( p_Name => 'CHANGE_MARK',p_Value => p_change_mark,p_parameterlist=>l_parameter_list_t);
89: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE',p_Value => p_change_grade,p_parameterlist=>l_parameter_list_t);
90: wf_event.AddParameterToList ( p_Name => 'REQUESTER_ID',p_Value => p_requester_id,p_parameterlist=>l_parameter_list_t);
91: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NAME',p_Value => p_requester_name,p_parameterlist=>l_parameter_list_t);
92: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NUMBER',p_Value => p_requester_number,p_parameterlist=>l_parameter_list_t);

Line 89: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE',p_Value => p_change_grade,p_parameterlist=>l_parameter_list_t);

85: wf_event.AddParameterToList ( p_Name => 'GRADING_SCHEMA',p_Value => p_grading_schema,p_parameterlist=>l_parameter_list_t);
86: wf_event.AddParameterToList ( p_Name => 'CURRENT_MARK',p_Value => p_current_mark,p_parameterlist=>l_parameter_list_t);
87: wf_event.AddParameterToList ( p_Name => 'CURRENT_GRADE',p_Value => p_current_grade,p_parameterlist=>l_parameter_list_t);
88: wf_event.AddParameterToList ( p_Name => 'CHANGE_MARK',p_Value => p_change_mark,p_parameterlist=>l_parameter_list_t);
89: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE',p_Value => p_change_grade,p_parameterlist=>l_parameter_list_t);
90: wf_event.AddParameterToList ( p_Name => 'REQUESTER_ID',p_Value => p_requester_id,p_parameterlist=>l_parameter_list_t);
91: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NAME',p_Value => p_requester_name,p_parameterlist=>l_parameter_list_t);
92: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NUMBER',p_Value => p_requester_number,p_parameterlist=>l_parameter_list_t);
93: wf_event.AddParameterToList ( p_Name => 'REQUEST_DATE',p_Value => p_request_date,p_parameterlist=>l_parameter_list_t);

Line 90: wf_event.AddParameterToList ( p_Name => 'REQUESTER_ID',p_Value => p_requester_id,p_parameterlist=>l_parameter_list_t);

86: wf_event.AddParameterToList ( p_Name => 'CURRENT_MARK',p_Value => p_current_mark,p_parameterlist=>l_parameter_list_t);
87: wf_event.AddParameterToList ( p_Name => 'CURRENT_GRADE',p_Value => p_current_grade,p_parameterlist=>l_parameter_list_t);
88: wf_event.AddParameterToList ( p_Name => 'CHANGE_MARK',p_Value => p_change_mark,p_parameterlist=>l_parameter_list_t);
89: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE',p_Value => p_change_grade,p_parameterlist=>l_parameter_list_t);
90: wf_event.AddParameterToList ( p_Name => 'REQUESTER_ID',p_Value => p_requester_id,p_parameterlist=>l_parameter_list_t);
91: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NAME',p_Value => p_requester_name,p_parameterlist=>l_parameter_list_t);
92: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NUMBER',p_Value => p_requester_number,p_parameterlist=>l_parameter_list_t);
93: wf_event.AddParameterToList ( p_Name => 'REQUEST_DATE',p_Value => p_request_date,p_parameterlist=>l_parameter_list_t);
94: wf_event.AddParameterToList ( p_Name => 'REQUESTER_COMMENTS',p_Value => p_requester_comments,p_parameterlist=>l_parameter_list_t);

Line 91: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NAME',p_Value => p_requester_name,p_parameterlist=>l_parameter_list_t);

87: wf_event.AddParameterToList ( p_Name => 'CURRENT_GRADE',p_Value => p_current_grade,p_parameterlist=>l_parameter_list_t);
88: wf_event.AddParameterToList ( p_Name => 'CHANGE_MARK',p_Value => p_change_mark,p_parameterlist=>l_parameter_list_t);
89: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE',p_Value => p_change_grade,p_parameterlist=>l_parameter_list_t);
90: wf_event.AddParameterToList ( p_Name => 'REQUESTER_ID',p_Value => p_requester_id,p_parameterlist=>l_parameter_list_t);
91: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NAME',p_Value => p_requester_name,p_parameterlist=>l_parameter_list_t);
92: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NUMBER',p_Value => p_requester_number,p_parameterlist=>l_parameter_list_t);
93: wf_event.AddParameterToList ( p_Name => 'REQUEST_DATE',p_Value => p_request_date,p_parameterlist=>l_parameter_list_t);
94: wf_event.AddParameterToList ( p_Name => 'REQUESTER_COMMENTS',p_Value => p_requester_comments,p_parameterlist=>l_parameter_list_t);
95: wf_event.AddParameterToList ( p_Name => 'TEACH_CAL_TYPE',p_Value => p_teach_cal_type,p_parameterlist=>l_parameter_list_t);

Line 92: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NUMBER',p_Value => p_requester_number,p_parameterlist=>l_parameter_list_t);

88: wf_event.AddParameterToList ( p_Name => 'CHANGE_MARK',p_Value => p_change_mark,p_parameterlist=>l_parameter_list_t);
89: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE',p_Value => p_change_grade,p_parameterlist=>l_parameter_list_t);
90: wf_event.AddParameterToList ( p_Name => 'REQUESTER_ID',p_Value => p_requester_id,p_parameterlist=>l_parameter_list_t);
91: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NAME',p_Value => p_requester_name,p_parameterlist=>l_parameter_list_t);
92: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NUMBER',p_Value => p_requester_number,p_parameterlist=>l_parameter_list_t);
93: wf_event.AddParameterToList ( p_Name => 'REQUEST_DATE',p_Value => p_request_date,p_parameterlist=>l_parameter_list_t);
94: wf_event.AddParameterToList ( p_Name => 'REQUESTER_COMMENTS',p_Value => p_requester_comments,p_parameterlist=>l_parameter_list_t);
95: wf_event.AddParameterToList ( p_Name => 'TEACH_CAL_TYPE',p_Value => p_teach_cal_type,p_parameterlist=>l_parameter_list_t);
96: wf_event.AddParameterToList ( p_Name => 'TEACH_CI_SEQUENCE_NUMBER',p_Value => p_teach_ci_seq_num,p_parameterlist=>l_parameter_list_t);

Line 93: wf_event.AddParameterToList ( p_Name => 'REQUEST_DATE',p_Value => p_request_date,p_parameterlist=>l_parameter_list_t);

89: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE',p_Value => p_change_grade,p_parameterlist=>l_parameter_list_t);
90: wf_event.AddParameterToList ( p_Name => 'REQUESTER_ID',p_Value => p_requester_id,p_parameterlist=>l_parameter_list_t);
91: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NAME',p_Value => p_requester_name,p_parameterlist=>l_parameter_list_t);
92: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NUMBER',p_Value => p_requester_number,p_parameterlist=>l_parameter_list_t);
93: wf_event.AddParameterToList ( p_Name => 'REQUEST_DATE',p_Value => p_request_date,p_parameterlist=>l_parameter_list_t);
94: wf_event.AddParameterToList ( p_Name => 'REQUESTER_COMMENTS',p_Value => p_requester_comments,p_parameterlist=>l_parameter_list_t);
95: wf_event.AddParameterToList ( p_Name => 'TEACH_CAL_TYPE',p_Value => p_teach_cal_type,p_parameterlist=>l_parameter_list_t);
96: wf_event.AddParameterToList ( p_Name => 'TEACH_CI_SEQUENCE_NUMBER',p_Value => p_teach_ci_seq_num,p_parameterlist=>l_parameter_list_t);
97: wf_event.AddParameterToList ( p_Name => 'LOAD_CAL_TYPE',p_Value => p_load_cal_type,p_parameterlist=>l_parameter_list_t);

Line 94: wf_event.AddParameterToList ( p_Name => 'REQUESTER_COMMENTS',p_Value => p_requester_comments,p_parameterlist=>l_parameter_list_t);

90: wf_event.AddParameterToList ( p_Name => 'REQUESTER_ID',p_Value => p_requester_id,p_parameterlist=>l_parameter_list_t);
91: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NAME',p_Value => p_requester_name,p_parameterlist=>l_parameter_list_t);
92: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NUMBER',p_Value => p_requester_number,p_parameterlist=>l_parameter_list_t);
93: wf_event.AddParameterToList ( p_Name => 'REQUEST_DATE',p_Value => p_request_date,p_parameterlist=>l_parameter_list_t);
94: wf_event.AddParameterToList ( p_Name => 'REQUESTER_COMMENTS',p_Value => p_requester_comments,p_parameterlist=>l_parameter_list_t);
95: wf_event.AddParameterToList ( p_Name => 'TEACH_CAL_TYPE',p_Value => p_teach_cal_type,p_parameterlist=>l_parameter_list_t);
96: wf_event.AddParameterToList ( p_Name => 'TEACH_CI_SEQUENCE_NUMBER',p_Value => p_teach_ci_seq_num,p_parameterlist=>l_parameter_list_t);
97: wf_event.AddParameterToList ( p_Name => 'LOAD_CAL_TYPE',p_Value => p_load_cal_type,p_parameterlist=>l_parameter_list_t);
98: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER',p_Value => p_load_seq_num,p_parameterlist=>l_parameter_list_t);

Line 95: wf_event.AddParameterToList ( p_Name => 'TEACH_CAL_TYPE',p_Value => p_teach_cal_type,p_parameterlist=>l_parameter_list_t);

91: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NAME',p_Value => p_requester_name,p_parameterlist=>l_parameter_list_t);
92: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NUMBER',p_Value => p_requester_number,p_parameterlist=>l_parameter_list_t);
93: wf_event.AddParameterToList ( p_Name => 'REQUEST_DATE',p_Value => p_request_date,p_parameterlist=>l_parameter_list_t);
94: wf_event.AddParameterToList ( p_Name => 'REQUESTER_COMMENTS',p_Value => p_requester_comments,p_parameterlist=>l_parameter_list_t);
95: wf_event.AddParameterToList ( p_Name => 'TEACH_CAL_TYPE',p_Value => p_teach_cal_type,p_parameterlist=>l_parameter_list_t);
96: wf_event.AddParameterToList ( p_Name => 'TEACH_CI_SEQUENCE_NUMBER',p_Value => p_teach_ci_seq_num,p_parameterlist=>l_parameter_list_t);
97: wf_event.AddParameterToList ( p_Name => 'LOAD_CAL_TYPE',p_Value => p_load_cal_type,p_parameterlist=>l_parameter_list_t);
98: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER',p_Value => p_load_seq_num,p_parameterlist=>l_parameter_list_t);
99: wf_event.AddParameterToList ( p_Name => 'CI_START_DT',p_Value => p_start_dt,p_parameterlist=>l_parameter_list_t );

Line 96: wf_event.AddParameterToList ( p_Name => 'TEACH_CI_SEQUENCE_NUMBER',p_Value => p_teach_ci_seq_num,p_parameterlist=>l_parameter_list_t);

92: wf_event.AddParameterToList ( p_Name => 'REQUESTER_NUMBER',p_Value => p_requester_number,p_parameterlist=>l_parameter_list_t);
93: wf_event.AddParameterToList ( p_Name => 'REQUEST_DATE',p_Value => p_request_date,p_parameterlist=>l_parameter_list_t);
94: wf_event.AddParameterToList ( p_Name => 'REQUESTER_COMMENTS',p_Value => p_requester_comments,p_parameterlist=>l_parameter_list_t);
95: wf_event.AddParameterToList ( p_Name => 'TEACH_CAL_TYPE',p_Value => p_teach_cal_type,p_parameterlist=>l_parameter_list_t);
96: wf_event.AddParameterToList ( p_Name => 'TEACH_CI_SEQUENCE_NUMBER',p_Value => p_teach_ci_seq_num,p_parameterlist=>l_parameter_list_t);
97: wf_event.AddParameterToList ( p_Name => 'LOAD_CAL_TYPE',p_Value => p_load_cal_type,p_parameterlist=>l_parameter_list_t);
98: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER',p_Value => p_load_seq_num,p_parameterlist=>l_parameter_list_t);
99: wf_event.AddParameterToList ( p_Name => 'CI_START_DT',p_Value => p_start_dt,p_parameterlist=>l_parameter_list_t );
100: wf_event.AddParameterToList ( p_Name => 'CI_END_DT',p_Value => p_end_dt,p_parameterlist=>l_parameter_list_t );

Line 97: wf_event.AddParameterToList ( p_Name => 'LOAD_CAL_TYPE',p_Value => p_load_cal_type,p_parameterlist=>l_parameter_list_t);

93: wf_event.AddParameterToList ( p_Name => 'REQUEST_DATE',p_Value => p_request_date,p_parameterlist=>l_parameter_list_t);
94: wf_event.AddParameterToList ( p_Name => 'REQUESTER_COMMENTS',p_Value => p_requester_comments,p_parameterlist=>l_parameter_list_t);
95: wf_event.AddParameterToList ( p_Name => 'TEACH_CAL_TYPE',p_Value => p_teach_cal_type,p_parameterlist=>l_parameter_list_t);
96: wf_event.AddParameterToList ( p_Name => 'TEACH_CI_SEQUENCE_NUMBER',p_Value => p_teach_ci_seq_num,p_parameterlist=>l_parameter_list_t);
97: wf_event.AddParameterToList ( p_Name => 'LOAD_CAL_TYPE',p_Value => p_load_cal_type,p_parameterlist=>l_parameter_list_t);
98: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER',p_Value => p_load_seq_num,p_parameterlist=>l_parameter_list_t);
99: wf_event.AddParameterToList ( p_Name => 'CI_START_DT',p_Value => p_start_dt,p_parameterlist=>l_parameter_list_t );
100: wf_event.AddParameterToList ( p_Name => 'CI_END_DT',p_Value => p_end_dt,p_parameterlist=>l_parameter_list_t );
101: wf_event.AddParameterToList ( p_Name => 'UOO_ID',p_Value => p_uoo_id,p_parameterlist=>l_parameter_list_t);

Line 98: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER',p_Value => p_load_seq_num,p_parameterlist=>l_parameter_list_t);

94: wf_event.AddParameterToList ( p_Name => 'REQUESTER_COMMENTS',p_Value => p_requester_comments,p_parameterlist=>l_parameter_list_t);
95: wf_event.AddParameterToList ( p_Name => 'TEACH_CAL_TYPE',p_Value => p_teach_cal_type,p_parameterlist=>l_parameter_list_t);
96: wf_event.AddParameterToList ( p_Name => 'TEACH_CI_SEQUENCE_NUMBER',p_Value => p_teach_ci_seq_num,p_parameterlist=>l_parameter_list_t);
97: wf_event.AddParameterToList ( p_Name => 'LOAD_CAL_TYPE',p_Value => p_load_cal_type,p_parameterlist=>l_parameter_list_t);
98: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER',p_Value => p_load_seq_num,p_parameterlist=>l_parameter_list_t);
99: wf_event.AddParameterToList ( p_Name => 'CI_START_DT',p_Value => p_start_dt,p_parameterlist=>l_parameter_list_t );
100: wf_event.AddParameterToList ( p_Name => 'CI_END_DT',p_Value => p_end_dt,p_parameterlist=>l_parameter_list_t );
101: wf_event.AddParameterToList ( p_Name => 'UOO_ID',p_Value => p_uoo_id,p_parameterlist=>l_parameter_list_t);
102: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE_VERSION_NUM',p_Value => p_grade_ver_num,p_parameterlist=>l_parameter_list_t);

Line 99: wf_event.AddParameterToList ( p_Name => 'CI_START_DT',p_Value => p_start_dt,p_parameterlist=>l_parameter_list_t );

95: wf_event.AddParameterToList ( p_Name => 'TEACH_CAL_TYPE',p_Value => p_teach_cal_type,p_parameterlist=>l_parameter_list_t);
96: wf_event.AddParameterToList ( p_Name => 'TEACH_CI_SEQUENCE_NUMBER',p_Value => p_teach_ci_seq_num,p_parameterlist=>l_parameter_list_t);
97: wf_event.AddParameterToList ( p_Name => 'LOAD_CAL_TYPE',p_Value => p_load_cal_type,p_parameterlist=>l_parameter_list_t);
98: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER',p_Value => p_load_seq_num,p_parameterlist=>l_parameter_list_t);
99: wf_event.AddParameterToList ( p_Name => 'CI_START_DT',p_Value => p_start_dt,p_parameterlist=>l_parameter_list_t );
100: wf_event.AddParameterToList ( p_Name => 'CI_END_DT',p_Value => p_end_dt,p_parameterlist=>l_parameter_list_t );
101: wf_event.AddParameterToList ( p_Name => 'UOO_ID',p_Value => p_uoo_id,p_parameterlist=>l_parameter_list_t);
102: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE_VERSION_NUM',p_Value => p_grade_ver_num,p_parameterlist=>l_parameter_list_t);
103: wf_event.AddParameterToList ( p_Name => 'GRADING_PERIOD_CD',p_Value => p_grading_period_cd,p_parameterlist=>l_parameter_list_t);

Line 100: wf_event.AddParameterToList ( p_Name => 'CI_END_DT',p_Value => p_end_dt,p_parameterlist=>l_parameter_list_t );

96: wf_event.AddParameterToList ( p_Name => 'TEACH_CI_SEQUENCE_NUMBER',p_Value => p_teach_ci_seq_num,p_parameterlist=>l_parameter_list_t);
97: wf_event.AddParameterToList ( p_Name => 'LOAD_CAL_TYPE',p_Value => p_load_cal_type,p_parameterlist=>l_parameter_list_t);
98: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER',p_Value => p_load_seq_num,p_parameterlist=>l_parameter_list_t);
99: wf_event.AddParameterToList ( p_Name => 'CI_START_DT',p_Value => p_start_dt,p_parameterlist=>l_parameter_list_t );
100: wf_event.AddParameterToList ( p_Name => 'CI_END_DT',p_Value => p_end_dt,p_parameterlist=>l_parameter_list_t );
101: wf_event.AddParameterToList ( p_Name => 'UOO_ID',p_Value => p_uoo_id,p_parameterlist=>l_parameter_list_t);
102: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE_VERSION_NUM',p_Value => p_grade_ver_num,p_parameterlist=>l_parameter_list_t);
103: wf_event.AddParameterToList ( p_Name => 'GRADING_PERIOD_CD',p_Value => p_grading_period_cd,p_parameterlist=>l_parameter_list_t);
104: --

Line 101: wf_event.AddParameterToList ( p_Name => 'UOO_ID',p_Value => p_uoo_id,p_parameterlist=>l_parameter_list_t);

97: wf_event.AddParameterToList ( p_Name => 'LOAD_CAL_TYPE',p_Value => p_load_cal_type,p_parameterlist=>l_parameter_list_t);
98: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER',p_Value => p_load_seq_num,p_parameterlist=>l_parameter_list_t);
99: wf_event.AddParameterToList ( p_Name => 'CI_START_DT',p_Value => p_start_dt,p_parameterlist=>l_parameter_list_t );
100: wf_event.AddParameterToList ( p_Name => 'CI_END_DT',p_Value => p_end_dt,p_parameterlist=>l_parameter_list_t );
101: wf_event.AddParameterToList ( p_Name => 'UOO_ID',p_Value => p_uoo_id,p_parameterlist=>l_parameter_list_t);
102: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE_VERSION_NUM',p_Value => p_grade_ver_num,p_parameterlist=>l_parameter_list_t);
103: wf_event.AddParameterToList ( p_Name => 'GRADING_PERIOD_CD',p_Value => p_grading_period_cd,p_parameterlist=>l_parameter_list_t);
104: --
105: -- raise the event

Line 102: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE_VERSION_NUM',p_Value => p_grade_ver_num,p_parameterlist=>l_parameter_list_t);

98: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER',p_Value => p_load_seq_num,p_parameterlist=>l_parameter_list_t);
99: wf_event.AddParameterToList ( p_Name => 'CI_START_DT',p_Value => p_start_dt,p_parameterlist=>l_parameter_list_t );
100: wf_event.AddParameterToList ( p_Name => 'CI_END_DT',p_Value => p_end_dt,p_parameterlist=>l_parameter_list_t );
101: wf_event.AddParameterToList ( p_Name => 'UOO_ID',p_Value => p_uoo_id,p_parameterlist=>l_parameter_list_t);
102: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE_VERSION_NUM',p_Value => p_grade_ver_num,p_parameterlist=>l_parameter_list_t);
103: wf_event.AddParameterToList ( p_Name => 'GRADING_PERIOD_CD',p_Value => p_grading_period_cd,p_parameterlist=>l_parameter_list_t);
104: --
105: -- raise the event
106: --

Line 103: wf_event.AddParameterToList ( p_Name => 'GRADING_PERIOD_CD',p_Value => p_grading_period_cd,p_parameterlist=>l_parameter_list_t);

99: wf_event.AddParameterToList ( p_Name => 'CI_START_DT',p_Value => p_start_dt,p_parameterlist=>l_parameter_list_t );
100: wf_event.AddParameterToList ( p_Name => 'CI_END_DT',p_Value => p_end_dt,p_parameterlist=>l_parameter_list_t );
101: wf_event.AddParameterToList ( p_Name => 'UOO_ID',p_Value => p_uoo_id,p_parameterlist=>l_parameter_list_t);
102: wf_event.AddParameterToList ( p_Name => 'CHANGE_GRADE_VERSION_NUM',p_Value => p_grade_ver_num,p_parameterlist=>l_parameter_list_t);
103: wf_event.AddParameterToList ( p_Name => 'GRADING_PERIOD_CD',p_Value => p_grading_period_cd,p_parameterlist=>l_parameter_list_t);
104: --
105: -- raise the event
106: --
107: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.infadmcg',

Line 107: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.infadmcg',

103: wf_event.AddParameterToList ( p_Name => 'GRADING_PERIOD_CD',p_Value => p_grading_period_cd,p_parameterlist=>l_parameter_list_t);
104: --
105: -- raise the event
106: --
107: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.as.infadmcg',
108: p_event_key => l_itemKey,
109: p_parameters => l_parameter_list_t);
110:
111:

Line 129: l_event_t wf_event_t;

125: p_requestor_id IN VARCHAR2 /* Added by aiyer for the bug 2403814 */
126: )
127: IS
128:
129: l_event_t wf_event_t;
130: l_parameter_list_t wf_parameter_list_t;
131: l_itemKey varchar2(100);
132:
133: CURSOR cur_seq1 IS

Line 140: -- initialize the wf_event_t object

136:
137: BEGIN
138:
139: --
140: -- initialize the wf_event_t object
141: --
142: wf_event_t.Initialize(l_event_t);
143: --
144: -- set the event name

Line 142: wf_event_t.Initialize(l_event_t);

138:
139: --
140: -- initialize the wf_event_t object
141: --
142: wf_event_t.Initialize(l_event_t);
143: --
144: -- set the event name
145: --
146: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmgrd');

Line 146: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmgrd');

142: wf_event_t.Initialize(l_event_t);
143: --
144: -- set the event name
145: --
146: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmgrd');
147: --
148: -- set the event key but before the select a number from sequence
149: --
150:

Line 158: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmgrd'||l_key );

154: CLOSE cur_seq1;
155:
156:
157:
158: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmgrd'||l_key );
159: --
160: -- set the parameter list
161: --
162: -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );

Line 163: -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );

159: --
160: -- set the parameter list
161: --
162: -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );
163: -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );
164: --
165: -- now add the parameters to the parameter list
166: --
167:

Line 168: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);

164: --
165: -- now add the parameters to the parameter list
166: --
167:
168: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
169: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
170: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
171: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
172: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);

Line 169: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);

165: -- now add the parameters to the parameter list
166: --
167:
168: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
169: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
170: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
171: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
172: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
173: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);

Line 170: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);

166: --
167:
168: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
169: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
170: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
171: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
172: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
173: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
174: /* This has been added by aiyer for the bug 2430814 . Set the FROM_USER_ID parameter attribute in the Grade Submission Workflow */

Line 171: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);

167:
168: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
169: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
170: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
171: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
172: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
173: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
174: /* This has been added by aiyer for the bug 2430814 . Set the FROM_USER_ID parameter attribute in the Grade Submission Workflow */
175: wf_event.AddParameterToList ( p_Name => 'FROM_USER_ID', p_Value => p_requestor_id, p_ParameterList => l_parameter_list_t);

Line 172: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);

168: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
169: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
170: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
171: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
172: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
173: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
174: /* This has been added by aiyer for the bug 2430814 . Set the FROM_USER_ID parameter attribute in the Grade Submission Workflow */
175: wf_event.AddParameterToList ( p_Name => 'FROM_USER_ID', p_Value => p_requestor_id, p_ParameterList => l_parameter_list_t);
176: --

Line 173: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);

169: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
170: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
171: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
172: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
173: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
174: /* This has been added by aiyer for the bug 2430814 . Set the FROM_USER_ID parameter attribute in the Grade Submission Workflow */
175: wf_event.AddParameterToList ( p_Name => 'FROM_USER_ID', p_Value => p_requestor_id, p_ParameterList => l_parameter_list_t);
176: --
177: -- raise the event

Line 175: wf_event.AddParameterToList ( p_Name => 'FROM_USER_ID', p_Value => p_requestor_id, p_ParameterList => l_parameter_list_t);

171: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
172: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
173: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
174: /* This has been added by aiyer for the bug 2430814 . Set the FROM_USER_ID parameter attribute in the Grade Submission Workflow */
175: wf_event.AddParameterToList ( p_Name => 'FROM_USER_ID', p_Value => p_requestor_id, p_ParameterList => l_parameter_list_t);
176: --
177: -- raise the event
178: --
179: WF_EVENT.RAISE (p_event_name =>

Line 179: WF_EVENT.RAISE (p_event_name =>

175: wf_event.AddParameterToList ( p_Name => 'FROM_USER_ID', p_Value => p_requestor_id, p_ParameterList => l_parameter_list_t);
176: --
177: -- raise the event
178: --
179: WF_EVENT.RAISE (p_event_name =>
180: 'oracle.apps.igs.as.infadmgrd',
181: p_event_key => l_itemKey,
182: p_parameters => l_parameter_list_t);
183:

Line 202: l_event_t wf_event_t;

198: p_submission_date IN DATE
199: )
200: IS
201:
202: l_event_t wf_event_t;
203: l_parameter_list_t wf_parameter_list_t;
204: l_itemKey varchar2(100);
205:
206: CURSOR cur_seq3 IS

Line 212: -- initialize the wf_event_t object

208: FROM dual;
209: BEGIN
210:
211: --
212: -- initialize the wf_event_t object
213: --
214: wf_event_t.Initialize(l_event_t);
215: --
216: -- set the event name

Line 214: wf_event_t.Initialize(l_event_t);

210:
211: --
212: -- initialize the wf_event_t object
213: --
214: wf_event_t.Initialize(l_event_t);
215: --
216: -- set the event name
217: --
218: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmgrdmt');

Line 218: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmgrdmt');

214: wf_event_t.Initialize(l_event_t);
215: --
216: -- set the event name
217: --
218: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmgrdmt');
219: --
220: -- set the event key but before the select a number from sequence
221: --
222:

Line 227: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmgrdmt'||l_key );

223: OPEN cur_seq3;
224: FETCH cur_seq3 INTO l_itemKey ;
225: CLOSE cur_seq3;
226:
227: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmgrdmt'||l_key );
228: --
229: -- set the parameter list
230: --
231: -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );

Line 232: -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );

228: --
229: -- set the parameter list
230: --
231: -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );
232: -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );
233: --
234: -- now add the parameters to the parameter list
235: --
236:

Line 237: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);

233: --
234: -- now add the parameters to the parameter list
235: --
236:
237: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
238: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);

Line 238: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);

234: -- now add the parameters to the parameter list
235: --
236:
237: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
238: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
242: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);

Line 239: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);

235: --
236:
237: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
238: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
242: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
243:

Line 240: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);

236:
237: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
238: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
242: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
243:
244: --

Line 241: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);

237: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
238: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
242: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
243:
244: --
245: -- raise the event

Line 242: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);

238: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
242: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
243:
244: --
245: -- raise the event
246: --

Line 247: WF_EVENT.RAISE (p_event_name =>

243:
244: --
245: -- raise the event
246: --
247: WF_EVENT.RAISE (p_event_name =>
248: 'oracle.apps.igs.as.infadmgrdmt',
249: p_event_key => l_itemKey,
250: p_parameters => l_parameter_list_t);
251:

Line 271: l_event_t wf_event_t;

267: p_submission_date IN DATE
268: )
269: IS
270:
271: l_event_t wf_event_t;
272: l_parameter_list_t wf_parameter_list_t;
273: l_itemKey varchar2(100);
274:
275: CURSOR cur_seq4 IS

Line 281: -- initialize the wf_event_t object

277: FROM dual;
278: BEGIN
279:
280: --
281: -- initialize the wf_event_t object
282: --
283: wf_event_t.Initialize(l_event_t);
284: --
285: -- set the event name

Line 283: wf_event_t.Initialize(l_event_t);

279:
280: --
281: -- initialize the wf_event_t object
282: --
283: wf_event_t.Initialize(l_event_t);
284: --
285: -- set the event name
286: --
287: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmattd');

Line 287: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmattd');

283: wf_event_t.Initialize(l_event_t);
284: --
285: -- set the event name
286: --
287: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmattd');
288: --
289: -- set the event key but before the select a number from sequence
290: --
291:

Line 298: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmattd'||l_key );

294: FETCH cur_seq4 INTO l_itemKey ;
295: CLOSE cur_seq4;
296:
297:
298: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmattd'||l_key );
299: --
300: -- set the parameter list
301: --
302: -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );

Line 303: -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );

299: --
300: -- set the parameter list
301: --
302: -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );
303: -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );
304: --
305: -- now add the parameters to the parameter list
306: --
307:

Line 308: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);

304: --
305: -- now add the parameters to the parameter list
306: --
307:
308: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
309: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);

Line 309: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);

305: -- now add the parameters to the parameter list
306: --
307:
308: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
309: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
313: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);

Line 310: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);

306: --
307:
308: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
309: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
313: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
314:

Line 311: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);

307:
308: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
309: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
313: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
314:
315: --

Line 312: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);

308: wf_event.AddParameterToList (p_name=>'UOO_ID',p_value=>p_uoo_id,p_parameterlist=>l_parameter_list_t);
309: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
313: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
314:
315: --
316: -- raise the event

Line 313: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);

309: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd, p_ParameterList => l_parameter_list_t);
310: wf_event.AddParameterToList ( p_Name => 'UNIT_SECTION', p_Value => p_unit_class, p_ParameterList => l_parameter_list_t);
311: wf_event.AddParameterToList ( p_Name => 'UNIT_TITLE', p_Value => p_title, p_ParameterList => l_parameter_list_t);
312: wf_event.AddParameterToList ( p_Name => 'INSTRUCTOR', p_Value => p_instructor, p_ParameterList => l_parameter_list_t);
313: wf_event.AddParameterToList ( p_Name => 'SUBMISSION_DATE', p_Value => p_submission_date, p_ParameterList => l_parameter_list_t);
314:
315: --
316: -- raise the event
317: --

Line 318: WF_EVENT.RAISE (p_event_name =>

314:
315: --
316: -- raise the event
317: --
318: WF_EVENT.RAISE (p_event_name =>
319: 'oracle.apps.igs.as.infadmattd',
320: p_event_key => l_itemKey,
321: p_parameters => l_parameter_list_t);
322:

Line 341: l_event_t wf_event_t;

337: p_old_grade IN igs_as_su_stmptout.grade%TYPE,
338: p_new_grade IN igs_as_su_stmptout.incomp_default_grade%TYPE
339: )
340: IS
341: l_event_t wf_event_t;
342: l_parameter_list_t wf_parameter_list_t;
343: l_itemKey varchar2(100);
344:
345: CURSOR cur_seq5 IS

Line 352: -- initialize the wf_event_t object

348:
349: BEGIN
350:
351: --
352: -- initialize the wf_event_t object
353: --
354: wf_event_t.Initialize(l_event_t);
355: --
356: -- set the event name

Line 354: wf_event_t.Initialize(l_event_t);

350:
351: --
352: -- initialize the wf_event_t object
353: --
354: wf_event_t.Initialize(l_event_t);
355: --
356: -- set the event name
357: --
358: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmincgrd');

Line 358: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmincgrd');

354: wf_event_t.Initialize(l_event_t);
355: --
356: -- set the event name
357: --
358: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmincgrd');
359: --
360: -- set the event key but before the select a number from sequence
361: --
362:

Line 368: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmincgrd'||l_key );

364: OPEN cur_seq5;
365: FETCH cur_seq5 INTO l_itemKey ;
366: CLOSE cur_seq5;
367:
368: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmincgrd'||l_key );
369: --
370: -- set the parameter list
371: --
372: -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );

Line 373: -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );

369: --
370: -- set the parameter list
371: --
372: -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );
373: -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );
374: --
375: -- now add the parameters to the parameter list
376: --
377:

Line 378: wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);

374: --
375: -- now add the parameters to the parameter list
376: --
377:
378: wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
379: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
380: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
382: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);

Line 379: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);

375: -- now add the parameters to the parameter list
376: --
377:
378: wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
379: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
380: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
382: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
383: wf_event.AddParameterToList ( p_Name => 'DATE_CHANGED', p_Value => p_date_changed,p_parameterlist=>l_parameter_list_t);

Line 380: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);

376: --
377:
378: wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
379: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
380: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
382: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
383: wf_event.AddParameterToList ( p_Name => 'DATE_CHANGED', p_Value => p_date_changed,p_parameterlist=>l_parameter_list_t);
384: wf_event.AddParameterToList ( p_Name => 'OLD_GRADE', p_Value => p_old_grade,p_parameterlist=>l_parameter_list_t);

Line 381: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);

377:
378: wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
379: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
380: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
382: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
383: wf_event.AddParameterToList ( p_Name => 'DATE_CHANGED', p_Value => p_date_changed,p_parameterlist=>l_parameter_list_t);
384: wf_event.AddParameterToList ( p_Name => 'OLD_GRADE', p_Value => p_old_grade,p_parameterlist=>l_parameter_list_t);
385: wf_event.AddParameterToList ( p_Name => 'NEW_GRADE', p_Value => p_new_grade,p_parameterlist=>l_parameter_list_t);

Line 382: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);

378: wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
379: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
380: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
382: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
383: wf_event.AddParameterToList ( p_Name => 'DATE_CHANGED', p_Value => p_date_changed,p_parameterlist=>l_parameter_list_t);
384: wf_event.AddParameterToList ( p_Name => 'OLD_GRADE', p_Value => p_old_grade,p_parameterlist=>l_parameter_list_t);
385: wf_event.AddParameterToList ( p_Name => 'NEW_GRADE', p_Value => p_new_grade,p_parameterlist=>l_parameter_list_t);
386: --

Line 383: wf_event.AddParameterToList ( p_Name => 'DATE_CHANGED', p_Value => p_date_changed,p_parameterlist=>l_parameter_list_t);

379: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
380: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
382: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
383: wf_event.AddParameterToList ( p_Name => 'DATE_CHANGED', p_Value => p_date_changed,p_parameterlist=>l_parameter_list_t);
384: wf_event.AddParameterToList ( p_Name => 'OLD_GRADE', p_Value => p_old_grade,p_parameterlist=>l_parameter_list_t);
385: wf_event.AddParameterToList ( p_Name => 'NEW_GRADE', p_Value => p_new_grade,p_parameterlist=>l_parameter_list_t);
386: --
387: -- raise the event

Line 384: wf_event.AddParameterToList ( p_Name => 'OLD_GRADE', p_Value => p_old_grade,p_parameterlist=>l_parameter_list_t);

380: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
381: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
382: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
383: wf_event.AddParameterToList ( p_Name => 'DATE_CHANGED', p_Value => p_date_changed,p_parameterlist=>l_parameter_list_t);
384: wf_event.AddParameterToList ( p_Name => 'OLD_GRADE', p_Value => p_old_grade,p_parameterlist=>l_parameter_list_t);
385: wf_event.AddParameterToList ( p_Name => 'NEW_GRADE', p_Value => p_new_grade,p_parameterlist=>l_parameter_list_t);
386: --
387: -- raise the event
388: --

Line 385: wf_event.AddParameterToList ( p_Name => 'NEW_GRADE', p_Value => p_new_grade,p_parameterlist=>l_parameter_list_t);

381: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
382: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
383: wf_event.AddParameterToList ( p_Name => 'DATE_CHANGED', p_Value => p_date_changed,p_parameterlist=>l_parameter_list_t);
384: wf_event.AddParameterToList ( p_Name => 'OLD_GRADE', p_Value => p_old_grade,p_parameterlist=>l_parameter_list_t);
385: wf_event.AddParameterToList ( p_Name => 'NEW_GRADE', p_Value => p_new_grade,p_parameterlist=>l_parameter_list_t);
386: --
387: -- raise the event
388: --
389: WF_EVENT.RAISE (p_event_name =>

Line 389: WF_EVENT.RAISE (p_event_name =>

385: wf_event.AddParameterToList ( p_Name => 'NEW_GRADE', p_Value => p_new_grade,p_parameterlist=>l_parameter_list_t);
386: --
387: -- raise the event
388: --
389: WF_EVENT.RAISE (p_event_name =>
390: 'oracle.apps.igs.as.infadmincgrd',
391: p_event_key => l_itemKey,
392: p_parameters => l_parameter_list_t);
393: END Wf_Inform_Admin_IncGrd;

Line 411: l_event_t wf_event_t;

407: p_incomp_default_mark IN igs_as_su_stmptout.incomp_default_mark%TYPE,
408: p_date_submitted IN DATE
409: )
410: IS
411: l_event_t wf_event_t;
412: l_parameter_list_t wf_parameter_list_t;
413: l_itemKey varchar2(100);
414:
415: CURSOR cur_seq2 IS

Line 421: -- initialize the wf_event_t object

417: FROM dual;
418:
419: BEGIN
420: --
421: -- initialize the wf_event_t object
422: --
423: wf_event_t.Initialize(l_event_t);
424: --
425: -- set the event name

Line 423: wf_event_t.Initialize(l_event_t);

419: BEGIN
420: --
421: -- initialize the wf_event_t object
422: --
423: wf_event_t.Initialize(l_event_t);
424: --
425: -- set the event name
426: --
427: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmincgrdsub');

Line 427: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmincgrdsub');

423: wf_event_t.Initialize(l_event_t);
424: --
425: -- set the event name
426: --
427: -- wf_event_t.setEventName( pEventName => 'oracle.apps.igs.as.infadmincgrdsub');
428: --
429: -- set the event key but before the select a number from sequence
430: --
431:

Line 437: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmincgrdsub'||l_key );

433: FETCH cur_seq2 INTO l_itemKey ;
434: CLOSE cur_seq2;
435:
436:
437: -- l_wf_event_t.setEventKey ( pEventKey => 'infadmincgrdsub'||l_key );
438: --
439: -- set the parameter list
440: --
441: -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );

Line 442: -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );

438: --
439: -- set the parameter list
440: --
441: -- l_event_t.setParameterList ( p_parameterlist => l_parameter_list_t );
442: -- wf_event_t.SetParameterList ( p_parameterlist => l_parameter_list_t );
443: --
444: -- now add the parameters to the parameter list
445: --
446:

Line 447: wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);

443: --
444: -- now add the parameters to the parameter list
445: --
446:
447: wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
448: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
449: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
450: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
451: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);

Line 448: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);

444: -- now add the parameters to the parameter list
445: --
446:
447: wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
448: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
449: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
450: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
451: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
452: wf_event.AddParameterToList ( p_Name => 'GRADE', p_Value => p_grade,p_parameterlist=>l_parameter_list_t);

Line 449: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);

445: --
446:
447: wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
448: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
449: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
450: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
451: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
452: wf_event.AddParameterToList ( p_Name => 'GRADE', p_Value => p_grade,p_parameterlist=>l_parameter_list_t);
453: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEADLINE_DATE', p_Value => p_incomp_deadline_dt,p_parameterlist=>l_parameter_list_t);

Line 450: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);

446:
447: wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
448: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
449: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
450: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
451: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
452: wf_event.AddParameterToList ( p_Name => 'GRADE', p_Value => p_grade,p_parameterlist=>l_parameter_list_t);
453: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEADLINE_DATE', p_Value => p_incomp_deadline_dt,p_parameterlist=>l_parameter_list_t);
454: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_GRADE', p_Value => p_incomp_default_grd,p_parameterlist=>l_parameter_list_t);

Line 451: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);

447: wf_event.AddParameterToList ( p_Name => 'PERSON_ID', p_Value => p_person_id,p_parameterlist=>l_parameter_list_t);
448: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
449: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
450: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
451: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
452: wf_event.AddParameterToList ( p_Name => 'GRADE', p_Value => p_grade,p_parameterlist=>l_parameter_list_t);
453: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEADLINE_DATE', p_Value => p_incomp_deadline_dt,p_parameterlist=>l_parameter_list_t);
454: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_GRADE', p_Value => p_incomp_default_grd,p_parameterlist=>l_parameter_list_t);
455: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_MARK', p_Value => p_incomp_default_mark,p_parameterlist=>l_parameter_list_t);

Line 452: wf_event.AddParameterToList ( p_Name => 'GRADE', p_Value => p_grade,p_parameterlist=>l_parameter_list_t);

448: wf_event.AddParameterToList ( p_Name => 'COURSE_CD', p_Value => p_course_cd,p_parameterlist=>l_parameter_list_t);
449: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
450: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
451: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
452: wf_event.AddParameterToList ( p_Name => 'GRADE', p_Value => p_grade,p_parameterlist=>l_parameter_list_t);
453: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEADLINE_DATE', p_Value => p_incomp_deadline_dt,p_parameterlist=>l_parameter_list_t);
454: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_GRADE', p_Value => p_incomp_default_grd,p_parameterlist=>l_parameter_list_t);
455: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_MARK', p_Value => p_incomp_default_mark,p_parameterlist=>l_parameter_list_t);
456: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMITTED', p_Value => p_date_submitted,p_parameterlist=>l_parameter_list_t);

Line 453: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEADLINE_DATE', p_Value => p_incomp_deadline_dt,p_parameterlist=>l_parameter_list_t);

449: wf_event.AddParameterToList ( p_Name => 'UNIT_CD', p_Value => p_unit_cd,p_parameterlist=>l_parameter_list_t);
450: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
451: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
452: wf_event.AddParameterToList ( p_Name => 'GRADE', p_Value => p_grade,p_parameterlist=>l_parameter_list_t);
453: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEADLINE_DATE', p_Value => p_incomp_deadline_dt,p_parameterlist=>l_parameter_list_t);
454: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_GRADE', p_Value => p_incomp_default_grd,p_parameterlist=>l_parameter_list_t);
455: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_MARK', p_Value => p_incomp_default_mark,p_parameterlist=>l_parameter_list_t);
456: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMITTED', p_Value => p_date_submitted,p_parameterlist=>l_parameter_list_t);
457: --

Line 454: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_GRADE', p_Value => p_incomp_default_grd,p_parameterlist=>l_parameter_list_t);

450: wf_event.AddParameterToList ( p_Name => 'CAL_TYPE', p_Value => p_cal_type,p_parameterlist=>l_parameter_list_t);
451: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
452: wf_event.AddParameterToList ( p_Name => 'GRADE', p_Value => p_grade,p_parameterlist=>l_parameter_list_t);
453: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEADLINE_DATE', p_Value => p_incomp_deadline_dt,p_parameterlist=>l_parameter_list_t);
454: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_GRADE', p_Value => p_incomp_default_grd,p_parameterlist=>l_parameter_list_t);
455: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_MARK', p_Value => p_incomp_default_mark,p_parameterlist=>l_parameter_list_t);
456: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMITTED', p_Value => p_date_submitted,p_parameterlist=>l_parameter_list_t);
457: --
458: -- raise the event

Line 455: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_MARK', p_Value => p_incomp_default_mark,p_parameterlist=>l_parameter_list_t);

451: wf_event.AddParameterToList ( p_Name => 'CI_SEQUENCE_NUMBER', p_Value => p_ci_seq_num,p_parameterlist=>l_parameter_list_t);
452: wf_event.AddParameterToList ( p_Name => 'GRADE', p_Value => p_grade,p_parameterlist=>l_parameter_list_t);
453: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEADLINE_DATE', p_Value => p_incomp_deadline_dt,p_parameterlist=>l_parameter_list_t);
454: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_GRADE', p_Value => p_incomp_default_grd,p_parameterlist=>l_parameter_list_t);
455: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_MARK', p_Value => p_incomp_default_mark,p_parameterlist=>l_parameter_list_t);
456: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMITTED', p_Value => p_date_submitted,p_parameterlist=>l_parameter_list_t);
457: --
458: -- raise the event
459: --

Line 456: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMITTED', p_Value => p_date_submitted,p_parameterlist=>l_parameter_list_t);

452: wf_event.AddParameterToList ( p_Name => 'GRADE', p_Value => p_grade,p_parameterlist=>l_parameter_list_t);
453: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEADLINE_DATE', p_Value => p_incomp_deadline_dt,p_parameterlist=>l_parameter_list_t);
454: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_GRADE', p_Value => p_incomp_default_grd,p_parameterlist=>l_parameter_list_t);
455: wf_event.AddParameterToList ( p_Name => 'INCOMP_DEFAULT_MARK', p_Value => p_incomp_default_mark,p_parameterlist=>l_parameter_list_t);
456: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMITTED', p_Value => p_date_submitted,p_parameterlist=>l_parameter_list_t);
457: --
458: -- raise the event
459: --
460: WF_EVENT.RAISE (p_event_name =>

Line 460: WF_EVENT.RAISE (p_event_name =>

456: wf_event.AddParameterToList ( p_Name => 'DATE_SUBMITTED', p_Value => p_date_submitted,p_parameterlist=>l_parameter_list_t);
457: --
458: -- raise the event
459: --
460: WF_EVENT.RAISE (p_event_name =>
461: 'oracle.apps.igs.as.infadmincgrdsub',
462: p_event_key => l_itemKey,
463: p_parameters => l_parameter_list_t);
464: END Wf_Inform_Admin_IncGrdSub;