3525: l_send_syct_event VARCHAR2(100);
3526: l_create_cln_event VARCHAR2(100);
3527: l_event_key VARCHAR2(100);
3528: l_syncctlg_seq NUMBER;
3529: l_send_syct_parameter_list wf_parameter_list_t;
3530: l_create_cln_parameter_list wf_parameter_list_t;
3531: l_operating_unit_id NUMBER;
3532: l_inv_org_id NUMBER;
3533: l_date DATE;
3526: l_create_cln_event VARCHAR2(100);
3527: l_event_key VARCHAR2(100);
3528: l_syncctlg_seq NUMBER;
3529: l_send_syct_parameter_list wf_parameter_list_t;
3530: l_create_cln_parameter_list wf_parameter_list_t;
3531: l_operating_unit_id NUMBER;
3532: l_inv_org_id NUMBER;
3533: l_date DATE;
3534: l_canonical_date VARCHAR2(100);
3567: --transaction_type := 'CLN';
3568: --transaction_subtype := 'SYNCCTLGO';
3569: --l_send_syct_event := 'oracle.apps.cln.event.syncctlg';
3570:
3571: l_send_syct_parameter_list := wf_parameter_list_t();
3572: l_create_cln_parameter_list := wf_parameter_list_t();
3573:
3574: counter := 1;
3575: msgs_sent_flag := FALSE;
3568: --transaction_subtype := 'SYNCCTLGO';
3569: --l_send_syct_event := 'oracle.apps.cln.event.syncctlg';
3570:
3571: l_send_syct_parameter_list := wf_parameter_list_t();
3572: l_create_cln_parameter_list := wf_parameter_list_t();
3573:
3574: counter := 1;
3575: msgs_sent_flag := FALSE;
3576: