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_PARAMETER_LIST_T

Line 5686: l_wf_parameter_list_t wf_parameter_list_t;

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;
5690: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;

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 5747: p_parameterlist => l_wf_parameter_list_t

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: );
5749: wf_event.addparametertolist(
5750: p_name => 'RELEASE_VERSION',
5751: p_value => g_v_cl_version,

Line 5752: 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: );
5754:
5755: wf_event.addparametertolist(
5756: p_name => 'ATT_1',

Line 5758: p_parameterlist => l_wf_parameter_list_t

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: );
5760:
5761: wf_event.addparametertolist(
5762: p_name => 'ATT_2',

Line 5764: p_parameterlist => l_wf_parameter_list_t

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: );
5766:
5767: wf_event.addparametertolist(
5768: p_name => 'ATT_3',

Line 5770: p_parameterlist => l_wf_parameter_list_t

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: );
5772:
5773: wf_event.addparametertolist(
5774: p_name => 'ATT_4',

Line 5776: p_parameterlist => l_wf_parameter_list_t

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: );
5778:
5779: wf_event.addparametertolist(
5780: p_name => 'ATT_5',

Line 5782: p_parameterlist => l_wf_parameter_list_t

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: );
5784:
5785: wf_event.addparametertolist(
5786: p_name => 'ATT_6',

Line 5788: p_parameterlist => l_wf_parameter_list_t

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: );
5790:
5791: wf_event.addparametertolist(
5792: p_name => 'ATT_7',

Line 5794: p_parameterlist => l_wf_parameter_list_t

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: );
5796:
5797: wf_event.addparametertolist(
5798: p_name => 'ATT_8',

Line 5800: p_parameterlist => l_wf_parameter_list_t

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: );
5802:
5803: wf_event.addparametertolist(
5804: p_name => 'ATT_9',

Line 5806: p_parameterlist => l_wf_parameter_list_t

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: );
5808:
5809: wf_event.addparametertolist(
5810: p_name => 'ATT_10',

Line 5812: p_parameterlist => l_wf_parameter_list_t

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: );
5814:
5815: wf_event.addparametertolist(
5816: p_name => 'ATT_11',

Line 5818: p_parameterlist => l_wf_parameter_list_t

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: );
5820:
5821: wf_event.addparametertolist(
5822: p_name => 'ATT_12',

Line 5824: p_parameterlist => l_wf_parameter_list_t

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: );
5826:
5827: wf_event.addparametertolist(
5828: p_name => 'ATT_13',

Line 5830: p_parameterlist => l_wf_parameter_list_t

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: );
5832:
5833: wf_event.addparametertolist(
5834: p_name => 'ATT_14',

Line 5836: p_parameterlist => l_wf_parameter_list_t

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: );
5838:
5839: wf_event.addparametertolist(
5840: p_name => 'ATT_15',

Line 5842: p_parameterlist => l_wf_parameter_list_t

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: );
5844:
5845: wf_event.addparametertolist(
5846: p_name => 'ATT_16',

Line 5848: p_parameterlist => l_wf_parameter_list_t

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: );
5850:
5851: wf_event.addparametertolist(
5852: p_name => 'ATT_17',

Line 5854: p_parameterlist => l_wf_parameter_list_t

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: );
5856:
5857: wf_event.addparametertolist(
5858: p_name => 'ATT_18',

Line 5860: p_parameterlist => l_wf_parameter_list_t

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: );
5862:
5863: wf_event.addparametertolist(
5864: p_name => 'ATT_19',

Line 5866: p_parameterlist => l_wf_parameter_list_t

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: );
5868:
5869: wf_event.addparametertolist(
5870: p_name => 'ATT_20',

Line 5872: p_parameterlist => l_wf_parameter_list_t

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: );
5874:
5875: IF g_v_cl_version = 'RELEASE-5' THEN
5876:

Line 5880: p_parameterlist => l_wf_parameter_list_t

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: );
5882:
5883: wf_event.addparametertolist(
5884: p_name => 'ATT_22',

Line 5886: p_parameterlist => l_wf_parameter_list_t

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: );
5888:
5889: wf_event.addparametertolist(
5890: p_name => 'ATT_23',

Line 5892: p_parameterlist => l_wf_parameter_list_t

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: );
5894: wf_event.addparametertolist(
5895: p_name => 'ATT_24',
5896: p_value => l_rec_resp_r1.b_legal_res_date,

Line 5897: 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: );
5899:
5900: wf_event.addparametertolist(
5901: p_name => 'ATT_25',

Line 5903: p_parameterlist => l_wf_parameter_list_t

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: );
5905:
5906: wf_event.addparametertolist(
5907: p_name => 'ATT_26',

Line 5909: p_parameterlist => l_wf_parameter_list_t

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: );
5911:
5912: wf_event.addparametertolist(
5913: p_name => 'ATT_27',

Line 5915: p_parameterlist => l_wf_parameter_list_t

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: );
5917:
5918: wf_event.addparametertolist(
5919: p_name => 'ATT_28',

Line 5921: p_parameterlist => l_wf_parameter_list_t

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: );
5923:
5924: wf_event.addparametertolist(
5925: p_name => 'ATT_29',

Line 5927: p_parameterlist => l_wf_parameter_list_t

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: );
5929:
5930: wf_event.addparametertolist(
5931: p_name => 'ATT_30',

Line 5933: p_parameterlist => l_wf_parameter_list_t

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: );
5935:
5936: wf_event.addparametertolist(
5937: p_name => 'ATT_31',

Line 5939: p_parameterlist => l_wf_parameter_list_t

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: );
5941:
5942: wf_event.addparametertolist(
5943: p_name => 'ATT_32',

Line 5945: p_parameterlist => l_wf_parameter_list_t

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: );
5947:
5948: wf_event.addparametertolist(
5949: p_name => 'ATT_33',

Line 5951: p_parameterlist => l_wf_parameter_list_t

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: );
5953:
5954: wf_event.addparametertolist(
5955: p_name => 'ATT_34',

Line 5957: p_parameterlist => l_wf_parameter_list_t

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: );
5959:
5960: wf_event.addparametertolist(
5961: p_name => 'ATT_35',

Line 5963: p_parameterlist => l_wf_parameter_list_t

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: );
5965:
5966: wf_event.addparametertolist(
5967: p_name => 'ATT_36',

Line 5969: p_parameterlist => l_wf_parameter_list_t

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: );
5971:
5972: wf_event.addparametertolist(
5973: p_name => 'ATT_37',

Line 5975: p_parameterlist => l_wf_parameter_list_t

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: );
5977:
5978: wf_event.addparametertolist(
5979: p_name => 'ATT_38',

Line 5981: p_parameterlist => l_wf_parameter_list_t

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: );
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),

Line 5986: 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: );
5988:
5989: wf_event.addparametertolist(
5990: p_name => 'ATT_40',

Line 5992: p_parameterlist => l_wf_parameter_list_t

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: );
5994:
5995: wf_event.addparametertolist(
5996: p_name => 'ATT_41',

Line 5998: p_parameterlist => l_wf_parameter_list_t

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: );
6000:
6001: wf_event.addparametertolist(
6002: p_name => 'ATT_42',

Line 6004: p_parameterlist => l_wf_parameter_list_t

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: );
6006: -- Bug # 4141704
6007: wf_event.addparametertolist(
6008: p_name => 'ATT_43',

Line 6010: p_parameterlist => l_wf_parameter_list_t

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: );
6012:
6013: wf_event.addparametertolist(
6014: p_name => 'ATT_44',

Line 6016: p_parameterlist => l_wf_parameter_list_t

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: );
6018:
6019: wf_event.addparametertolist(
6020: p_name => 'ATT_45',

Line 6022: p_parameterlist => l_wf_parameter_list_t

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: );
6024:
6025: wf_event.addparametertolist(
6026: p_name => 'ATT_46',

Line 6028: p_parameterlist => l_wf_parameter_list_t

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: );
6030:
6031: wf_event.addparametertolist(
6032: p_name => 'ATT_47',

Line 6034: p_parameterlist => l_wf_parameter_list_t

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: );
6036:
6037: wf_event.addparametertolist(
6038: p_name => 'ATT_48',

Line 6040: p_parameterlist => l_wf_parameter_list_t

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: );
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),

