DBA Data[Home] [Help]

APPS.IGS_PE_WF_GEN dependencies on WF_EVENT_T

Line 49: l_event_t wf_event_t;

45: CURSOR c_seq_num IS
46: SELECT IGS_PE_PE003_WF_S.nextval
47: FROM DUAL;
48: ln_seq_val NUMBER;
49: l_event_t wf_event_t;
50: l_parameter_list_t wf_parameter_list_t;
51: BEGIN
52:
53: -- initialize the parameter list.

Line 54: wf_event_t.Initialize(l_event_t);

50: l_parameter_list_t wf_parameter_list_t;
51: BEGIN
52:
53: -- initialize the parameter list.
54: wf_event_t.Initialize(l_event_t);
55:
56: -- set the parameters.
57: wf_event.AddParameterToList ( p_name => 'RES_DTLS_ID', p_value => p_resident_details_id, p_parameterlist => l_parameter_list_t);
58: wf_event.AddParameterToList ( p_name => 'OLD_RES_STATUS', p_value => p_old_res_status, p_parameterlist => l_parameter_list_t);

Line 920: l_event_t wf_event_t;

916: CURSOR c_seq_num IS
917: SELECT IGS_PE_CHG_HOUSING_STAT_S.nextval
918: FROM DUAL;
919: ln_seq_val NUMBER;
920: l_event_t wf_event_t;
921: l_parameter_list_t wf_parameter_list_t;
922: BEGIN
923:
924: -- initialize the parameter list.

Line 925: wf_event_t.Initialize(l_event_t);

921: l_parameter_list_t wf_parameter_list_t;
922: BEGIN
923:
924: -- initialize the parameter list.
925: wf_event_t.Initialize(l_event_t);
926:
927: -- set the parameters.
928: wf_event.AddParameterToList ( p_name => 'PERSON_ID' , p_value => p_person_id , p_parameterlist => l_parameter_list_t);
929: wf_event.AddParameterToList ( p_name => 'HOUSING_STATUS' , p_value => p_housing_status , p_parameterlist => l_parameter_list_t);

Line 1074: i_event wf_event_t;

1070: TYPE person_id IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
1071: person_id_tbl person_id;
1072: l_n_cntr NUMBER;
1073:
1074: i_event wf_event_t;
1075: l_clob_data CLOB;
1076: l_c_per_org VARCHAR2(1);
1077:
1078: PROCEDURE populate_table (p_c_person_str VARCHAR2) IS

Line 1205: l_wf_event_t WF_EVENT_T;

1201: SELECT IGS_PE_PE002_WF_S.NEXTVAL
1202: FROM DUAL;
1203: l_n_key NUMBER;
1204:
1205: l_wf_event_t WF_EVENT_T;
1206: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
1207: l_eventdata CLOB;
1208: l_str VARCHAR2(32767);
1209:

Line 1220: WF_EVENT_T.Initialize(l_wf_event_t);

1216: BEGIN
1217:
1218: IF p_persons_processes.EXISTS(1) THEN
1219:
1220: WF_EVENT_T.Initialize(l_wf_event_t);
1221: --
1222: -- set the event name
1223: --
1224: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pe.addr_bulk_sync');

Line 1224: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pe.addr_bulk_sync');

1220: WF_EVENT_T.Initialize(l_wf_event_t);
1221: --
1222: -- set the event name
1223: --
1224: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pe.addr_bulk_sync');
1225: --
1226: -- event key to identify uniquely
1227: --
1228: OPEN c_seq;

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

1231: --
1232: --
1233: -- set the parameter list
1234: --
1235: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
1236: --
1237: OPEN cur_inst_per(p_persons_processes(1));
1238: FETCH cur_inst_per INTO l_c_per_org;
1239: CLOSE cur_inst_per;

Line 1300: l_event_t wf_event_t;

1296: Who When What
1297: vskumar 23-May-2006 bug 5211157 forward port the procedure from bug 2882588.
1298: ******************************************************************/
1299:
1300: l_event_t wf_event_t;
1301: l_parameter_list_t wf_parameter_list_t;
1302: BEGIN
1303:
1304: -- initialize the parameter list.

Line 1305: wf_event_t.Initialize(l_event_t);

1301: l_parameter_list_t wf_parameter_list_t;
1302: BEGIN
1303:
1304: -- initialize the parameter list.
1305: wf_event_t.Initialize(l_event_t);
1306:
1307: -- set the parameters.
1308: wf_event.AddParameterToList ( p_name => 'P_PERSON_ID', p_value => p_person_id, p_parameterlist => l_parameter_list_t);
1309: wf_event.AddParameterToList ( p_Name => 'P_CAL_TYPE', p_Value => P_CAL_TYPE, p_ParameterList => l_parameter_list_t);