DBA Data[Home] [Help]

APPS.IGS_PE_USERID_PKG dependencies on WF_PARAMETER_LIST_T

Line 363: l_parameter_list_t wf_parameter_list_t;

359:
360: l_return_status VARCHAR2(1);
361: l_count NUMBER(9);
362: l_event_t wf_event_t;
363: l_parameter_list_t wf_parameter_list_t;
364: l_wf_name VARCHAR2(8) ;
365: itemkey VARCHAR2(100);
366:
367: BEGIN

Line 1783: l_wf_parameter_list_t WF_PARAMETER_LIST_T;

1779: AND NVL(hzp.effective_end_date,sysdate)
1780: AND hz.POSTAL_CODE= cp_zipcode;
1781:
1782: l_wf_event_t WF_EVENT_T;
1783: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
1784:
1785: CURSOR c_seq_num IS
1786: SELECT IGS_PE_GEN_USER_S.nextval
1787: FROM DUAL;

Line 1863: p_parameterlist => l_wf_parameter_list_t);

1859: WF_EVENT_T.Initialize(l_wf_event_t);
1860: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pe.accountrequest.alumni_nomatch');
1861: wf_event.AddParameterToList ( p_name => 'PERSON_NUMBER',
1862: p_value => p_person_num,
1863: p_parameterlist => l_wf_parameter_list_t);
1864: wf_event.AddParameterToList ( p_name => 'ALT_ID',
1865: p_value => p_pref_alt_id,
1866: p_parameterlist => l_wf_parameter_list_t);
1867: wf_event.AddParameterToList ( p_name => 'GENDER',

Line 1866: p_parameterlist => l_wf_parameter_list_t);

1862: p_value => p_person_num,
1863: p_parameterlist => l_wf_parameter_list_t);
1864: wf_event.AddParameterToList ( p_name => 'ALT_ID',
1865: p_value => p_pref_alt_id,
1866: p_parameterlist => l_wf_parameter_list_t);
1867: wf_event.AddParameterToList ( p_name => 'GENDER',
1868: p_value => p_gender,
1869: p_parameterlist => l_wf_parameter_list_t);
1870: wf_event.AddParameterToList ( p_name => 'BIRTH_DATE',

Line 1869: p_parameterlist => l_wf_parameter_list_t);

1865: p_value => p_pref_alt_id,
1866: p_parameterlist => l_wf_parameter_list_t);
1867: wf_event.AddParameterToList ( p_name => 'GENDER',
1868: p_value => p_gender,
1869: p_parameterlist => l_wf_parameter_list_t);
1870: wf_event.AddParameterToList ( p_name => 'BIRTH_DATE',
1871: p_value => p_birth_date,
1872: p_parameterlist => l_wf_parameter_list_t);
1873: wf_event.AddParameterToList ( p_name => 'SURNAME',

Line 1872: p_parameterlist => l_wf_parameter_list_t);

1868: p_value => p_gender,
1869: p_parameterlist => l_wf_parameter_list_t);
1870: wf_event.AddParameterToList ( p_name => 'BIRTH_DATE',
1871: p_value => p_birth_date,
1872: p_parameterlist => l_wf_parameter_list_t);
1873: wf_event.AddParameterToList ( p_name => 'SURNAME',
1874: p_value => p_last_name,
1875: p_parameterlist => l_wf_parameter_list_t);
1876: wf_event.AddParameterToList ( p_name => 'GIVEN_NAME',

Line 1875: p_parameterlist => l_wf_parameter_list_t);

1871: p_value => p_birth_date,
1872: p_parameterlist => l_wf_parameter_list_t);
1873: wf_event.AddParameterToList ( p_name => 'SURNAME',
1874: p_value => p_last_name,
1875: p_parameterlist => l_wf_parameter_list_t);
1876: wf_event.AddParameterToList ( p_name => 'GIVEN_NAME',
1877: p_value => p_first_name,
1878: p_parameterlist => l_wf_parameter_list_t);
1879: wf_event.AddParameterToList ( p_name => 'USER_EMAIL',

Line 1878: p_parameterlist => l_wf_parameter_list_t);

1874: p_value => p_last_name,
1875: p_parameterlist => l_wf_parameter_list_t);
1876: wf_event.AddParameterToList ( p_name => 'GIVEN_NAME',
1877: p_value => p_first_name,
1878: p_parameterlist => l_wf_parameter_list_t);
1879: wf_event.AddParameterToList ( p_name => 'USER_EMAIL',
1880: p_value => p_email_address,
1881: p_parameterlist => l_wf_parameter_list_t);
1882: wf_event.AddParameterToList ( p_name => 'ZIP_CODE',

Line 1881: p_parameterlist => l_wf_parameter_list_t);

