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.IGF_SL_CL_ORIG_ACK dependencies on WF_EVENT

Line 5681: CURSOR c_wf_event_key IS

5677: --Who When What
5678: -- bvisvana 26-Sep-2005 Bug # 4141704 - IGF_SL_FED_APPL_FORM_CODE replaced with IGF_SL_CL_APP_FORM_CODE since
5679: -- IGF_SL_CL_APP_FORM_CODE has the complete set of lookup_code for Application Form Code
5680: ------------------------------------------------------------------
5681: CURSOR c_wf_event_key IS
5682: SELECT igf_sl_cl_scr_seq.NEXTVAL
5683: FROM DUAL;
5684:
5685: l_wf_event_t wf_event_t;

Line 5685: l_wf_event_t wf_event_t;

5681: CURSOR c_wf_event_key IS
5682: SELECT igf_sl_cl_scr_seq.NEXTVAL
5683: FROM DUAL;
5684:
5685: l_wf_event_t wf_event_t;
5686: l_wf_parameter_list_t wf_parameter_list_t;
5687: l_wf_event_name VARCHAR2(255);
5688: l_wf_event_key NUMBER;
5689: l_v_role fnd_user.user_name%TYPE;

Line 5687: l_wf_event_name VARCHAR2(255);

5683: FROM DUAL;
5684:
5685: l_wf_event_t wf_event_t;
5686: l_wf_parameter_list_t wf_parameter_list_t;
5687: l_wf_event_name VARCHAR2(255);
5688: l_wf_event_key NUMBER;
5689: l_v_role fnd_user.user_name%TYPE;
5690: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5691: BEGIN

Line 5688: l_wf_event_key NUMBER;

5684:
5685: l_wf_event_t wf_event_t;
5686: l_wf_parameter_list_t wf_parameter_list_t;
5687: l_wf_event_name VARCHAR2(255);
5688: l_wf_event_key NUMBER;
5689: l_v_role fnd_user.user_name%TYPE;
5690: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5691: BEGIN
5692: log_to_fnd(p_v_module => 'raise_scr_event',

Line 5699: p_v_string => 'Initializing the wf_event_t object'

5695: ' p_c_student_created : ' ||p_c_student_created ||
5696: ' p_c_rel_created : ' ||p_c_rel_created
5697: );
5698: log_to_fnd(p_v_module => 'raise_scr_event',
5699: p_v_string => 'Initializing the wf_event_t object'
5700: );
5701: l_rec_resp_r1 := p_rec_resp_r1;
5702:
5703: -- initialize the wf_event_t object

Line 5703: -- initialize the wf_event_t object

5699: p_v_string => 'Initializing the wf_event_t object'
5700: );
5701: l_rec_resp_r1 := p_rec_resp_r1;
5702:
5703: -- initialize the wf_event_t object
5704: wf_event_t.initialize(l_wf_event_t);
5705: l_wf_event_name := 'oracle.apps.igf.sl.loans.ffelp.LoanCertificationRequest';
5706: log_to_fnd(p_v_module => 'raise_scr_event',
5707: p_v_string => 'Setting the workflow event name '||l_wf_event_name

Line 5704: wf_event_t.initialize(l_wf_event_t);

5700: );
5701: l_rec_resp_r1 := p_rec_resp_r1;
5702:
5703: -- initialize the wf_event_t object
5704: wf_event_t.initialize(l_wf_event_t);
5705: l_wf_event_name := 'oracle.apps.igf.sl.loans.ffelp.LoanCertificationRequest';
5706: log_to_fnd(p_v_module => 'raise_scr_event',
5707: p_v_string => 'Setting the workflow event name '||l_wf_event_name
5708: );

Line 5705: l_wf_event_name := 'oracle.apps.igf.sl.loans.ffelp.LoanCertificationRequest';

5701: l_rec_resp_r1 := p_rec_resp_r1;
5702:
5703: -- initialize the wf_event_t object
5704: wf_event_t.initialize(l_wf_event_t);
5705: l_wf_event_name := 'oracle.apps.igf.sl.loans.ffelp.LoanCertificationRequest';
5706: log_to_fnd(p_v_module => 'raise_scr_event',
5707: p_v_string => 'Setting the workflow event name '||l_wf_event_name
5708: );
5709: -- set the event name

Line 5707: p_v_string => 'Setting the workflow event name '||l_wf_event_name

5703: -- initialize the wf_event_t object
5704: wf_event_t.initialize(l_wf_event_t);
5705: l_wf_event_name := 'oracle.apps.igf.sl.loans.ffelp.LoanCertificationRequest';
5706: log_to_fnd(p_v_module => 'raise_scr_event',
5707: p_v_string => 'Setting the workflow event name '||l_wf_event_name
5708: );
5709: -- set the event name
5710: l_wf_event_t.seteventname( peventname => l_wf_event_name);
5711:

Line 5710: l_wf_event_t.seteventname( peventname => l_wf_event_name);

5706: log_to_fnd(p_v_module => 'raise_scr_event',
5707: p_v_string => 'Setting the workflow event name '||l_wf_event_name
5708: );
5709: -- set the event name
5710: l_wf_event_t.seteventname( peventname => l_wf_event_name);
5711:
5712: log_to_fnd(p_v_module => 'raise_scr_event',
5713: p_v_string => 'Obtaining the workflow event key'
5714: );

Line 5715: OPEN c_wf_event_key;

