DBA Data[Home] [Help]

APPS.IGS_AS_PROD_DOC dependencies on WF_EVENT

Line 378: l_event_t wf_event_t;

374: CURSOR c_seq_num IS
375: SELECT igs_as_wf_beas008_s.NEXTVAL
376: FROM dual;
377: --
378: l_event_t wf_event_t;
379: l_parameter_list_t wf_parameter_list_t;
380: l_itemKey VARCHAR2(100);
381: ln_seq_val NUMBER;
382: l_role_name VARCHAR2(320);

Line 392: -- initialize the wf_event_t object

388: OPEN c_seq_num;
389: FETCH c_seq_num INTO ln_seq_val;
390: CLOSE c_seq_num;
391: --
392: -- initialize the wf_event_t object
393: --
394: wf_event_t.Initialize (l_event_t);
395: -- Create the adhoc role
396: l_role_name := 'IGSAS008' || ln_seq_val;

Line 394: wf_event_t.Initialize (l_event_t);

390: CLOSE c_seq_num;
391: --
392: -- initialize the wf_event_t object
393: --
394: wf_event_t.Initialize (l_event_t);
395: -- Create the adhoc role
396: l_role_name := 'IGSAS008' || ln_seq_val;
397: --
398: -- Create adhoc role

Line 420: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID', p_value => p_person_id, p_parameterlist => l_parameter_list_t);

416: END IF;
417: --
418: -- Add the parameters to the parameter list
419: --
420: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID', p_value => p_person_id, p_parameterlist => l_parameter_list_t);
421: wf_event.AddParameterToList ( p_name => 'IA_ORDER_NUMBER', p_value => p_order_number, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_NUMBER', p_value => p_item_number, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_TYPE', p_value => p_document_type, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_name => 'IA_RECIPIENT_NAME', p_value => p_recipient_name, p_parameterlist => l_parameter_list_t);

Line 421: wf_event.AddParameterToList ( p_name => 'IA_ORDER_NUMBER', p_value => p_order_number, p_parameterlist => l_parameter_list_t);

417: --
418: -- Add the parameters to the parameter list
419: --
420: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID', p_value => p_person_id, p_parameterlist => l_parameter_list_t);
421: wf_event.AddParameterToList ( p_name => 'IA_ORDER_NUMBER', p_value => p_order_number, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_NUMBER', p_value => p_item_number, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_TYPE', p_value => p_document_type, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_name => 'IA_RECIPIENT_NAME', p_value => p_recipient_name, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_name => 'IA_RECEIVING_INST_NAME', p_value => p_receiving_inst_name, p_parameterlist => l_parameter_list_t);

Line 422: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_NUMBER', p_value => p_item_number, p_parameterlist => l_parameter_list_t);

418: -- Add the parameters to the parameter list
419: --
420: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID', p_value => p_person_id, p_parameterlist => l_parameter_list_t);
421: wf_event.AddParameterToList ( p_name => 'IA_ORDER_NUMBER', p_value => p_order_number, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_NUMBER', p_value => p_item_number, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_TYPE', p_value => p_document_type, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_name => 'IA_RECIPIENT_NAME', p_value => p_recipient_name, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_name => 'IA_RECEIVING_INST_NAME', p_value => p_receiving_inst_name, p_parameterlist => l_parameter_list_t);
426: wf_event.AddParameterToList ( p_name => 'IA_DELIVERY_METHOD', p_value => p_delivery_method, p_parameterlist => l_parameter_list_t);

Line 423: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_TYPE', p_value => p_document_type, p_parameterlist => l_parameter_list_t);

419: --
420: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID', p_value => p_person_id, p_parameterlist => l_parameter_list_t);
421: wf_event.AddParameterToList ( p_name => 'IA_ORDER_NUMBER', p_value => p_order_number, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_NUMBER', p_value => p_item_number, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_TYPE', p_value => p_document_type, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_name => 'IA_RECIPIENT_NAME', p_value => p_recipient_name, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_name => 'IA_RECEIVING_INST_NAME', p_value => p_receiving_inst_name, p_parameterlist => l_parameter_list_t);
426: wf_event.AddParameterToList ( p_name => 'IA_DELIVERY_METHOD', p_value => p_delivery_method, p_parameterlist => l_parameter_list_t);
427: wf_event.AddParameterToList ( p_name => 'IA_FULFILLMENT_DATE_TIME', p_value => p_fulfillment_date_time, p_parameterlist => l_parameter_list_t);

Line 424: wf_event.AddParameterToList ( p_name => 'IA_RECIPIENT_NAME', p_value => p_recipient_name, p_parameterlist => l_parameter_list_t);

420: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID', p_value => p_person_id, p_parameterlist => l_parameter_list_t);
421: wf_event.AddParameterToList ( p_name => 'IA_ORDER_NUMBER', p_value => p_order_number, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_NUMBER', p_value => p_item_number, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_TYPE', p_value => p_document_type, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_name => 'IA_RECIPIENT_NAME', p_value => p_recipient_name, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_name => 'IA_RECEIVING_INST_NAME', p_value => p_receiving_inst_name, p_parameterlist => l_parameter_list_t);
426: wf_event.AddParameterToList ( p_name => 'IA_DELIVERY_METHOD', p_value => p_delivery_method, p_parameterlist => l_parameter_list_t);
427: wf_event.AddParameterToList ( p_name => 'IA_FULFILLMENT_DATE_TIME', p_value => p_fulfillment_date_time, p_parameterlist => l_parameter_list_t);
428: wf_event.AddParameterToList ( p_name => 'IA_ADHOCROLE', p_value => l_role_name, p_parameterlist => l_parameter_list_t);

Line 425: wf_event.AddParameterToList ( p_name => 'IA_RECEIVING_INST_NAME', p_value => p_receiving_inst_name, p_parameterlist => l_parameter_list_t);

421: wf_event.AddParameterToList ( p_name => 'IA_ORDER_NUMBER', p_value => p_order_number, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_NUMBER', p_value => p_item_number, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_TYPE', p_value => p_document_type, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_name => 'IA_RECIPIENT_NAME', p_value => p_recipient_name, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_name => 'IA_RECEIVING_INST_NAME', p_value => p_receiving_inst_name, p_parameterlist => l_parameter_list_t);
426: wf_event.AddParameterToList ( p_name => 'IA_DELIVERY_METHOD', p_value => p_delivery_method, p_parameterlist => l_parameter_list_t);
427: wf_event.AddParameterToList ( p_name => 'IA_FULFILLMENT_DATE_TIME', p_value => p_fulfillment_date_time, p_parameterlist => l_parameter_list_t);
428: wf_event.AddParameterToList ( p_name => 'IA_ADHOCROLE', p_value => l_role_name, p_parameterlist => l_parameter_list_t);
429: --

Line 426: wf_event.AddParameterToList ( p_name => 'IA_DELIVERY_METHOD', p_value => p_delivery_method, p_parameterlist => l_parameter_list_t);

422: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_NUMBER', p_value => p_item_number, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_TYPE', p_value => p_document_type, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_name => 'IA_RECIPIENT_NAME', p_value => p_recipient_name, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_name => 'IA_RECEIVING_INST_NAME', p_value => p_receiving_inst_name, p_parameterlist => l_parameter_list_t);
426: wf_event.AddParameterToList ( p_name => 'IA_DELIVERY_METHOD', p_value => p_delivery_method, p_parameterlist => l_parameter_list_t);
427: wf_event.AddParameterToList ( p_name => 'IA_FULFILLMENT_DATE_TIME', p_value => p_fulfillment_date_time, p_parameterlist => l_parameter_list_t);
428: wf_event.AddParameterToList ( p_name => 'IA_ADHOCROLE', p_value => l_role_name, p_parameterlist => l_parameter_list_t);
429: --
430: -- Raise the Event

Line 427: wf_event.AddParameterToList ( p_name => 'IA_FULFILLMENT_DATE_TIME', p_value => p_fulfillment_date_time, p_parameterlist => l_parameter_list_t);

423: wf_event.AddParameterToList ( p_name => 'IA_DOCUMENT_TYPE', p_value => p_document_type, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_name => 'IA_RECIPIENT_NAME', p_value => p_recipient_name, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_name => 'IA_RECEIVING_INST_NAME', p_value => p_receiving_inst_name, p_parameterlist => l_parameter_list_t);
426: wf_event.AddParameterToList ( p_name => 'IA_DELIVERY_METHOD', p_value => p_delivery_method, p_parameterlist => l_parameter_list_t);
427: wf_event.AddParameterToList ( p_name => 'IA_FULFILLMENT_DATE_TIME', p_value => p_fulfillment_date_time, p_parameterlist => l_parameter_list_t);
428: wf_event.AddParameterToList ( p_name => 'IA_ADHOCROLE', p_value => l_role_name, p_parameterlist => l_parameter_list_t);
429: --
430: -- Raise the Event
431: --

Line 428: wf_event.AddParameterToList ( p_name => 'IA_ADHOCROLE', p_value => l_role_name, p_parameterlist => l_parameter_list_t);

424: wf_event.AddParameterToList ( p_name => 'IA_RECIPIENT_NAME', p_value => p_recipient_name, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_name => 'IA_RECEIVING_INST_NAME', p_value => p_receiving_inst_name, p_parameterlist => l_parameter_list_t);
426: wf_event.AddParameterToList ( p_name => 'IA_DELIVERY_METHOD', p_value => p_delivery_method, p_parameterlist => l_parameter_list_t);
427: wf_event.AddParameterToList ( p_name => 'IA_FULFILLMENT_DATE_TIME', p_value => p_fulfillment_date_time, p_parameterlist => l_parameter_list_t);
428: wf_event.AddParameterToList ( p_name => 'IA_ADHOCROLE', p_value => l_role_name, p_parameterlist => l_parameter_list_t);
429: --
430: -- Raise the Event
431: --
432: wf_event.raise (

Line 432: wf_event.raise (

428: wf_event.AddParameterToList ( p_name => 'IA_ADHOCROLE', p_value => l_role_name, p_parameterlist => l_parameter_list_t);
429: --
430: -- Raise the Event
431: --
432: wf_event.raise (
433: p_event_name => 'oracle.apps.igs.as.orddoc.notstu',
434: p_event_key => 'AS008' || ln_seq_val,
435: p_parameters => l_parameter_list_t
436: );