1877: p_value => p_first_name,
1878: p_parameterlist => l_wf_parameter_list_t);
1879: wf_event.AddParameterToList ( p_name => 'USER_EMAIL',
1880: p_value => p_email_address,
1881: p_parameterlist => l_wf_parameter_list_t);
1882: wf_event.AddParameterToList ( p_name => 'ZIP_CODE',
1883: p_value => p_Zipcode,
1884: p_parameterlist => l_wf_parameter_list_t);
1885: wf_event.AddParameterToList ( p_name => 'PHONE_COUNTRY_CODE',

Line 1884: p_parameterlist => l_wf_parameter_list_t);

1880: p_value => p_email_address,
1881: p_parameterlist => l_wf_parameter_list_t);
1882: wf_event.AddParameterToList ( p_name => 'ZIP_CODE',
1883: p_value => p_Zipcode,
1884: p_parameterlist => l_wf_parameter_list_t);
1885: wf_event.AddParameterToList ( p_name => 'PHONE_COUNTRY_CODE',
1886: p_value => p_phoneCountry,
1887: p_parameterlist => l_wf_parameter_list_t);
1888: wf_event.AddParameterToList ( p_name => 'PHONE_AREA_CODE',

Line 1887: p_parameterlist => l_wf_parameter_list_t);

1883: p_value => p_Zipcode,
1884: p_parameterlist => l_wf_parameter_list_t);
1885: wf_event.AddParameterToList ( p_name => 'PHONE_COUNTRY_CODE',
1886: p_value => p_phoneCountry,
1887: p_parameterlist => l_wf_parameter_list_t);
1888: wf_event.AddParameterToList ( p_name => 'PHONE_AREA_CODE',
1889: p_value => p_phoneArea,
1890: p_parameterlist => l_wf_parameter_list_t);
1891: wf_event.AddParameterToList ( p_name => 'PHONE_NUMBER',

Line 1890: p_parameterlist => l_wf_parameter_list_t);

1886: p_value => p_phoneCountry,
1887: p_parameterlist => l_wf_parameter_list_t);
1888: wf_event.AddParameterToList ( p_name => 'PHONE_AREA_CODE',
1889: p_value => p_phoneArea,
1890: p_parameterlist => l_wf_parameter_list_t);
1891: wf_event.AddParameterToList ( p_name => 'PHONE_NUMBER',
1892: p_value => p_phoneNumber,
1893: p_parameterlist => l_wf_parameter_list_t);
1894: wf_event.AddParameterToList ( p_name => 'ADMIN_USERNAME',

Line 1893: p_parameterlist => l_wf_parameter_list_t);

1889: p_value => p_phoneArea,
1890: p_parameterlist => l_wf_parameter_list_t);
1891: wf_event.AddParameterToList ( p_name => 'PHONE_NUMBER',
1892: p_value => p_phoneNumber,
1893: p_parameterlist => l_wf_parameter_list_t);
1894: wf_event.AddParameterToList ( p_name => 'ADMIN_USERNAME',
1895: p_value => FND_PROFILE.VALUE('IGS_PE_USER_ADMIN'),
1896: p_parameterlist => l_wf_parameter_list_t);
1897:

Line 1896: p_parameterlist => l_wf_parameter_list_t);

1892: p_value => p_phoneNumber,
1893: p_parameterlist => l_wf_parameter_list_t);
1894: wf_event.AddParameterToList ( p_name => 'ADMIN_USERNAME',
1895: p_value => FND_PROFILE.VALUE('IGS_PE_USER_ADMIN'),
1896: p_parameterlist => l_wf_parameter_list_t);
1897:
1898: -- get the sequence value to be added to EVENT KEY to make it unique.
1899: OPEN c_seq_num;
1900: FETCH c_seq_num INTO ln_seq_val;

Line 1906: p_parameters => l_wf_parameter_list_t,

1902:
1903: wf_event.raise (
1904: p_event_name => 'oracle.apps.igs.pe.accountrequest.alumni_nomatch',
1905: p_event_key => ln_seq_val,
1906: p_parameters => l_wf_parameter_list_t,
1907: p_event_data => NULL
1908: );
1909:
1910: x_return_status := 'W';

Line 1966: l_parameter_list_t wf_parameter_list_t;

1962: l_exists VARCHAR2(1);
1963: l_alt_id_desc igs_pe_person_id_typ.description%TYPE;
1964:
1965: l_event_t wf_event_t;
1966: l_parameter_list_t wf_parameter_list_t;
1967: l_wf_name VARCHAR2(8) ;
1968: ln_seq_val NUMBER;
1969:
1970: BEGIN

Line 2079: l_parameter_list_t wf_parameter_list_t;

2075: FROM DUAL;
2076:
2077: ln_seq_val NUMBER;
2078: l_event_t wf_event_t;
2079: l_parameter_list_t wf_parameter_list_t;
2080:
2081: BEGIN
2082: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2083: l_label := 'igs.plsql.igs_pe_userid_pkg.auto_generate_username';