5711:
5712: log_to_fnd(p_v_module => 'raise_scr_event',
5713: p_v_string => 'Obtaining the workflow event key'
5714: );
5715: OPEN c_wf_event_key;
5716: FETCH c_wf_event_key INTO l_wf_event_key;
5717: CLOSE c_wf_event_key ;
5718:
5719: log_to_fnd(p_v_module => 'raise_scr_event',

Line 5716: FETCH c_wf_event_key INTO l_wf_event_key;

5712: log_to_fnd(p_v_module => 'raise_scr_event',
5713: p_v_string => 'Obtaining the workflow event key'
5714: );
5715: OPEN c_wf_event_key;
5716: FETCH c_wf_event_key INTO l_wf_event_key;
5717: CLOSE c_wf_event_key ;
5718:
5719: log_to_fnd(p_v_module => 'raise_scr_event',
5720: p_v_string => 'The workflow event key '||l_wf_event_key

Line 5717: CLOSE c_wf_event_key ;

5713: p_v_string => 'Obtaining the workflow event key'
5714: );
5715: OPEN c_wf_event_key;
5716: FETCH c_wf_event_key INTO l_wf_event_key;
5717: CLOSE c_wf_event_key ;
5718:
5719: log_to_fnd(p_v_module => 'raise_scr_event',
5720: p_v_string => 'The workflow event key '||l_wf_event_key
5721: );

Line 5720: p_v_string => 'The workflow event key '||l_wf_event_key

5716: FETCH c_wf_event_key INTO l_wf_event_key;
5717: CLOSE c_wf_event_key ;
5718:
5719: log_to_fnd(p_v_module => 'raise_scr_event',
5720: p_v_string => 'The workflow event key '||l_wf_event_key
5721: );
5722: l_wf_event_t.setEventKey ( pEventKey => l_wf_event_name|| l_wf_event_key );
5723: -- set the parameter list
5724: log_to_fnd(p_v_module => 'raise_scr_event',

Line 5722: l_wf_event_t.setEventKey ( pEventKey => l_wf_event_name|| l_wf_event_key );

5718:
5719: log_to_fnd(p_v_module => 'raise_scr_event',
5720: p_v_string => 'The workflow event key '||l_wf_event_key
5721: );
5722: l_wf_event_t.setEventKey ( pEventKey => l_wf_event_name|| l_wf_event_key );
5723: -- set the parameter list
5724: log_to_fnd(p_v_module => 'raise_scr_event',
5725: p_v_string => 'setting the parameter list'
5726: );

Line 5727: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );

5723: -- set the parameter list
5724: log_to_fnd(p_v_module => 'raise_scr_event',
5725: p_v_string => 'setting the parameter list'
5726: );
5727: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
5728:
5729: -- Now add the parameters to the list to be passed to the workflow
5730: log_to_fnd(p_v_module => 'raise_scr_event',
5731: p_v_string => 'Adding the parameters to the list passed to the workflow'

Line 5744: wf_event.addparametertolist(

5740: log_to_fnd(p_v_module => 'raise_scr_event',
5741: p_v_string => 'After calling the fnd.profile.value(USERNAME)..The value of the USERNAME is '||l_v_role
5742: );
5743:
5744: wf_event.addparametertolist(
5745: p_name => 'USER_ID',
5746: p_value => l_v_role,
5747: p_parameterlist => l_wf_parameter_list_t
5748: );

Line 5749: wf_event.addparametertolist(

5745: p_name => 'USER_ID',
5746: p_value => l_v_role,
5747: p_parameterlist => l_wf_parameter_list_t
5748: );
5749: wf_event.addparametertolist(
5750: p_name => 'RELEASE_VERSION',
5751: p_value => g_v_cl_version,
5752: p_parameterlist => l_wf_parameter_list_t
5753: );

Line 5755: wf_event.addparametertolist(

5751: p_value => g_v_cl_version,
5752: p_parameterlist => l_wf_parameter_list_t
5753: );
5754:
5755: wf_event.addparametertolist(
5756: p_name => 'ATT_1',
5757: p_value => l_rec_resp_r1.b_last_name,
5758: p_parameterlist => l_wf_parameter_list_t
5759: );

Line 5761: wf_event.addparametertolist(

5757: p_value => l_rec_resp_r1.b_last_name,
5758: p_parameterlist => l_wf_parameter_list_t
5759: );
5760:
5761: wf_event.addparametertolist(
5762: p_name => 'ATT_2',
5763: p_value => l_rec_resp_r1.b_first_name,
5764: p_parameterlist => l_wf_parameter_list_t
5765: );

Line 5767: wf_event.addparametertolist(

5763: p_value => l_rec_resp_r1.b_first_name,
5764: p_parameterlist => l_wf_parameter_list_t
5765: );
5766:
5767: wf_event.addparametertolist(
5768: p_name => 'ATT_3',
5769: p_value => l_rec_resp_r1.b_middle_name,
5770: p_parameterlist => l_wf_parameter_list_t
5771: );

Line 5773: wf_event.addparametertolist(

5769: p_value => l_rec_resp_r1.b_middle_name,
5770: p_parameterlist => l_wf_parameter_list_t
5771: );
5772:
5773: wf_event.addparametertolist(
5774: p_name => 'ATT_4',
5775: p_value => l_rec_resp_r1.b_ssn,
5776: p_parameterlist => l_wf_parameter_list_t
5777: );

Line 5779: wf_event.addparametertolist(

5775: p_value => l_rec_resp_r1.b_ssn,
5776: p_parameterlist => l_wf_parameter_list_t
5777: );
5778:
5779: wf_event.addparametertolist(
5780: p_name => 'ATT_5',
5781: p_value => l_rec_resp_r1.b_permt_addr1,
5782: p_parameterlist => l_wf_parameter_list_t
5783: );

Line 5785: wf_event.addparametertolist(

5781: p_value => l_rec_resp_r1.b_permt_addr1,
5782: p_parameterlist => l_wf_parameter_list_t
5783: );
5784:
5785: wf_event.addparametertolist(
5786: p_name => 'ATT_6',
5787: p_value => l_rec_resp_r1.b_permt_addr2,
5788: p_parameterlist => l_wf_parameter_list_t
5789: );

Line 5791: wf_event.addparametertolist(

5787: p_value => l_rec_resp_r1.b_permt_addr2,
5788: p_parameterlist => l_wf_parameter_list_t
5789: );
5790:
5791: wf_event.addparametertolist(
5792: p_name => 'ATT_7',
5793: p_value => l_rec_resp_r1.b_permt_city,
5794: p_parameterlist => l_wf_parameter_list_t
5795: );

Line 5797: wf_event.addparametertolist(

5793: p_value => l_rec_resp_r1.b_permt_city,
5794: p_parameterlist => l_wf_parameter_list_t
5795: );
5796:
5797: wf_event.addparametertolist(
5798: p_name => 'ATT_8',
5799: p_value => l_rec_resp_r1.b_permt_state,
5800: p_parameterlist => l_wf_parameter_list_t
5801: );

Line 5803: wf_event.addparametertolist(

5799: p_value => l_rec_resp_r1.b_permt_state,
5800: p_parameterlist => l_wf_parameter_list_t
5801: );
5802:
5803: wf_event.addparametertolist(
5804: p_name => 'ATT_9',
5805: p_value => l_rec_resp_r1.b_permt_zip,
5806: p_parameterlist => l_wf_parameter_list_t
5807: );

Line 5809: wf_event.addparametertolist(

5805: p_value => l_rec_resp_r1.b_permt_zip,
5806: p_parameterlist => l_wf_parameter_list_t
5807: );
5808:
5809: wf_event.addparametertolist(
5810: p_name => 'ATT_10',
5811: p_value => l_rec_resp_r1.b_permt_zip_suffix,
5812: p_parameterlist => l_wf_parameter_list_t
5813: );

Line 5815: wf_event.addparametertolist(

5811: p_value => l_rec_resp_r1.b_permt_zip_suffix,
5812: p_parameterlist => l_wf_parameter_list_t
5813: );
5814:
5815: wf_event.addparametertolist(
5816: p_name => 'ATT_11',
5817: p_value => l_rec_resp_r1.b_permt_phone,
5818: p_parameterlist => l_wf_parameter_list_t
5819: );

Line 5821: wf_event.addparametertolist(

5817: p_value => l_rec_resp_r1.b_permt_phone,
5818: p_parameterlist => l_wf_parameter_list_t
5819: );
5820:
5821: wf_event.addparametertolist(
5822: p_name => 'ATT_12',
5823: p_value => l_rec_resp_r1.b_date_of_birth,
5824: p_parameterlist => l_wf_parameter_list_t
5825: );

Line 5827: wf_event.addparametertolist(

5823: p_value => l_rec_resp_r1.b_date_of_birth,
5824: p_parameterlist => l_wf_parameter_list_t
5825: );
5826:
5827: wf_event.addparametertolist(
5828: p_name => 'ATT_13',
5829: p_value => l_rec_resp_r1.cl_loan_type||' - ' || igf_aw_gen.lookup_desc('IGF_SL_CL_LOAN_TYPE',l_rec_resp_r1.cl_loan_type),
5830: p_parameterlist => l_wf_parameter_list_t
5831: );

Line 5833: wf_event.addparametertolist(

5829: p_value => l_rec_resp_r1.cl_loan_type||' - ' || igf_aw_gen.lookup_desc('IGF_SL_CL_LOAN_TYPE',l_rec_resp_r1.cl_loan_type),
5830: p_parameterlist => l_wf_parameter_list_t
5831: );
5832:
5833: wf_event.addparametertolist(
5834: p_name => 'ATT_14',
5835: p_value => l_rec_resp_r1.req_loan_amt,
5836: p_parameterlist => l_wf_parameter_list_t
5837: );

Line 5839: wf_event.addparametertolist(

5835: p_value => l_rec_resp_r1.req_loan_amt,
5836: p_parameterlist => l_wf_parameter_list_t
5837: );
5838:
5839: wf_event.addparametertolist(
5840: p_name => 'ATT_15',
5841: p_value => l_rec_resp_r1.defer_req_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CL_DEF_REQ_CODE',l_rec_resp_r1.defer_req_code),
5842: p_parameterlist => l_wf_parameter_list_t
5843: );

Line 5845: wf_event.addparametertolist(

5841: p_value => l_rec_resp_r1.defer_req_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CL_DEF_REQ_CODE',l_rec_resp_r1.defer_req_code),
5842: p_parameterlist => l_wf_parameter_list_t
5843: );
5844:
5845: wf_event.addparametertolist(
5846: p_name => 'ATT_16',
5847: p_value => l_rec_resp_r1.borw_interest_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_INT_IND',l_rec_resp_r1.borw_interest_ind),
5848: p_parameterlist => l_wf_parameter_list_t
5849: );

Line 5851: wf_event.addparametertolist(

5847: p_value => l_rec_resp_r1.borw_interest_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_INT_IND',l_rec_resp_r1.borw_interest_ind),
5848: p_parameterlist => l_wf_parameter_list_t
5849: );
5850:
5851: wf_event.addparametertolist(
5852: p_name => 'ATT_17',
5853: p_value => l_rec_resp_r1.eft_auth_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CL_EFT_AUTH_CODE',l_rec_resp_r1.eft_auth_code),
5854: p_parameterlist => l_wf_parameter_list_t
5855: );

Line 5857: wf_event.addparametertolist(

5853: p_value => l_rec_resp_r1.eft_auth_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CL_EFT_AUTH_CODE',l_rec_resp_r1.eft_auth_code),
5854: p_parameterlist => l_wf_parameter_list_t
5855: );
5856:
5857: wf_event.addparametertolist(
5858: p_name => 'ATT_18',
5859: p_value => l_rec_resp_r1.b_signature_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_SIGN_CODE',l_rec_resp_r1.b_signature_code),
5860: p_parameterlist => l_wf_parameter_list_t
5861: );

Line 5863: wf_event.addparametertolist(

5859: p_value => l_rec_resp_r1.b_signature_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_SIGN_CODE',l_rec_resp_r1.b_signature_code),
5860: p_parameterlist => l_wf_parameter_list_t
5861: );
5862:
5863: wf_event.addparametertolist(
5864: p_name => 'ATT_19',
5865: p_value => l_rec_resp_r1.b_signature_date,
5866: p_parameterlist => l_wf_parameter_list_t
5867: );

Line 5869: wf_event.addparametertolist(

5865: p_value => l_rec_resp_r1.b_signature_date,
5866: p_parameterlist => l_wf_parameter_list_t
5867: );
5868:
5869: wf_event.addparametertolist(
5870: p_name => 'ATT_20',
5871: p_value => l_rec_resp_r1.loan_number,
5872: p_parameterlist => l_wf_parameter_list_t
5873: );

Line 5877: wf_event.addparametertolist(

5873: );
5874:
5875: IF g_v_cl_version = 'RELEASE-5' THEN
5876:
5877: wf_event.addparametertolist(
5878: p_name => 'ATT_21',
5879: p_value => l_rec_resp_r1.borr_credit_auth_code,
5880: p_parameterlist => l_wf_parameter_list_t
5881: );

Line 5883: wf_event.addparametertolist(

5879: p_value => l_rec_resp_r1.borr_credit_auth_code,
5880: p_parameterlist => l_wf_parameter_list_t
5881: );
5882:
5883: wf_event.addparametertolist(
5884: p_name => 'ATT_22',
5885: p_value => l_rec_resp_r1.b_citizenship_status||' - '||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT', l_rec_resp_r1.b_citizenship_status),
5886: p_parameterlist => l_wf_parameter_list_t
5887: );

Line 5889: wf_event.addparametertolist(

5885: p_value => l_rec_resp_r1.b_citizenship_status||' - '||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT', l_rec_resp_r1.b_citizenship_status),
5886: p_parameterlist => l_wf_parameter_list_t
5887: );
5888:
5889: wf_event.addparametertolist(
5890: p_name => 'ATT_23',
5891: p_value => l_rec_resp_r1.b_state_of_legal_res||' - ' ||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_state_of_legal_res),
5892: p_parameterlist => l_wf_parameter_list_t
5893: );

Line 5894: wf_event.addparametertolist(

5890: p_name => 'ATT_23',
5891: p_value => l_rec_resp_r1.b_state_of_legal_res||' - ' ||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_state_of_legal_res),
5892: p_parameterlist => l_wf_parameter_list_t
5893: );
5894: wf_event.addparametertolist(
5895: p_name => 'ATT_24',
5896: p_value => l_rec_resp_r1.b_legal_res_date,
5897: p_parameterlist => l_wf_parameter_list_t
5898: );

Line 5900: wf_event.addparametertolist(

5896: p_value => l_rec_resp_r1.b_legal_res_date,
5897: p_parameterlist => l_wf_parameter_list_t
5898: );
5899:
5900: wf_event.addparametertolist(
5901: p_name => 'ATT_25',
5902: p_value => l_rec_resp_r1.b_default_status||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_P_DEFAULT_STATUS',l_rec_resp_r1.b_default_status),
5903: p_parameterlist => l_wf_parameter_list_t
5904: );

Line 5906: wf_event.addparametertolist(

5902: p_value => l_rec_resp_r1.b_default_status||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_P_DEFAULT_STATUS',l_rec_resp_r1.b_default_status),
5903: p_parameterlist => l_wf_parameter_list_t
5904: );
5905:
5906: wf_event.addparametertolist(
5907: p_name => 'ATT_26',
5908: p_value => l_rec_resp_r1.b_outstd_loan_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_outstd_loan_code),
5909: p_parameterlist => l_wf_parameter_list_t
5910: );