Line 6045: 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: );
6047:
6048: wf_event.addparametertolist(
6049: p_name => 'ATT_50',

Line 6051: p_parameterlist => l_wf_parameter_list_t

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: );
6053:
6054: wf_event.addparametertolist(
6055: p_name => 'ATT_51',

Line 6057: p_parameterlist => l_wf_parameter_list_t

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: );
6059:
6060: wf_event.addparametertolist(
6061: p_name => 'ATT_52',

Line 6063: p_parameterlist => l_wf_parameter_list_t

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: );
6065:
6066: wf_event.addparametertolist(
6067: p_name => 'ATT_53',

Line 6069: p_parameterlist => l_wf_parameter_list_t

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: );
6071:
6072: wf_event.addparametertolist(
6073: p_name => 'ATT_54',

Line 6075: p_parameterlist => l_wf_parameter_list_t

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: );
6077:
6078: wf_event.addparametertolist(
6079: p_name => 'ATT_55',

Line 6081: p_parameterlist => l_wf_parameter_list_t

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: );
6083: -- No mapping field available for ATT_56. Discussed with TD writer
6084: -- Td writer agreed upon to skip this ATT_56
6085:

Line 6089: p_parameterlist => l_wf_parameter_list_t

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: );
6091:
6092: wf_event.addparametertolist(
6093: p_name => 'ATT_58',

Line 6095: p_parameterlist => l_wf_parameter_list_t

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: );
6097:
6098: wf_event.addparametertolist(
6099: p_name => 'ATT_59',

Line 6101: p_parameterlist => l_wf_parameter_list_t

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: );
6103:
6104: wf_event.addparametertolist(
6105: p_name => 'ATT_60',

Line 6107: p_parameterlist => l_wf_parameter_list_t

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: );
6109:
6110: wf_event.addparametertolist(
6111: p_name => 'ATT_61',

Line 6113: p_parameterlist => l_wf_parameter_list_t

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: );
6115:
6116: wf_event.addparametertolist(
6117: p_name => 'ATT_62',

Line 6119: p_parameterlist => l_wf_parameter_list_t

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: );
6121:
6122: wf_event.addparametertolist(
6123: p_name => 'ATT_63',

Line 6125: p_parameterlist => l_wf_parameter_list_t

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: );
6127:
6128: wf_event.addparametertolist(
6129: p_name => 'ATT_64',

Line 6131: p_parameterlist => l_wf_parameter_list_t

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: );
6133:
6134: wf_event.addparametertolist(
6135: p_name => 'ATT_65',

Line 6137: p_parameterlist => l_wf_parameter_list_t

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: );
6139:
6140: wf_event.addparametertolist(
6141: p_name => 'ATT_66',

Line 6143: p_parameterlist => l_wf_parameter_list_t

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: );
6145:
6146: wf_event.addparametertolist(
6147: p_name => 'ATT_67',

Line 6149: p_parameterlist => l_wf_parameter_list_t

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: );
6151:
6152: wf_event.addparametertolist(
6153: p_name => 'ATT_68',

Line 6155: p_parameterlist => l_wf_parameter_list_t

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: );
6157:
6158: wf_event.addparametertolist(
6159: p_name => 'ATT_69',

Line 6161: p_parameterlist => l_wf_parameter_list_t

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: );
6163:
6164: END IF;
6165:

Line 6171: p_parameterlist => l_wf_parameter_list_t

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: );
6173:
6174: wf_event.addparametertolist(
6175: p_name => 'ATT_22',

Line 6177: p_parameterlist => l_wf_parameter_list_t

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: );
6179: wf_event.addparametertolist(
6180: p_name => 'ATT_23',
6181: p_value => l_rec_resp_r1.b_legal_res_date,

Line 6182: 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: );
6184:
6185: wf_event.addparametertolist(
6186: p_name => 'ATT_24',

Line 6188: p_parameterlist => l_wf_parameter_list_t

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: );
6190:
6191: wf_event.addparametertolist(
6192: p_name => 'ATT_25',

Line 6194: p_parameterlist => l_wf_parameter_list_t

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: );
6196:
6197: wf_event.addparametertolist(
6198: p_name => 'ATT_26',

Line 6200: p_parameterlist => l_wf_parameter_list_t

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: );
6202:
6203: wf_event.addparametertolist(
6204: p_name => 'ATT_27',

Line 6206: p_parameterlist => l_wf_parameter_list_t

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: );
6208:
6209: wf_event.addparametertolist(
6210: p_name => 'ATT_28',

Line 6212: p_parameterlist => l_wf_parameter_list_t

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: );
6214:
6215: wf_event.addparametertolist(
6216: p_name => 'ATT_29',

Line 6218: p_parameterlist => l_wf_parameter_list_t

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: );
6220:
6221: wf_event.addparametertolist(
6222: p_name => 'ATT_30',

Line 6224: p_parameterlist => l_wf_parameter_list_t

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: );
6226:
6227: wf_event.addparametertolist(
6228: p_name => 'ATT_31',

Line 6230: p_parameterlist => l_wf_parameter_list_t

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: );
6232:
6233: wf_event.addparametertolist(
6234: p_name => 'ATT_32',

Line 6236: p_parameterlist => l_wf_parameter_list_t

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: );
6238:
6239: wf_event.addparametertolist(
6240: p_name => 'ATT_33',

Line 6242: p_parameterlist => l_wf_parameter_list_t

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: );
6244:
6245: wf_event.addparametertolist(
6246: p_name => 'ATT_34',

Line 6248: p_parameterlist => l_wf_parameter_list_t

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: );
6250:
6251: wf_event.addparametertolist(
6252: p_name => 'ATT_35',

Line 6254: p_parameterlist => l_wf_parameter_list_t

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: );
6256:
6257: wf_event.addparametertolist(
6258: p_name => 'ATT_36',

Line 6260: p_parameterlist => l_wf_parameter_list_t

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: );
6262:
6263: wf_event.addparametertolist(
6264: p_name => 'ATT_37',

Line 6266: p_parameterlist => l_wf_parameter_list_t

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: );
6268:
6269: wf_event.addparametertolist(
6270: p_name => 'ATT_38',

Line 6272: p_parameterlist => l_wf_parameter_list_t

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: );
6274:
6275: wf_event.addparametertolist(
6276: p_name => 'ATT_39',

Line 6278: p_parameterlist => l_wf_parameter_list_t

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: );
6280:
6281: wf_event.addparametertolist(
6282: p_name => 'ATT_40',

Line 6284: p_parameterlist => l_wf_parameter_list_t

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: );
6286: -- Bug # 4141704
6287: wf_event.addparametertolist(
6288: p_name => 'ATT_41',

Line 6290: p_parameterlist => l_wf_parameter_list_t

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: );
6292:
6293: wf_event.addparametertolist(
6294: p_name => 'ATT_42',

Line 6296: p_parameterlist => l_wf_parameter_list_t

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: );
6298:
6299:
6300: wf_event.addparametertolist(

Line 6303: p_parameterlist => l_wf_parameter_list_t

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: );
6305:
6306: wf_event.addparametertolist(
6307: p_name => 'ATT_44',

Line 6309: p_parameterlist => l_wf_parameter_list_t

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: );
6311:
6312: wf_event.addparametertolist(
6313: p_name => 'ATT_45',

Line 6315: p_parameterlist => l_wf_parameter_list_t

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: );
6317:
6318: wf_event.addparametertolist(
6319: p_name => 'ATT_46',

Line 6321: p_parameterlist => l_wf_parameter_list_t

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: );
6323:
6324: wf_event.addparametertolist(
6325: p_name => 'ATT_47',

Line 6327: p_parameterlist => l_wf_parameter_list_t

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: );
6329:
6330: wf_event.addparametertolist(
6331: p_name => 'ATT_48',

Line 6333: p_parameterlist => l_wf_parameter_list_t

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: );
6335:
6336: wf_event.addparametertolist(
6337: p_name => 'ATT_49',

Line 6339: p_parameterlist => l_wf_parameter_list_t

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: );
6341:
6342: wf_event.addparametertolist(
6343: p_name => 'ATT_50',

Line 6345: p_parameterlist => l_wf_parameter_list_t

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: );
6347:
6348: END IF;
6349:

Line 6356: p_parameters => l_wf_parameter_list_t

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:
6360: END raise_scr_event;

Line 6358: l_wf_parameter_list_t.DELETE;

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:
6360: END raise_scr_event;
6361:
6362: PROCEDURE raise_gamt_event ( p_v_ci_alternate_code IN igs_ca_inst_all.alternate_code%TYPE,

Line 6398: l_wf_parameter_list_t wf_parameter_list_t;

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;
6402:

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 6469: p_parameterlist => l_wf_parameter_list_t

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: );
6471: wf_event.addparametertolist(
6472: p_name => 'ATT_1',
6473: p_value => p_v_ci_alternate_code,

Line 6474: 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: );
6476:
6477: wf_event.addparametertolist(
6478: p_name => 'ATT_2',

Line 6480: p_parameterlist => l_wf_parameter_list_t

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: );
6482:
6483: wf_event.addparametertolist(
6484: p_name => 'ATT_3',

Line 6486: p_parameterlist => l_wf_parameter_list_t

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: );
6488:
6489: wf_event.addparametertolist(
6490: p_name => 'ATT_4',

Line 6492: p_parameterlist => l_wf_parameter_list_t

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: );
6494:
6495: wf_event.addparametertolist(
6496: p_name => 'ATT_5',

Line 6498: p_parameterlist => l_wf_parameter_list_t

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: );
6500:
6501: wf_event.addparametertolist(
6502: p_name => 'ATT_6',

Line 6504: p_parameterlist => l_wf_parameter_list_t

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: );
6506:
6507: wf_event.addparametertolist(
6508: p_name => 'ATT_7',

Line 6510: p_parameterlist => l_wf_parameter_list_t

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: );
6512:
6513: wf_event.addparametertolist(
6514: p_name => 'ATT_8',

Line 6516: p_parameterlist => l_wf_parameter_list_t

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: );
6518:
6519: wf_event.addparametertolist(
6520: p_name => 'ATT_9',

Line 6522: p_parameterlist => l_wf_parameter_list_t

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: );
6524:
6525: wf_event.addparametertolist(
6526: p_name => 'ATT_10',

Line 6528: p_parameterlist => l_wf_parameter_list_t

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: );
6530:
6531: wf_event.addparametertolist(
6532: p_name => 'ATT_11',

Line 6534: p_parameterlist => l_wf_parameter_list_t

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: );
6536:
6537: -- raise the business event
6538: log_to_fnd(p_v_module => 'raise_gamt_event',

Line 6543: p_parameters => l_wf_parameter_list_t

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;
6547:

Line 6545: l_wf_parameter_list_t.DELETE;

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;
6547:
6548: PROCEDURE insert_into_resp_r2(p_r2_record IN igf_sl_cl_resp_r2_dtls%ROWTYPE) AS
6549: ------------------------------------------------------------------