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_AP_MATCHING_PROCESS_PKG dependencies on WF_EVENT

Line 2041: l_event_t wf_event_t;

2037: */
2038:
2039:
2040: l_message_class VARCHAR2(30);
2041: l_event_t wf_event_t;
2042: l_raise_event VARCHAR2(50);
2043: l_seq_val VARCHAR2(100);
2044: l_parameter_list_t wf_parameter_list_t;
2045:

Line 2097: -- initialize the wf_event_t object

2093:
2094: -- Raise Business Event Notification
2095: l_raise_event := 'oracle.apps.igf.ap.PushedIsir';
2096:
2097: -- initialize the wf_event_t object
2098: wf_event_t.initialize(l_event_t);
2099:
2100: -- Adding the parameters to the parameter list
2101: wf_event.addparametertolist( p_name => 'M_SI_ID',

Line 2098: wf_event_t.initialize(l_event_t);

2094: -- Raise Business Event Notification
2095: l_raise_event := 'oracle.apps.igf.ap.PushedIsir';
2096:
2097: -- initialize the wf_event_t object
2098: wf_event_t.initialize(l_event_t);
2099:
2100: -- Adding the parameters to the parameter list
2101: wf_event.addparametertolist( p_name => 'M_SI_ID',
2102: p_value => g_isir_intrface_rec.si_id ,

Line 2101: wf_event.addparametertolist( p_name => 'M_SI_ID',

2097: -- initialize the wf_event_t object
2098: wf_event_t.initialize(l_event_t);
2099:
2100: -- Adding the parameters to the parameter list
2101: wf_event.addparametertolist( p_name => 'M_SI_ID',
2102: p_value => g_isir_intrface_rec.si_id ,
2103: p_parameterlist => l_parameter_list_t);
2104:
2105:

Line 2106: wf_event.addparametertolist( p_name => 'M_ORIG_SSN',

2102: p_value => g_isir_intrface_rec.si_id ,
2103: p_parameterlist => l_parameter_list_t);
2104:
2105:
2106: wf_event.addparametertolist( p_name => 'M_ORIG_SSN',
2107: p_value => g_isir_intrface_rec.original_ssn_txt,
2108: p_parameterlist => l_parameter_list_t);
2109:
2110:

Line 2111: wf_event.addparametertolist( p_name => 'M_TRANSACTION_NUM',

2107: p_value => g_isir_intrface_rec.original_ssn_txt,
2108: p_parameterlist => l_parameter_list_t);
2109:
2110:
2111: wf_event.addparametertolist( p_name => 'M_TRANSACTION_NUM',
2112: p_value => g_isir_intrface_rec.transaction_num_txt,
2113: p_parameterlist => l_parameter_list_t);
2114:
2115:

Line 2116: wf_event.addparametertolist( p_name => 'M_FIRST_NAME',

2112: p_value => g_isir_intrface_rec.transaction_num_txt,
2113: p_parameterlist => l_parameter_list_t);
2114:
2115:
2116: wf_event.addparametertolist( p_name => 'M_FIRST_NAME',
2117: p_value => g_isir_intrface_rec.first_name,
2118: p_parameterlist => l_parameter_list_t);
2119:
2120: wf_event.addparametertolist( p_name => 'M_PERSON_NUM',

Line 2120: wf_event.addparametertolist( p_name => 'M_PERSON_NUM',

2116: wf_event.addparametertolist( p_name => 'M_FIRST_NAME',
2117: p_value => g_isir_intrface_rec.first_name,
2118: p_parameterlist => l_parameter_list_t);
2119:
2120: wf_event.addparametertolist( p_name => 'M_PERSON_NUM',
2121: p_value => l_person_num,
2122: p_parameterlist => l_parameter_list_t);
2123:
2124:

Line 2126: wf_event.addparametertolist( p_name => 'M_EMAIL_USER_NAME',

2122: p_parameterlist => l_parameter_list_t);
2123:
2124:
2125: -- Set this role to the workflow
2126: wf_event.addparametertolist( p_name => 'M_EMAIL_USER_NAME',
2127: p_value => fnd_global.user_name,
2128: p_parameterlist => l_parameter_list_t);
2129:
2130: --Raise the event...

Line 2131: wf_event.raise (p_event_name => l_raise_event,

2127: p_value => fnd_global.user_name,
2128: p_parameterlist => l_parameter_list_t);
2129:
2130: --Raise the event...
2131: wf_event.raise (p_event_name => l_raise_event,
2132: p_event_key => l_seq_val,
2133: p_parameters => l_parameter_list_t);
2134:
2135: -- Deleting the Parameter list after the event is raised

Line 2174: l_event_t wf_event_t;

2170: */
2171:
2172:
2173: l_message_class VARCHAR2(30);
2174: l_event_t wf_event_t;
2175: l_raise_event VARCHAR2(50);
2176: l_seq_val VARCHAR2(100);
2177: l_parameter_list_t wf_parameter_list_t;
2178:

Line 2206: -- initialize the wf_event_t object

2202:
2203: -- Raise Business Event Notification
2204: l_raise_event := 'oracle.apps.igf.ap.DemographicChange';
2205:
2206: -- initialize the wf_event_t object
2207: wf_event_t.initialize(l_event_t);
2208:
2209: -- Adding the parameters to the parameter list
2210: wf_event.addparametertolist( p_name => 'M_SI_ID',

Line 2207: wf_event_t.initialize(l_event_t);

2203: -- Raise Business Event Notification
2204: l_raise_event := 'oracle.apps.igf.ap.DemographicChange';
2205:
2206: -- initialize the wf_event_t object
2207: wf_event_t.initialize(l_event_t);
2208:
2209: -- Adding the parameters to the parameter list
2210: wf_event.addparametertolist( p_name => 'M_SI_ID',
2211: p_value => g_isir_intrface_rec.si_id ,

Line 2210: wf_event.addparametertolist( p_name => 'M_SI_ID',

2206: -- initialize the wf_event_t object
2207: wf_event_t.initialize(l_event_t);
2208:
2209: -- Adding the parameters to the parameter list
2210: wf_event.addparametertolist( p_name => 'M_SI_ID',
2211: p_value => g_isir_intrface_rec.si_id ,
2212: p_parameterlist => l_parameter_list_t);
2213:
2214: wf_event.addparametertolist( p_name => 'M_PERSON_NUM',

Line 2214: wf_event.addparametertolist( p_name => 'M_PERSON_NUM',

2210: wf_event.addparametertolist( p_name => 'M_SI_ID',
2211: p_value => g_isir_intrface_rec.si_id ,
2212: p_parameterlist => l_parameter_list_t);
2213:
2214: wf_event.addparametertolist( p_name => 'M_PERSON_NUM',
2215: p_value => l_person_num,
2216: p_parameterlist => l_parameter_list_t);
2217:
2218:

Line 2219: wf_event.addparametertolist( p_name => 'M_ORIG_SSN',

2215: p_value => l_person_num,
2216: p_parameterlist => l_parameter_list_t);
2217:
2218:
2219: wf_event.addparametertolist( p_name => 'M_ORIG_SSN',
2220: p_value => g_isir_intrface_rec.original_ssn_txt,
2221: p_parameterlist => l_parameter_list_t);
2222:
2223:

Line 2224: wf_event.addparametertolist( p_name => 'M_TRANSACTION_NUM',

2220: p_value => g_isir_intrface_rec.original_ssn_txt,
2221: p_parameterlist => l_parameter_list_t);
2222:
2223:
2224: wf_event.addparametertolist( p_name => 'M_TRANSACTION_NUM',
2225: p_value => g_isir_intrface_rec.transaction_num_txt,
2226: p_parameterlist => l_parameter_list_t);
2227:
2228: wf_event.addparametertolist( p_name => 'M_SSN',

Line 2228: wf_event.addparametertolist( p_name => 'M_SSN',

2224: wf_event.addparametertolist( p_name => 'M_TRANSACTION_NUM',
2225: p_value => g_isir_intrface_rec.transaction_num_txt,
2226: p_parameterlist => l_parameter_list_t);
2227:
2228: wf_event.addparametertolist( p_name => 'M_SSN',
2229: p_value => g_isir_intrface_rec.current_ssn_txt,
2230: p_parameterlist => l_parameter_list_t);
2231:
2232:

Line 2233: wf_event.addparametertolist( p_name => 'M_FIRST_NAME',

2229: p_value => g_isir_intrface_rec.current_ssn_txt,
2230: p_parameterlist => l_parameter_list_t);
2231:
2232:
2233: wf_event.addparametertolist( p_name => 'M_FIRST_NAME',
2234: p_value => INITCAP(g_isir_intrface_rec.first_name),
2235: p_parameterlist => l_parameter_list_t);
2236:
2237:

Line 2238: wf_event.addparametertolist( p_name => 'M_LAST_NAME',

2234: p_value => INITCAP(g_isir_intrface_rec.first_name),
2235: p_parameterlist => l_parameter_list_t);
2236:
2237:
2238: wf_event.addparametertolist( p_name => 'M_LAST_NAME',
2239: p_value => INITCAP(g_isir_intrface_rec.last_name),
2240: p_parameterlist => l_parameter_list_t);
2241:
2242:

Line 2243: wf_event.addparametertolist( p_name => 'M_GENDER',

2239: p_value => INITCAP(g_isir_intrface_rec.last_name),
2240: p_parameterlist => l_parameter_list_t);
2241:
2242:
2243: wf_event.addparametertolist( p_name => 'M_GENDER',
2244: p_value => g_isir_intrface_rec.ss_r_u_male_flag,
2245: p_parameterlist => l_parameter_list_t);
2246:
2247: wf_event.addparametertolist( p_name => 'M_BIRTH_DT',

Line 2247: wf_event.addparametertolist( p_name => 'M_BIRTH_DT',

2243: wf_event.addparametertolist( p_name => 'M_GENDER',
2244: p_value => g_isir_intrface_rec.ss_r_u_male_flag,
2245: p_parameterlist => l_parameter_list_t);
2246:
2247: wf_event.addparametertolist( p_name => 'M_BIRTH_DT',
2248: p_value => g_isir_intrface_rec.birth_date,
2249: p_parameterlist => l_parameter_list_t);
2250:
2251:

Line 2252: wf_event.addparametertolist( p_name => 'M_ADDRESS',

2248: p_value => g_isir_intrface_rec.birth_date,
2249: p_parameterlist => l_parameter_list_t);
2250:
2251:
2252: wf_event.addparametertolist( p_name => 'M_ADDRESS',
2253: p_value => INITCAP(g_isir_intrface_rec.perm_mail_address_txt),
2254: p_parameterlist => l_parameter_list_t);
2255:
2256: wf_event.addparametertolist( p_name => 'M_CITY',

Line 2256: wf_event.addparametertolist( p_name => 'M_CITY',

2252: wf_event.addparametertolist( p_name => 'M_ADDRESS',
2253: p_value => INITCAP(g_isir_intrface_rec.perm_mail_address_txt),
2254: p_parameterlist => l_parameter_list_t);
2255:
2256: wf_event.addparametertolist( p_name => 'M_CITY',
2257: p_value => INITCAP(g_isir_intrface_rec.perm_city_txt),
2258: p_parameterlist => l_parameter_list_t);
2259:
2260:

Line 2261: wf_event.addparametertolist( p_name => 'M_ZIP_CODE',

2257: p_value => INITCAP(g_isir_intrface_rec.perm_city_txt),
2258: p_parameterlist => l_parameter_list_t);
2259:
2260:
2261: wf_event.addparametertolist( p_name => 'M_ZIP_CODE',
2262: p_value => g_isir_intrface_rec.perm_zip_cd,
2263: p_parameterlist => l_parameter_list_t);
2264:
2265: wf_event.addparametertolist( p_name => 'M_EMAIL',

Line 2265: wf_event.addparametertolist( p_name => 'M_EMAIL',

2261: wf_event.addparametertolist( p_name => 'M_ZIP_CODE',
2262: p_value => g_isir_intrface_rec.perm_zip_cd,
2263: p_parameterlist => l_parameter_list_t);
2264:
2265: wf_event.addparametertolist( p_name => 'M_EMAIL',
2266: p_value => g_isir_intrface_rec.s_email_address_txt,
2267: p_parameterlist => l_parameter_list_t);
2268:
2269: -- Set this role to the workflow

Line 2270: wf_event.addparametertolist( p_name => 'M_RECIPIENT',

2266: p_value => g_isir_intrface_rec.s_email_address_txt,
2267: p_parameterlist => l_parameter_list_t);
2268:
2269: -- Set this role to the workflow
2270: wf_event.addparametertolist( p_name => 'M_RECIPIENT',
2271: p_value => fnd_global.user_name,
2272: p_parameterlist => l_parameter_list_t);
2273:
2274: --Raise the event...

Line 2275: wf_event.raise (p_event_name => l_raise_event,

2271: p_value => fnd_global.user_name,
2272: p_parameterlist => l_parameter_list_t);
2273:
2274: --Raise the event...
2275: wf_event.raise (p_event_name => l_raise_event,
2276: p_event_key => l_seq_val,
2277: p_parameters => l_parameter_list_t);
2278:
2279: -- Deleting the Parameter list after the event is raised

Line 2871: -- if there are no correction items, mark the current isir as payment isir, else raise wf event.

2867: l_send_workflow := TRUE;
2868: l_message := 'IGF_AP_FED_NOT_IN_SYSTEM';
2869: ELSE
2870: -- no valid isir present, so check for correction items
2871: -- if there are no correction items, mark the current isir as payment isir, else raise wf event.
2872: -- refer to bug 4532047
2873: OPEN check_correction_items(g_base_id);
2874: FETCH check_correction_items INTO lv_chk_corrections ;
2875: IF check_correction_items%FOUND THEN