Line 5912: wf_event.addparametertolist(

5908: p_value => l_rec_resp_r1.b_outstd_loan_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_outstd_loan_code),
5909: p_parameterlist => l_wf_parameter_list_t
5910: );
5911:
5912: wf_event.addparametertolist(
5913: p_name => 'ATT_27',
5914: p_value => l_rec_resp_r1.b_indicator_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_indicator_code),
5915: p_parameterlist => l_wf_parameter_list_t
5916: );

Line 5918: wf_event.addparametertolist(

5914: p_value => l_rec_resp_r1.b_indicator_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_indicator_code),
5915: p_parameterlist => l_wf_parameter_list_t
5916: );
5917:
5918: wf_event.addparametertolist(
5919: p_name => 'ATT_28',
5920: p_value => l_rec_resp_r1.s_last_name,
5921: p_parameterlist => l_wf_parameter_list_t
5922: );

Line 5924: wf_event.addparametertolist(

5920: p_value => l_rec_resp_r1.s_last_name,
5921: p_parameterlist => l_wf_parameter_list_t
5922: );
5923:
5924: wf_event.addparametertolist(
5925: p_name => 'ATT_29',
5926: p_value => l_rec_resp_r1.s_first_name,
5927: p_parameterlist => l_wf_parameter_list_t
5928: );

Line 5930: wf_event.addparametertolist(

5926: p_value => l_rec_resp_r1.s_first_name,
5927: p_parameterlist => l_wf_parameter_list_t
5928: );
5929:
5930: wf_event.addparametertolist(
5931: p_name => 'ATT_30',
5932: p_value => l_rec_resp_r1.s_middle_name,
5933: p_parameterlist => l_wf_parameter_list_t
5934: );

Line 5936: wf_event.addparametertolist(

5932: p_value => l_rec_resp_r1.s_middle_name,
5933: p_parameterlist => l_wf_parameter_list_t
5934: );
5935:
5936: wf_event.addparametertolist(
5937: p_name => 'ATT_31',
5938: p_value => l_rec_resp_r1.s_ssn,
5939: p_parameterlist => l_wf_parameter_list_t
5940: );

Line 5942: wf_event.addparametertolist(

5938: p_value => l_rec_resp_r1.s_ssn,
5939: p_parameterlist => l_wf_parameter_list_t
5940: );
5941:
5942: wf_event.addparametertolist(
5943: p_name => 'ATT_32',
5944: p_value => l_rec_resp_r1.s_date_of_birth,
5945: p_parameterlist => l_wf_parameter_list_t
5946: );

Line 5948: wf_event.addparametertolist(

5944: p_value => l_rec_resp_r1.s_date_of_birth,
5945: p_parameterlist => l_wf_parameter_list_t
5946: );
5947:
5948: wf_event.addparametertolist(
5949: p_name => 'ATT_33',
5950: p_value => l_rec_resp_r1.s_citizenship_status||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT',l_rec_resp_r1.s_citizenship_status),
5951: p_parameterlist => l_wf_parameter_list_t
5952: );

Line 5954: wf_event.addparametertolist(

5950: p_value => l_rec_resp_r1.s_citizenship_status||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT',l_rec_resp_r1.s_citizenship_status),
5951: p_parameterlist => l_wf_parameter_list_t
5952: );
5953:
5954: wf_event.addparametertolist(
5955: p_name => 'ATT_34',
5956: p_value => l_rec_resp_r1.s_default_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_S_DEFAULT_STATUS',l_rec_resp_r1.s_default_code),
5957: p_parameterlist => l_wf_parameter_list_t
5958: );

Line 5960: wf_event.addparametertolist(

5956: p_value => l_rec_resp_r1.s_default_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_S_DEFAULT_STATUS',l_rec_resp_r1.s_default_code),
5957: p_parameterlist => l_wf_parameter_list_t
5958: );
5959:
5960: wf_event.addparametertolist(
5961: p_name => 'ATT_35',
5962: p_value => l_rec_resp_r1.s_signature_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_STUD_SIGN_CODE',l_rec_resp_r1.s_signature_code),
5963: p_parameterlist => l_wf_parameter_list_t
5964: );

Line 5966: wf_event.addparametertolist(

5962: p_value => l_rec_resp_r1.s_signature_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_STUD_SIGN_CODE',l_rec_resp_r1.s_signature_code),
5963: p_parameterlist => l_wf_parameter_list_t
5964: );
5965:
5966: wf_event.addparametertolist(
5967: p_name => 'ATT_36',
5968: p_value => l_rec_resp_r1.school_id,
5969: p_parameterlist => l_wf_parameter_list_t
5970: );

Line 5972: wf_event.addparametertolist(

5968: p_value => l_rec_resp_r1.school_id,
5969: p_parameterlist => l_wf_parameter_list_t
5970: );
5971:
5972: wf_event.addparametertolist(
5973: p_name => 'ATT_37',
5974: p_value => l_rec_resp_r1.loan_per_begin_date,
5975: p_parameterlist => l_wf_parameter_list_t
5976: );

Line 5978: wf_event.addparametertolist(

5974: p_value => l_rec_resp_r1.loan_per_begin_date,
5975: p_parameterlist => l_wf_parameter_list_t
5976: );
5977:
5978: wf_event.addparametertolist(
5979: p_name => 'ATT_38',
5980: p_value => l_rec_resp_r1.loan_per_end_date,
5981: p_parameterlist => l_wf_parameter_list_t
5982: );

Line 5983: wf_event.addparametertolist(

5979: p_name => 'ATT_38',
5980: p_value => l_rec_resp_r1.loan_per_end_date,
5981: p_parameterlist => l_wf_parameter_list_t
5982: );
5983: wf_event.addparametertolist(
5984: p_name => 'ATT_39',
5985: p_value => l_rec_resp_r1.borr_sign_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ELE_SIGN_IND',l_rec_resp_r1.borr_sign_ind),
5986: p_parameterlist => l_wf_parameter_list_t
5987: );

Line 5989: wf_event.addparametertolist(

5985: p_value => l_rec_resp_r1.borr_sign_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ELE_SIGN_IND',l_rec_resp_r1.borr_sign_ind),
5986: p_parameterlist => l_wf_parameter_list_t
5987: );
5988:
5989: wf_event.addparametertolist(
5990: p_name => 'ATT_40',
5991: p_value => l_rec_resp_r1.alt_appl_ver_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_ALT_LOAN_CODE',l_rec_resp_r1.alt_appl_ver_code) ,
5992: p_parameterlist => l_wf_parameter_list_t
5993: );

Line 5995: wf_event.addparametertolist(

5991: p_value => l_rec_resp_r1.alt_appl_ver_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_ALT_LOAN_CODE',l_rec_resp_r1.alt_appl_ver_code) ,
5992: p_parameterlist => l_wf_parameter_list_t
5993: );
5994:
5995: wf_event.addparametertolist(
5996: p_name => 'ATT_41',
5997: p_value => l_rec_resp_r1.lender_id,
5998: p_parameterlist => l_wf_parameter_list_t
5999: );

Line 6001: wf_event.addparametertolist(

5997: p_value => l_rec_resp_r1.lender_id,
5998: p_parameterlist => l_wf_parameter_list_t
5999: );
6000:
6001: wf_event.addparametertolist(
6002: p_name => 'ATT_42',
6003: p_value => l_rec_resp_r1.guarantor_id,
6004: p_parameterlist => l_wf_parameter_list_t
6005: );

Line 6007: wf_event.addparametertolist(

6003: p_value => l_rec_resp_r1.guarantor_id,
6004: p_parameterlist => l_wf_parameter_list_t
6005: );
6006: -- Bug # 4141704
6007: wf_event.addparametertolist(
6008: p_name => 'ATT_43',
6009: p_value => l_rec_resp_r1.fed_appl_form_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_APP_FORM_CODE',l_rec_resp_r1.fed_appl_form_code),
6010: p_parameterlist => l_wf_parameter_list_t
6011: );

Line 6013: wf_event.addparametertolist(

6009: p_value => l_rec_resp_r1.fed_appl_form_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_APP_FORM_CODE',l_rec_resp_r1.fed_appl_form_code),
6010: p_parameterlist => l_wf_parameter_list_t
6011: );
6012:
6013: wf_event.addparametertolist(
6014: p_name => 'ATT_44',
6015: p_value => l_rec_resp_r1.b_license_state||' - '||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_license_state),
6016: p_parameterlist => l_wf_parameter_list_t
6017: );

Line 6019: wf_event.addparametertolist(

6015: p_value => l_rec_resp_r1.b_license_state||' - '||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_license_state),
6016: p_parameterlist => l_wf_parameter_list_t
6017: );
6018:
6019: wf_event.addparametertolist(
6020: p_name => 'ATT_45',
6021: p_value => l_rec_resp_r1.b_license_number,
6022: p_parameterlist => l_wf_parameter_list_t
6023: );

Line 6025: wf_event.addparametertolist(

6021: p_value => l_rec_resp_r1.b_license_number,
6022: p_parameterlist => l_wf_parameter_list_t
6023: );
6024:
6025: wf_event.addparametertolist(
6026: p_name => 'ATT_46',
6027: p_value => l_rec_resp_r1.b_ref_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_REF_INF',l_rec_resp_r1.b_ref_code),
6028: p_parameterlist => l_wf_parameter_list_t
6029: );

Line 6031: wf_event.addparametertolist(

6027: p_value => l_rec_resp_r1.b_ref_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_REF_INF',l_rec_resp_r1.b_ref_code),
6028: p_parameterlist => l_wf_parameter_list_t
6029: );
6030:
6031: wf_event.addparametertolist(
6032: p_name => 'ATT_47',
6033: p_value => l_rec_resp_r1.pnote_delivery_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PNOTE_DELIVERY',l_rec_resp_r1.pnote_delivery_code),
6034: p_parameterlist => l_wf_parameter_list_t
6035: );

Line 6037: wf_event.addparametertolist(

6033: p_value => l_rec_resp_r1.pnote_delivery_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PNOTE_DELIVERY',l_rec_resp_r1.pnote_delivery_code),
6034: p_parameterlist => l_wf_parameter_list_t
6035: );
6036:
6037: wf_event.addparametertolist(
6038: p_name => 'ATT_48',
6039: p_value => l_rec_resp_r1.b_foreign_postal_code,
6040: p_parameterlist => l_wf_parameter_list_t
6041: );

Line 6042: wf_event.addparametertolist(

6038: p_name => 'ATT_48',
6039: p_value => l_rec_resp_r1.b_foreign_postal_code,
6040: p_parameterlist => l_wf_parameter_list_t
6041: );
6042: wf_event.addparametertolist(
6043: p_name => 'ATT_49',
6044: p_value => l_rec_resp_r1.stud_sign_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ELE_SIGN_IND',l_rec_resp_r1.stud_sign_ind),
6045: p_parameterlist => l_wf_parameter_list_t
6046: );

Line 6048: wf_event.addparametertolist(

6044: p_value => l_rec_resp_r1.stud_sign_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ELE_SIGN_IND',l_rec_resp_r1.stud_sign_ind),
6045: p_parameterlist => l_wf_parameter_list_t
6046: );
6047:
6048: wf_event.addparametertolist(
6049: p_name => 'ATT_50',
6050: p_value => l_rec_resp_r1.lend_non_ed_brc_id,
6051: p_parameterlist => l_wf_parameter_list_t
6052: );

Line 6054: wf_event.addparametertolist(

6050: p_value => l_rec_resp_r1.lend_non_ed_brc_id,
6051: p_parameterlist => l_wf_parameter_list_t
6052: );
6053:
6054: wf_event.addparametertolist(
6055: p_name => 'ATT_51',
6056: p_value => l_rec_resp_r1.lender_use_txt,
6057: p_parameterlist => l_wf_parameter_list_t
6058: );

Line 6060: wf_event.addparametertolist(

6056: p_value => l_rec_resp_r1.lender_use_txt,
6057: p_parameterlist => l_wf_parameter_list_t
6058: );
6059:
6060: wf_event.addparametertolist(
6061: p_name => 'ATT_52',
6062: p_value => l_rec_resp_r1.guarantor_use_txt,
6063: p_parameterlist => l_wf_parameter_list_t
6064: );

Line 6066: wf_event.addparametertolist(

6062: p_value => l_rec_resp_r1.guarantor_use_txt,
6063: p_parameterlist => l_wf_parameter_list_t
6064: );
6065:
6066: wf_event.addparametertolist(
6067: p_name => 'ATT_53',
6068: p_value => l_rec_resp_r1.b_permt_addr_chg_date,
6069: p_parameterlist => l_wf_parameter_list_t
6070: );

Line 6072: wf_event.addparametertolist(

6068: p_value => l_rec_resp_r1.b_permt_addr_chg_date,
6069: p_parameterlist => l_wf_parameter_list_t
6070: );
6071:
6072: wf_event.addparametertolist(
6073: p_name => 'ATT_54',
6074: p_value => l_rec_resp_r1.alt_prog_type_code,
6075: p_parameterlist => l_wf_parameter_list_t
6076: );

Line 6078: wf_event.addparametertolist(

6074: p_value => l_rec_resp_r1.alt_prog_type_code,
6075: p_parameterlist => l_wf_parameter_list_t
6076: );
6077:
6078: wf_event.addparametertolist(
6079: p_name => 'ATT_55',
6080: p_value => l_rec_resp_r1.prc_type_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',l_rec_resp_r1.prc_type_code),
6081: p_parameterlist => l_wf_parameter_list_t
6082: );

Line 6086: wf_event.addparametertolist(

6082: );
6083: -- No mapping field available for ATT_56. Discussed with TD writer
6084: -- Td writer agreed upon to skip this ATT_56
6085:
6086: wf_event.addparametertolist(
6087: p_name => 'ATT_57',
6088: p_value => l_rec_resp_r1.guarnt_status_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_GUARNT_STATUS',l_rec_resp_r1.guarnt_status_code),
6089: p_parameterlist => l_wf_parameter_list_t
6090: );

Line 6092: wf_event.addparametertolist(

6088: p_value => l_rec_resp_r1.guarnt_status_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_GUARNT_STATUS',l_rec_resp_r1.guarnt_status_code),
6089: p_parameterlist => l_wf_parameter_list_t
6090: );
6091:
6092: wf_event.addparametertolist(
6093: p_name => 'ATT_58',
6094: p_value => l_rec_resp_r1.lender_status_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_LEND_STATUS',l_rec_resp_r1.lender_status_code),
6095: p_parameterlist => l_wf_parameter_list_t
6096: );

Line 6098: wf_event.addparametertolist(

6094: p_value => l_rec_resp_r1.lender_status_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_LEND_STATUS',l_rec_resp_r1.lender_status_code),
6095: p_parameterlist => l_wf_parameter_list_t
6096: );
6097:
6098: wf_event.addparametertolist(
6099: p_name => 'ATT_59',
6100: p_value => l_rec_resp_r1.pnote_status_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PNOTE_STATUS',l_rec_resp_r1.pnote_status_code),
6101: p_parameterlist => l_wf_parameter_list_t
6102: );

Line 6104: wf_event.addparametertolist(

6100: p_value => l_rec_resp_r1.pnote_status_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PNOTE_STATUS',l_rec_resp_r1.pnote_status_code),
6101: p_parameterlist => l_wf_parameter_list_t
6102: );
6103:
6104: wf_event.addparametertolist(
6105: p_name => 'ATT_60',
6106: p_value => l_rec_resp_r1.credit_status_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CREDIT_OVERRIDE',l_rec_resp_r1.credit_status_code),
6107: p_parameterlist => l_wf_parameter_list_t
6108: );

Line 6110: wf_event.addparametertolist(

6106: p_value => l_rec_resp_r1.credit_status_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CREDIT_OVERRIDE',l_rec_resp_r1.credit_status_code),
6107: p_parameterlist => l_wf_parameter_list_t
6108: );
6109:
6110: wf_event.addparametertolist(
6111: p_name => 'ATT_61',
6112: p_value => l_rec_resp_r1.guarnt_status_date,
6113: p_parameterlist => l_wf_parameter_list_t
6114: );

Line 6116: wf_event.addparametertolist(

6112: p_value => l_rec_resp_r1.guarnt_status_date,
6113: p_parameterlist => l_wf_parameter_list_t
6114: );
6115:
6116: wf_event.addparametertolist(
6117: p_name => 'ATT_62',
6118: p_value => l_rec_resp_r1.lender_status_date,
6119: p_parameterlist => l_wf_parameter_list_t
6120: );

Line 6122: wf_event.addparametertolist(

6118: p_value => l_rec_resp_r1.lender_status_date,
6119: p_parameterlist => l_wf_parameter_list_t
6120: );
6121:
6122: wf_event.addparametertolist(
6123: p_name => 'ATT_63',
6124: p_value => l_rec_resp_r1.pnote_status_date,
6125: p_parameterlist => l_wf_parameter_list_t
6126: );

Line 6128: wf_event.addparametertolist(

6124: p_value => l_rec_resp_r1.pnote_status_date,
6125: p_parameterlist => l_wf_parameter_list_t
6126: );
6127:
6128: wf_event.addparametertolist(
6129: p_name => 'ATT_64',
6130: p_value => l_rec_resp_r1.credit_status_date,
6131: p_parameterlist => l_wf_parameter_list_t
6132: );

Line 6134: wf_event.addparametertolist(

6130: p_value => l_rec_resp_r1.credit_status_date,
6131: p_parameterlist => l_wf_parameter_list_t
6132: );
6133:
6134: wf_event.addparametertolist(
6135: p_name => 'ATT_65',
6136: p_value => l_rec_resp_r1.act_serial_loan_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_SERIAL_LOAN_CODE',l_rec_resp_r1.act_serial_loan_code),
6137: p_parameterlist => l_wf_parameter_list_t
6138: );

Line 6140: wf_event.addparametertolist(

6136: p_value => l_rec_resp_r1.act_serial_loan_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_SERIAL_LOAN_CODE',l_rec_resp_r1.act_serial_loan_code),
6137: p_parameterlist => l_wf_parameter_list_t
6138: );
6139:
6140: wf_event.addparametertolist(
6141: p_name => 'ATT_66',
6142: p_value => l_rec_resp_r1.sch_non_ed_brc_id,
6143: p_parameterlist => l_wf_parameter_list_t
6144: );

Line 6146: wf_event.addparametertolist(

6142: p_value => l_rec_resp_r1.sch_non_ed_brc_id,
6143: p_parameterlist => l_wf_parameter_list_t
6144: );
6145:
6146: wf_event.addparametertolist(
6147: p_name => 'ATT_67',
6148: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_borrow_created),
6149: p_parameterlist => l_wf_parameter_list_t
6150: );

Line 6152: wf_event.addparametertolist(

6148: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_borrow_created),
6149: p_parameterlist => l_wf_parameter_list_t
6150: );
6151:
6152: wf_event.addparametertolist(
6153: p_name => 'ATT_68',
6154: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_student_created),
6155: p_parameterlist => l_wf_parameter_list_t
6156: );

Line 6158: wf_event.addparametertolist(

6154: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_student_created),
6155: p_parameterlist => l_wf_parameter_list_t
6156: );
6157:
6158: wf_event.addparametertolist(
6159: p_name => 'ATT_69',
6160: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_rel_created),
6161: p_parameterlist => l_wf_parameter_list_t
6162: );

Line 6168: wf_event.addparametertolist(

6164: END IF;
6165:
6166: IF g_v_cl_version = 'RELEASE-4' THEN
6167:
6168: wf_event.addparametertolist(
6169: p_name => 'ATT_21',
6170: p_value => l_rec_resp_r1.b_citizenship_status||' - '||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT', l_rec_resp_r1.b_citizenship_status),
6171: p_parameterlist => l_wf_parameter_list_t
6172: );

Line 6174: wf_event.addparametertolist(

6170: p_value => l_rec_resp_r1.b_citizenship_status||' - '||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT', l_rec_resp_r1.b_citizenship_status),
6171: p_parameterlist => l_wf_parameter_list_t
6172: );
6173:
6174: wf_event.addparametertolist(
6175: p_name => 'ATT_22',
6176: p_value => l_rec_resp_r1.b_state_of_legal_res||' - '||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_state_of_legal_res),
6177: p_parameterlist => l_wf_parameter_list_t
6178: );

Line 6179: wf_event.addparametertolist(

6175: p_name => 'ATT_22',
6176: p_value => l_rec_resp_r1.b_state_of_legal_res||' - '||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_state_of_legal_res),
6177: p_parameterlist => l_wf_parameter_list_t
6178: );
6179: wf_event.addparametertolist(
6180: p_name => 'ATT_23',
6181: p_value => l_rec_resp_r1.b_legal_res_date,
6182: p_parameterlist => l_wf_parameter_list_t
6183: );

Line 6185: wf_event.addparametertolist(

6181: p_value => l_rec_resp_r1.b_legal_res_date,
6182: p_parameterlist => l_wf_parameter_list_t
6183: );
6184:
6185: wf_event.addparametertolist(
6186: p_name => 'ATT_24',
6187: p_value => l_rec_resp_r1.b_default_status||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_P_DEFAULT_STATUS',l_rec_resp_r1.b_default_status),
6188: p_parameterlist => l_wf_parameter_list_t
6189: );

Line 6191: wf_event.addparametertolist(

6187: p_value => l_rec_resp_r1.b_default_status||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_P_DEFAULT_STATUS',l_rec_resp_r1.b_default_status),
6188: p_parameterlist => l_wf_parameter_list_t
6189: );
6190:
6191: wf_event.addparametertolist(
6192: p_name => 'ATT_25',
6193: p_value => l_rec_resp_r1.b_outstd_loan_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_outstd_loan_code),
6194: p_parameterlist => l_wf_parameter_list_t
6195: );

Line 6197: wf_event.addparametertolist(

6193: p_value => l_rec_resp_r1.b_outstd_loan_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_outstd_loan_code),
6194: p_parameterlist => l_wf_parameter_list_t
6195: );
6196:
6197: wf_event.addparametertolist(
6198: p_name => 'ATT_26',
6199: p_value => l_rec_resp_r1.b_indicator_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_indicator_code),
6200: p_parameterlist => l_wf_parameter_list_t
6201: );

Line 6203: wf_event.addparametertolist(

6199: p_value => l_rec_resp_r1.b_indicator_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_indicator_code),
6200: p_parameterlist => l_wf_parameter_list_t
6201: );
6202:
6203: wf_event.addparametertolist(
6204: p_name => 'ATT_27',
6205: p_value => l_rec_resp_r1.s_last_name,
6206: p_parameterlist => l_wf_parameter_list_t
6207: );

Line 6209: wf_event.addparametertolist(

6205: p_value => l_rec_resp_r1.s_last_name,
6206: p_parameterlist => l_wf_parameter_list_t
6207: );
6208:
6209: wf_event.addparametertolist(
6210: p_name => 'ATT_28',
6211: p_value => l_rec_resp_r1.s_first_name,
6212: p_parameterlist => l_wf_parameter_list_t
6213: );

Line 6215: wf_event.addparametertolist(

6211: p_value => l_rec_resp_r1.s_first_name,
6212: p_parameterlist => l_wf_parameter_list_t
6213: );
6214:
6215: wf_event.addparametertolist(
6216: p_name => 'ATT_29',
6217: p_value => l_rec_resp_r1.s_middle_name,
6218: p_parameterlist => l_wf_parameter_list_t
6219: );

Line 6221: wf_event.addparametertolist(

6217: p_value => l_rec_resp_r1.s_middle_name,
6218: p_parameterlist => l_wf_parameter_list_t
6219: );
6220:
6221: wf_event.addparametertolist(
6222: p_name => 'ATT_30',
6223: p_value => l_rec_resp_r1.s_ssn,
6224: p_parameterlist => l_wf_parameter_list_t
6225: );

Line 6227: wf_event.addparametertolist(

6223: p_value => l_rec_resp_r1.s_ssn,
6224: p_parameterlist => l_wf_parameter_list_t
6225: );
6226:
6227: wf_event.addparametertolist(
6228: p_name => 'ATT_31',
6229: p_value => l_rec_resp_r1.s_date_of_birth,
6230: p_parameterlist => l_wf_parameter_list_t
6231: );

Line 6233: wf_event.addparametertolist(

6229: p_value => l_rec_resp_r1.s_date_of_birth,
6230: p_parameterlist => l_wf_parameter_list_t
6231: );
6232:
6233: wf_event.addparametertolist(
6234: p_name => 'ATT_32',
6235: p_value => l_rec_resp_r1.s_citizenship_status||' - '||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT',l_rec_resp_r1.s_citizenship_status),
6236: p_parameterlist => l_wf_parameter_list_t
6237: );

Line 6239: wf_event.addparametertolist(

6235: p_value => l_rec_resp_r1.s_citizenship_status||' - '||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT',l_rec_resp_r1.s_citizenship_status),
6236: p_parameterlist => l_wf_parameter_list_t
6237: );
6238:
6239: wf_event.addparametertolist(
6240: p_name => 'ATT_33',
6241: p_value => l_rec_resp_r1.s_default_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_S_DEFAULT_STATUS',l_rec_resp_r1.s_default_code),
6242: p_parameterlist => l_wf_parameter_list_t
6243: );

Line 6245: wf_event.addparametertolist(

6241: p_value => l_rec_resp_r1.s_default_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_S_DEFAULT_STATUS',l_rec_resp_r1.s_default_code),
6242: p_parameterlist => l_wf_parameter_list_t
6243: );
6244:
6245: wf_event.addparametertolist(
6246: p_name => 'ATT_34',
6247: p_value => l_rec_resp_r1.s_signature_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_STUD_SIGN_CODE',l_rec_resp_r1.s_signature_code),
6248: p_parameterlist => l_wf_parameter_list_t
6249: );

Line 6251: wf_event.addparametertolist(

6247: p_value => l_rec_resp_r1.s_signature_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_STUD_SIGN_CODE',l_rec_resp_r1.s_signature_code),
6248: p_parameterlist => l_wf_parameter_list_t
6249: );
6250:
6251: wf_event.addparametertolist(
6252: p_name => 'ATT_35',
6253: p_value => l_rec_resp_r1.school_id,
6254: p_parameterlist => l_wf_parameter_list_t
6255: );

Line 6257: wf_event.addparametertolist(

6253: p_value => l_rec_resp_r1.school_id,
6254: p_parameterlist => l_wf_parameter_list_t
6255: );
6256:
6257: wf_event.addparametertolist(
6258: p_name => 'ATT_36',
6259: p_value => l_rec_resp_r1.loan_per_begin_date,
6260: p_parameterlist => l_wf_parameter_list_t
6261: );

Line 6263: wf_event.addparametertolist(

6259: p_value => l_rec_resp_r1.loan_per_begin_date,
6260: p_parameterlist => l_wf_parameter_list_t
6261: );
6262:
6263: wf_event.addparametertolist(
6264: p_name => 'ATT_37',
6265: p_value => l_rec_resp_r1.loan_per_end_date,
6266: p_parameterlist => l_wf_parameter_list_t
6267: );

Line 6269: wf_event.addparametertolist(

6265: p_value => l_rec_resp_r1.loan_per_end_date,
6266: p_parameterlist => l_wf_parameter_list_t
6267: );
6268:
6269: wf_event.addparametertolist(
6270: p_name => 'ATT_38',
6271: p_value => l_rec_resp_r1.alt_appl_ver_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_ALT_LOAN_CODE',l_rec_resp_r1.alt_appl_ver_code) ,
6272: p_parameterlist => l_wf_parameter_list_t
6273: );

Line 6275: wf_event.addparametertolist(

6271: p_value => l_rec_resp_r1.alt_appl_ver_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_ALT_LOAN_CODE',l_rec_resp_r1.alt_appl_ver_code) ,
6272: p_parameterlist => l_wf_parameter_list_t
6273: );
6274:
6275: wf_event.addparametertolist(
6276: p_name => 'ATT_39',
6277: p_value => l_rec_resp_r1.lender_id,
6278: p_parameterlist => l_wf_parameter_list_t
6279: );

Line 6281: wf_event.addparametertolist(

6277: p_value => l_rec_resp_r1.lender_id,
6278: p_parameterlist => l_wf_parameter_list_t
6279: );
6280:
6281: wf_event.addparametertolist(
6282: p_name => 'ATT_40',
6283: p_value => l_rec_resp_r1.guarantor_id,
6284: p_parameterlist => l_wf_parameter_list_t
6285: );

Line 6287: wf_event.addparametertolist(

6283: p_value => l_rec_resp_r1.guarantor_id,
6284: p_parameterlist => l_wf_parameter_list_t
6285: );
6286: -- Bug # 4141704
6287: wf_event.addparametertolist(
6288: p_name => 'ATT_41',
6289: p_value => l_rec_resp_r1.fed_appl_form_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_APP_FORM_CODE',l_rec_resp_r1.fed_appl_form_code),
6290: p_parameterlist => l_wf_parameter_list_t
6291: );

Line 6293: wf_event.addparametertolist(

6289: p_value => l_rec_resp_r1.fed_appl_form_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_APP_FORM_CODE',l_rec_resp_r1.fed_appl_form_code),
6290: p_parameterlist => l_wf_parameter_list_t
6291: );
6292:
6293: wf_event.addparametertolist(
6294: p_name => 'ATT_42',
6295: p_value => l_rec_resp_r1.mpn_confirm_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_MPN_CONF_IND',l_rec_resp_r1.mpn_confirm_ind),
6296: p_parameterlist => l_wf_parameter_list_t
6297: );

Line 6300: wf_event.addparametertolist(

6296: p_parameterlist => l_wf_parameter_list_t
6297: );
6298:
6299:
6300: wf_event.addparametertolist(
6301: p_name => 'ATT_43',
6302: p_value => l_rec_resp_r1.b_license_state||' - '||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_license_state),
6303: p_parameterlist => l_wf_parameter_list_t
6304: );

Line 6306: wf_event.addparametertolist(

6302: p_value => l_rec_resp_r1.b_license_state||' - '||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_license_state),
6303: p_parameterlist => l_wf_parameter_list_t
6304: );
6305:
6306: wf_event.addparametertolist(
6307: p_name => 'ATT_44',
6308: p_value => l_rec_resp_r1.b_license_number,
6309: p_parameterlist => l_wf_parameter_list_t
6310: );

Line 6312: wf_event.addparametertolist(

6308: p_value => l_rec_resp_r1.b_license_number,
6309: p_parameterlist => l_wf_parameter_list_t
6310: );
6311:
6312: wf_event.addparametertolist(
6313: p_name => 'ATT_45',
6314: p_value => l_rec_resp_r1.b_ref_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_REF_INF',l_rec_resp_r1.b_ref_code),
6315: p_parameterlist => l_wf_parameter_list_t
6316: );

Line 6318: wf_event.addparametertolist(

6314: p_value => l_rec_resp_r1.b_ref_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_REF_INF',l_rec_resp_r1.b_ref_code),
6315: p_parameterlist => l_wf_parameter_list_t
6316: );
6317:
6318: wf_event.addparametertolist(
6319: p_name => 'ATT_46',
6320: p_value => l_rec_resp_r1.pnote_delivery_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PNOTE_DELIVERY',l_rec_resp_r1.pnote_delivery_code),
6321: p_parameterlist => l_wf_parameter_list_t
6322: );

Line 6324: wf_event.addparametertolist(

6320: p_value => l_rec_resp_r1.pnote_delivery_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PNOTE_DELIVERY',l_rec_resp_r1.pnote_delivery_code),
6321: p_parameterlist => l_wf_parameter_list_t
6322: );
6323:
6324: wf_event.addparametertolist(
6325: p_name => 'ATT_47',
6326: p_value => l_rec_resp_r1.b_foreign_postal_code,
6327: p_parameterlist => l_wf_parameter_list_t
6328: );

Line 6330: wf_event.addparametertolist(

6326: p_value => l_rec_resp_r1.b_foreign_postal_code,
6327: p_parameterlist => l_wf_parameter_list_t
6328: );
6329:
6330: wf_event.addparametertolist(
6331: p_name => 'ATT_48',
6332: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_borrow_created),
6333: p_parameterlist => l_wf_parameter_list_t
6334: );

Line 6336: wf_event.addparametertolist(

6332: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_borrow_created),
6333: p_parameterlist => l_wf_parameter_list_t
6334: );
6335:
6336: wf_event.addparametertolist(
6337: p_name => 'ATT_49',
6338: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_student_created),
6339: p_parameterlist => l_wf_parameter_list_t
6340: );

Line 6342: wf_event.addparametertolist(

6338: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_student_created),
6339: p_parameterlist => l_wf_parameter_list_t
6340: );
6341:
6342: wf_event.addparametertolist(
6343: p_name => 'ATT_50',
6344: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_rel_created),
6345: p_parameterlist => l_wf_parameter_list_t
6346: );

Line 6354: wf_event.RAISE (p_event_name => l_wf_event_name,

6350: -- raise the business event
6351: log_to_fnd(p_v_module => 'raise_scr_event',
6352: p_v_string => 'Raising the business event'
6353: );
6354: wf_event.RAISE (p_event_name => l_wf_event_name,
6355: p_event_key => l_wf_event_key,
6356: p_parameters => l_wf_parameter_list_t
6357: );
6358: l_wf_parameter_list_t.DELETE;

Line 6355: p_event_key => l_wf_event_key,

6351: log_to_fnd(p_v_module => 'raise_scr_event',
6352: p_v_string => 'Raising the business event'
6353: );
6354: wf_event.RAISE (p_event_name => l_wf_event_name,
6355: p_event_key => l_wf_event_key,
6356: p_parameters => l_wf_parameter_list_t
6357: );
6358: l_wf_parameter_list_t.DELETE;
6359:

Line 6392: CURSOR c_wf_event_key IS

6388: --
6389: --Change History:
6390: --Who When What
6391: ------------------------------------------------------------------
6392: CURSOR c_wf_event_key IS
6393: SELECT igf_sl_cl_scr_seq.NEXTVAL -- MN 12-Jan-2005 - As the WorkFlow in use is common between
6394: -- Amt Diff and SCR Diff using same sequence and removing igf_sl_cl_gamt_seq
6395: FROM DUAL;
6396:

Line 6397: l_wf_event_t wf_event_t;

6393: SELECT igf_sl_cl_scr_seq.NEXTVAL -- MN 12-Jan-2005 - As the WorkFlow in use is common between
6394: -- Amt Diff and SCR Diff using same sequence and removing igf_sl_cl_gamt_seq
6395: FROM DUAL;
6396:
6397: l_wf_event_t wf_event_t;
6398: l_wf_parameter_list_t wf_parameter_list_t;
6399: l_wf_event_name VARCHAR2(255);
6400: l_wf_event_key NUMBER;
6401: l_v_role fnd_user.user_name%TYPE;

Line 6399: l_wf_event_name VARCHAR2(255);

6395: FROM DUAL;
6396:
6397: l_wf_event_t wf_event_t;
6398: l_wf_parameter_list_t wf_parameter_list_t;
6399: l_wf_event_name VARCHAR2(255);
6400: l_wf_event_key NUMBER;
6401: l_v_role fnd_user.user_name%TYPE;
6402:
6403: BEGIN

Line 6400: l_wf_event_key NUMBER;

6396:
6397: l_wf_event_t wf_event_t;
6398: l_wf_parameter_list_t wf_parameter_list_t;
6399: l_wf_event_name VARCHAR2(255);
6400: l_wf_event_key NUMBER;
6401: l_v_role fnd_user.user_name%TYPE;
6402:
6403: BEGIN
6404: log_to_fnd(p_v_module => 'raise_gamt_event',

Line 6422: p_v_string => 'Initializing the wf_event_t object'

6418: '|p_n_approved_amt : ' ||p_n_approved_amt
6419: );
6420:
6421: log_to_fnd(p_v_module => 'raise_gamt_event',
6422: p_v_string => 'Initializing the wf_event_t object'
6423: );
6424:
6425: -- initialize the wf_event_t object
6426: wf_event_t.initialize(l_wf_event_t);

Line 6425: -- initialize the wf_event_t object

6421: log_to_fnd(p_v_module => 'raise_gamt_event',
6422: p_v_string => 'Initializing the wf_event_t object'
6423: );
6424:
6425: -- initialize the wf_event_t object
6426: wf_event_t.initialize(l_wf_event_t);
6427: l_wf_event_name := 'oracle.apps.igf.sl.loans.ffelp.LoanGuaranteeAmount';
6428: log_to_fnd(p_v_module => 'raise_gamt_event',
6429: p_v_string => 'Setting the workflow event name '||l_wf_event_name

Line 6426: wf_event_t.initialize(l_wf_event_t);

6422: p_v_string => 'Initializing the wf_event_t object'
6423: );
6424:
6425: -- initialize the wf_event_t object
6426: wf_event_t.initialize(l_wf_event_t);
6427: l_wf_event_name := 'oracle.apps.igf.sl.loans.ffelp.LoanGuaranteeAmount';
6428: log_to_fnd(p_v_module => 'raise_gamt_event',
6429: p_v_string => 'Setting the workflow event name '||l_wf_event_name
6430: );

Line 6427: l_wf_event_name := 'oracle.apps.igf.sl.loans.ffelp.LoanGuaranteeAmount';

6423: );
6424:
6425: -- initialize the wf_event_t object
6426: wf_event_t.initialize(l_wf_event_t);
6427: l_wf_event_name := 'oracle.apps.igf.sl.loans.ffelp.LoanGuaranteeAmount';
6428: log_to_fnd(p_v_module => 'raise_gamt_event',
6429: p_v_string => 'Setting the workflow event name '||l_wf_event_name
6430: );
6431: -- set the event name

Line 6429: p_v_string => 'Setting the workflow event name '||l_wf_event_name

6425: -- initialize the wf_event_t object
6426: wf_event_t.initialize(l_wf_event_t);
6427: l_wf_event_name := 'oracle.apps.igf.sl.loans.ffelp.LoanGuaranteeAmount';
6428: log_to_fnd(p_v_module => 'raise_gamt_event',
6429: p_v_string => 'Setting the workflow event name '||l_wf_event_name
6430: );
6431: -- set the event name
6432: l_wf_event_t.seteventname( peventname => l_wf_event_name);
6433:

Line 6432: l_wf_event_t.seteventname( peventname => l_wf_event_name);

6428: log_to_fnd(p_v_module => 'raise_gamt_event',
6429: p_v_string => 'Setting the workflow event name '||l_wf_event_name
6430: );
6431: -- set the event name
6432: l_wf_event_t.seteventname( peventname => l_wf_event_name);
6433:
6434: log_to_fnd(p_v_module => 'raise_gamt_event',
6435: p_v_string => 'Obtaining the workflow event key'
6436: );

Line 6437: OPEN c_wf_event_key;

6433:
6434: log_to_fnd(p_v_module => 'raise_gamt_event',
6435: p_v_string => 'Obtaining the workflow event key'
6436: );
6437: OPEN c_wf_event_key;
6438: FETCH c_wf_event_key INTO l_wf_event_key;
6439: CLOSE c_wf_event_key ;
6440:
6441: log_to_fnd(p_v_module => 'raise_gamt_event',

Line 6438: FETCH c_wf_event_key INTO l_wf_event_key;

6434: log_to_fnd(p_v_module => 'raise_gamt_event',
6435: p_v_string => 'Obtaining the workflow event key'
6436: );
6437: OPEN c_wf_event_key;
6438: FETCH c_wf_event_key INTO l_wf_event_key;
6439: CLOSE c_wf_event_key ;
6440:
6441: log_to_fnd(p_v_module => 'raise_gamt_event',
6442: p_v_string => 'The workflow event key '||l_wf_event_key

Line 6439: CLOSE c_wf_event_key ;

6435: p_v_string => 'Obtaining the workflow event key'
6436: );
6437: OPEN c_wf_event_key;
6438: FETCH c_wf_event_key INTO l_wf_event_key;
6439: CLOSE c_wf_event_key ;
6440:
6441: log_to_fnd(p_v_module => 'raise_gamt_event',
6442: p_v_string => 'The workflow event key '||l_wf_event_key
6443: );

Line 6442: p_v_string => 'The workflow event key '||l_wf_event_key

6438: FETCH c_wf_event_key INTO l_wf_event_key;
6439: CLOSE c_wf_event_key ;
6440:
6441: log_to_fnd(p_v_module => 'raise_gamt_event',
6442: p_v_string => 'The workflow event key '||l_wf_event_key
6443: );
6444: l_wf_event_t.setEventKey ( pEventKey => l_wf_event_name|| l_wf_event_key );
6445: -- set the parameter list
6446: log_to_fnd(p_v_module => 'raise_gamt_event',

Line 6444: l_wf_event_t.setEventKey ( pEventKey => l_wf_event_name|| l_wf_event_key );

6440:
6441: log_to_fnd(p_v_module => 'raise_gamt_event',
6442: p_v_string => 'The workflow event key '||l_wf_event_key
6443: );
6444: l_wf_event_t.setEventKey ( pEventKey => l_wf_event_name|| l_wf_event_key );
6445: -- set the parameter list
6446: log_to_fnd(p_v_module => 'raise_gamt_event',
6447: p_v_string => 'setting the parameter list'
6448: );

Line 6449: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );

6445: -- set the parameter list
6446: log_to_fnd(p_v_module => 'raise_gamt_event',
6447: p_v_string => 'setting the parameter list'
6448: );
6449: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
6450:
6451: -- Now add the parameters to the list to be passed to the workflow
6452: log_to_fnd(p_v_module => 'raise_gamt_event',
6453: p_v_string => 'Adding the parameters to the list passed to the workflow'

Line 6466: wf_event.addparametertolist(

6462: log_to_fnd(p_v_module => 'raise_gamt_event',
6463: p_v_string => 'After calling the fnd.profile.value(USERNAME)..The value of the USERNAME is '||l_v_role
6464: );
6465:
6466: wf_event.addparametertolist(
6467: p_name => 'USER_ID',
6468: p_value => l_v_role,
6469: p_parameterlist => l_wf_parameter_list_t
6470: );

Line 6471: wf_event.addparametertolist(

6467: p_name => 'USER_ID',
6468: p_value => l_v_role,
6469: p_parameterlist => l_wf_parameter_list_t
6470: );
6471: wf_event.addparametertolist(
6472: p_name => 'ATT_1',
6473: p_value => p_v_ci_alternate_code,
6474: p_parameterlist => l_wf_parameter_list_t
6475: );

Line 6477: wf_event.addparametertolist(

6473: p_value => p_v_ci_alternate_code,
6474: p_parameterlist => l_wf_parameter_list_t
6475: );
6476:
6477: wf_event.addparametertolist(
6478: p_name => 'ATT_2',
6479: p_value => (p_d_ci_start_dt ||'-'||p_d_ci_end_dt),
6480: p_parameterlist => l_wf_parameter_list_t
6481: );

Line 6483: wf_event.addparametertolist(

6479: p_value => (p_d_ci_start_dt ||'-'||p_d_ci_end_dt),
6480: p_parameterlist => l_wf_parameter_list_t
6481: );
6482:
6483: wf_event.addparametertolist(
6484: p_name => 'ATT_3',
6485: p_value => p_v_person_number,
6486: p_parameterlist => l_wf_parameter_list_t
6487: );

Line 6489: wf_event.addparametertolist(

6485: p_value => p_v_person_number,
6486: p_parameterlist => l_wf_parameter_list_t
6487: );
6488:
6489: wf_event.addparametertolist(
6490: p_name => 'ATT_4',
6491: p_value => p_v_person_name,
6492: p_parameterlist => l_wf_parameter_list_t
6493: );

Line 6495: wf_event.addparametertolist(

6491: p_value => p_v_person_name,
6492: p_parameterlist => l_wf_parameter_list_t
6493: );
6494:
6495: wf_event.addparametertolist(
6496: p_name => 'ATT_5',
6497: p_value => p_v_ssn,
6498: p_parameterlist => l_wf_parameter_list_t
6499: );

Line 6501: wf_event.addparametertolist(

6497: p_value => p_v_ssn,
6498: p_parameterlist => l_wf_parameter_list_t
6499: );
6500:
6501: wf_event.addparametertolist(
6502: p_name => 'ATT_6',
6503: p_value => p_v_loan_number,
6504: p_parameterlist => l_wf_parameter_list_t
6505: );

Line 6507: wf_event.addparametertolist(

6503: p_value => p_v_loan_number,
6504: p_parameterlist => l_wf_parameter_list_t
6505: );
6506:
6507: wf_event.addparametertolist(
6508: p_name => 'ATT_7',
6509: p_value => p_d_loan_per_begin_date||'-'||p_d_loan_per_end_date,
6510: p_parameterlist => l_wf_parameter_list_t
6511: );

Line 6513: wf_event.addparametertolist(

6509: p_value => p_d_loan_per_begin_date||'-'||p_d_loan_per_end_date,
6510: p_parameterlist => l_wf_parameter_list_t
6511: );
6512:
6513: wf_event.addparametertolist(
6514: p_name => 'ATT_8',
6515: p_value => igf_aw_gen.lookup_desc('IGF_AW_FED_FUND ',p_v_loan_type),
6516: p_parameterlist => l_wf_parameter_list_t
6517: );

Line 6519: wf_event.addparametertolist(

6515: p_value => igf_aw_gen.lookup_desc('IGF_AW_FED_FUND ',p_v_loan_type),
6516: p_parameterlist => l_wf_parameter_list_t
6517: );
6518:
6519: wf_event.addparametertolist(
6520: p_name => 'ATT_9',
6521: p_value => p_n_award_accept_amt,
6522: p_parameterlist => l_wf_parameter_list_t
6523: );

Line 6525: wf_event.addparametertolist(

6521: p_value => p_n_award_accept_amt,
6522: p_parameterlist => l_wf_parameter_list_t
6523: );
6524:
6525: wf_event.addparametertolist(
6526: p_name => 'ATT_10',
6527: p_value => p_n_guarantee_amt,
6528: p_parameterlist => l_wf_parameter_list_t
6529: );

Line 6531: wf_event.addparametertolist(

6527: p_value => p_n_guarantee_amt,
6528: p_parameterlist => l_wf_parameter_list_t
6529: );
6530:
6531: wf_event.addparametertolist(
6532: p_name => 'ATT_11',
6533: p_value => p_n_approved_amt,
6534: p_parameterlist => l_wf_parameter_list_t
6535: );

Line 6541: wf_event.RAISE (p_event_name => l_wf_event_name,

6537: -- raise the business event
6538: log_to_fnd(p_v_module => 'raise_gamt_event',
6539: p_v_string => 'Raising the business event'
6540: );
6541: wf_event.RAISE (p_event_name => l_wf_event_name,
6542: p_event_key => l_wf_event_key,
6543: p_parameters => l_wf_parameter_list_t
6544: );
6545: l_wf_parameter_list_t.DELETE;

Line 6542: p_event_key => l_wf_event_key,

6538: log_to_fnd(p_v_module => 'raise_gamt_event',
6539: p_v_string => 'Raising the business event'
6540: );
6541: wf_event.RAISE (p_event_name => l_wf_event_name,
6542: p_event_key => l_wf_event_key,
6543: p_parameters => l_wf_parameter_list_t
6544: );
6545: l_wf_parameter_list_t.DELETE;
6546: END raise_gamt_event;