DBA Data[Home] [Help]

APPS.FTE_TENDER_PVT dependencies on WF_ENGINE

Line 213: wf_engine.CompleteActivity(

209:
210:
211: IF (x_current_status = G_TENDER_NOTIFIED) THEN
212:
213: wf_engine.CompleteActivity(
214: itemtype => 'FTETEREQ',
215: itemkey => p_item_key,
216: activity => 'TENDER_REQUEST_PROCESS:TENDER_REQUEST_NTF',
217: result => p_completion_status);

Line 445: l_mode_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'MODE_OF_TRANSPORT');

441: p_value => FTE_TENDER_PVT.S_ACCEPTED,
442: p_parameterlist => l_parameter_list);
443:
444: --Rel 12 Changes for Freight Class
445: l_mode_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'MODE_OF_TRANSPORT');
446:
447: wf_event.AddParameterToList(p_name => 'MODE_OF_TRANSPORT',
448: p_value => l_mode_transport,
449: p_parameterlist => l_parameter_list);

Line 561: l_shipper_name := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'SHIPPER_NAME');

557:
558: -------------------------------------------------------------------------------------
559: -- Samuthuk [ workflow Notifications std ]
560: -------------------------------------------------------------------------------------
561: l_shipper_name := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'SHIPPER_NAME');
562: l_response_url := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'RESPONSE_URL');
563:
564: -- Rel 12
565: l_carrier_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_ID');

Line 562: l_response_url := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'RESPONSE_URL');

558: -------------------------------------------------------------------------------------
559: -- Samuthuk [ workflow Notifications std ]
560: -------------------------------------------------------------------------------------
561: l_shipper_name := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'SHIPPER_NAME');
562: l_response_url := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'RESPONSE_URL');
563:
564: -- Rel 12
565: l_carrier_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_ID');
566: l_carrier_site_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_SITE_ID');

Line 565: l_carrier_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_ID');

561: l_shipper_name := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'SHIPPER_NAME');
562: l_response_url := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'RESPONSE_URL');
563:
564: -- Rel 12
565: l_carrier_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_ID');
566: l_carrier_site_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_SITE_ID');
567: l_notif_type := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'NOTIF_TYPE');
568: l_trip_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'TRIP_ID');
569: l_rank_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_ID');

Line 566: l_carrier_site_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_SITE_ID');

562: l_response_url := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'RESPONSE_URL');
563:
564: -- Rel 12
565: l_carrier_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_ID');
566: l_carrier_site_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_SITE_ID');
567: l_notif_type := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'NOTIF_TYPE');
568: l_trip_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'TRIP_ID');
569: l_rank_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_ID');
570: l_rank_version := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_VERSION');

Line 567: l_notif_type := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'NOTIF_TYPE');

563:
564: -- Rel 12
565: l_carrier_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_ID');
566: l_carrier_site_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_SITE_ID');
567: l_notif_type := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'NOTIF_TYPE');
568: l_trip_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'TRIP_ID');
569: l_rank_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_ID');
570: l_rank_version := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_VERSION');
571: l_tender_status := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'TENDER_STATUS');

Line 568: l_trip_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'TRIP_ID');

564: -- Rel 12
565: l_carrier_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_ID');
566: l_carrier_site_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_SITE_ID');
567: l_notif_type := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'NOTIF_TYPE');
568: l_trip_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'TRIP_ID');
569: l_rank_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_ID');
570: l_rank_version := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_VERSION');
571: l_tender_status := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'TENDER_STATUS');
572: l_shipper_user_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key,'SHIPPER_USER_ID');

Line 569: l_rank_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_ID');

565: l_carrier_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_ID');
566: l_carrier_site_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_SITE_ID');
567: l_notif_type := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'NOTIF_TYPE');
568: l_trip_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'TRIP_ID');
569: l_rank_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_ID');
570: l_rank_version := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_VERSION');
571: l_tender_status := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'TENDER_STATUS');
572: l_shipper_user_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key,'SHIPPER_USER_ID');
573: l_mode_of_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key,'MODE_OF_TRANSPORT');

Line 570: l_rank_version := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_VERSION');

566: l_carrier_site_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'CARRIER_SITE_ID');
567: l_notif_type := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'NOTIF_TYPE');
568: l_trip_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'TRIP_ID');
569: l_rank_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_ID');
570: l_rank_version := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_VERSION');
571: l_tender_status := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'TENDER_STATUS');
572: l_shipper_user_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key,'SHIPPER_USER_ID');
573: l_mode_of_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key,'MODE_OF_TRANSPORT');
574:

Line 571: l_tender_status := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'TENDER_STATUS');

567: l_notif_type := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'NOTIF_TYPE');
568: l_trip_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'TRIP_ID');
569: l_rank_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_ID');
570: l_rank_version := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_VERSION');
571: l_tender_status := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'TENDER_STATUS');
572: l_shipper_user_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key,'SHIPPER_USER_ID');
573: l_mode_of_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key,'MODE_OF_TRANSPORT');
574:
575: --------------------------------------------------------------------------------------

Line 572: l_shipper_user_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key,'SHIPPER_USER_ID');

568: l_trip_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'TRIP_ID');
569: l_rank_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_ID');
570: l_rank_version := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_VERSION');
571: l_tender_status := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'TENDER_STATUS');
572: l_shipper_user_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key,'SHIPPER_USER_ID');
573: l_mode_of_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key,'MODE_OF_TRANSPORT');
574:
575: --------------------------------------------------------------------------------------
576:

Line 573: l_mode_of_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key,'MODE_OF_TRANSPORT');

569: l_rank_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_ID');
570: l_rank_version := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key, 'RANK_VERSION');
571: l_tender_status := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'TENDER_STATUS');
572: l_shipper_user_id := wf_engine.GetItemAttrNumber('FTETEREQ', p_item_key,'SHIPPER_USER_ID');
573: l_mode_of_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key,'MODE_OF_TRANSPORT');
574:
575: --------------------------------------------------------------------------------------
576:
577:

Line 770: l_mode_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'MODE_OF_TRANSPORT');

766: p_value => FTE_TENDER_PVT.S_REJECTED,
767: p_parameterlist => l_parameter_list);
768:
769: --Rel 12 Changes for Freight Class
770: l_mode_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'MODE_OF_TRANSPORT');
771: wf_event.AddParameterToList(p_name => 'MODE_OF_TRANSPORT',
772: p_value => l_mode_transport,
773: p_parameterlist => l_parameter_list);
774:

Line 4287: l_notif_type := wf_engine.GetItemAttrText('FTETEREQ',

4283: l_number_of_warnings := 0;
4284: l_number_of_errors := 0;
4285:
4286:
4287: l_notif_type := wf_engine.GetItemAttrText('FTETEREQ',
4288: p_trip_info.wf_item_key, 'NOTIF_TYPE');
4289:
4290: -- Set response source
4291:

Line 4293: wf_engine.SetItemAttrText('FTETEREQ',p_trip_info.wf_item_key,

4289:
4290: -- Set response source
4291:
4292:
4293: wf_engine.SetItemAttrText('FTETEREQ',p_trip_info.wf_item_key,
4294: 'RESPONSE_SOURCE',p_trip_info.response_source);
4295:
4296: IF (l_notif_type = 'XML') THEN
4297: --{ release tender block

Line 4307: wf_engine.CompleteActivity(

4303: x_return_status => l_result_code);
4304:
4305: IF (l_result_code = G_TENDER_NOTIFIED) THEN
4306:
4307: wf_engine.CompleteActivity(
4308: itemtype => 'FTETEREQ',
4309: itemkey => p_trip_info.wf_item_key,
4310: activity => 'TENDER_REQUEST_PROCESS:TENDER_REQUEST_BLOCK',
4311: result => 'null');

Line 4328: wf_engine.CompleteActivity(

4324:
4325: IF (l_result_code = G_TENDER_NOTIFIED) THEN
4326:
4327: IF (p_trip_info.tender_status = FTE_TENDER_PVT.S_ACCEPTED) THEN
4328: wf_engine.CompleteActivity(
4329: itemtype => 'FTETEREQ',
4330: itemkey => p_trip_info.wf_item_key,
4331: activity => 'TENDER_REQUEST_PROCESS:TENDER_REQUEST_NTF',
4332: result => G_TENDER_APPROVED);

Line 4334: wf_engine.CompleteActivity(

4330: itemkey => p_trip_info.wf_item_key,
4331: activity => 'TENDER_REQUEST_PROCESS:TENDER_REQUEST_NTF',
4332: result => G_TENDER_APPROVED);
4333: ELSIF (p_trip_info.tender_status = FTE_TENDER_PVT.S_REJECTED) THEN
4334: wf_engine.CompleteActivity(
4335: itemtype => 'FTETEREQ',
4336: itemkey => p_trip_info.wf_item_key,
4337: activity => 'TENDER_REQUEST_PROCESS:TENDER_REQUEST_NTF',
4338: result => G_TENDER_REJECTED);

Line 4341: wf_engine.CompleteActivity(

4337: activity => 'TENDER_REQUEST_PROCESS:TENDER_REQUEST_NTF',
4338: result => G_TENDER_REJECTED);
4339: ELSE
4340: -- This is for cancel scenario
4341: wf_engine.CompleteActivity(
4342: itemtype => 'FTETEREQ',
4343: itemkey => p_trip_info.wf_item_key,
4344: activity => 'TENDER_REQUEST_PROCESS:TENDER_REQUEST_NTF',
4345: result => G_TENDER_ABORT);

Line 4580: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',

4576: p_parameterlist => l_parameter_list);
4577:
4578:
4579: wf_event.AddParameterToList(p_name=> 'USER_ID',
4580: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4581: p_trip_info.wf_item_key,'USER_ID'),
4582: p_parameterlist=>l_parameter_list);
4583:
4584:

Line 4586: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',

4582: p_parameterlist=>l_parameter_list);
4583:
4584:
4585: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',
4586: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4587: p_trip_info.wf_item_key,'RESPONSIBILITY_ID'),
4588: p_parameterlist=>l_parameter_list);
4589:
4590: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',

Line 4591: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',

4587: p_trip_info.wf_item_key,'RESPONSIBILITY_ID'),
4588: p_parameterlist=>l_parameter_list);
4589:
4590: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',
4591: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4592: p_trip_info.wf_item_key,'RESP_APPL_ID'),
4593: p_parameterlist=>l_parameter_list);
4594:
4595:

Line 4854: p_value=> wf_engine.GetItemAttrText('FTETEREQ',

4850: p_parameterlist => l_parameter_list);
4851:
4852:
4853: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
4854: p_value=> wf_engine.GetItemAttrText('FTETEREQ',
4855: p_trip_info.wf_item_key,'SHIPPER_NAME'),
4856: p_parameterlist=>l_parameter_list);
4857:
4858: wf_event.AddParameterToList(p_name=> 'SHIPPER_USER_ID',

Line 4859: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',

4855: p_trip_info.wf_item_key,'SHIPPER_NAME'),
4856: p_parameterlist=>l_parameter_list);
4857:
4858: wf_event.AddParameterToList(p_name=> 'SHIPPER_USER_ID',
4859: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4860: p_trip_info.wf_item_key,'USER_ID'),
4861: p_parameterlist=>l_parameter_list);
4862:
4863: wf_event.AddParameterToList(p_name => 'CONTACT_PERFORMER',

Line 4864: p_value => wf_engine.getItemAttrText(

4860: p_trip_info.wf_item_key,'USER_ID'),
4861: p_parameterlist=>l_parameter_list);
4862:
4863: wf_event.AddParameterToList(p_name => 'CONTACT_PERFORMER',
4864: p_value => wf_engine.getItemAttrText(
4865: 'FTETEREQ', p_trip_info.wf_item_key,
4866: 'CONTACT_PERFORMER'),
4867: p_parameterlist => l_parameter_list);
4868:

Line 4870: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',

4866: 'CONTACT_PERFORMER'),
4867: p_parameterlist => l_parameter_list);
4868:
4869: wf_event.AddParameterToList(p_name=> 'USER_ID',
4870: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4871: p_trip_info.wf_item_key,'USER_ID'),
4872: p_parameterlist=>l_parameter_list);
4873:
4874:

Line 4876: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',

4872: p_parameterlist=>l_parameter_list);
4873:
4874:
4875: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',
4876: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4877: p_trip_info.wf_item_key,'RESPONSIBILITY_ID'),
4878: p_parameterlist=>l_parameter_list);
4879:
4880: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',

Line 4881: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',

4877: p_trip_info.wf_item_key,'RESPONSIBILITY_ID'),
4878: p_parameterlist=>l_parameter_list);
4879:
4880: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',
4881: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4882: p_trip_info.wf_item_key,'RESP_APPL_ID'),
4883: p_parameterlist=>l_parameter_list);
4884:
4885:

Line 5012: p_value => wf_engine.GetItemAttrText('FTETEREQ',

5008: l_item_key := p_trip_info.WF_ITEM_KEY;
5009:
5010:
5011: wf_event.AddParameterToList( p_name => 'MBOL_NUM',
5012: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5013: l_item_key,'MBOL_NUM'),
5014: p_parameterlist => l_parameter_list);
5015:
5016: wf_event.AddParameterToList( p_name => 'TENDER_TEXT_ID',

Line 5017: p_value => wf_engine.GetItemAttrText('FTETEREQ',

5013: l_item_key,'MBOL_NUM'),
5014: p_parameterlist => l_parameter_list);
5015:
5016: wf_event.AddParameterToList( p_name => 'TENDER_TEXT_ID',
5017: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5018: l_item_key,'TENDER_TEXT_ID'),
5019: p_parameterlist => l_parameter_list);
5020:
5021:

Line 5023: p_value => wf_engine.GetItemAttrDate('FTETEREQ',

5019: p_parameterlist => l_parameter_list);
5020:
5021:
5022: wf_event.AddParameterToList( p_name => 'RESPOND_BY_DATE',
5023: p_value => wf_engine.GetItemAttrDate('FTETEREQ',
5024: l_item_key,'RESPOND_BY_DATE'),
5025: p_parameterlist => l_parameter_list);
5026:
5027: wf_event.AddParameterToList( p_name => 'TENDERED_DATE',

Line 5028: p_value => wf_engine.GetItemAttrDate('FTETEREQ',

5024: l_item_key,'RESPOND_BY_DATE'),
5025: p_parameterlist => l_parameter_list);
5026:
5027: wf_event.AddParameterToList( p_name => 'TENDERED_DATE',
5028: p_value => wf_engine.GetItemAttrDate('FTETEREQ',
5029: l_item_key,'TENDERED_DATE'),
5030: p_parameterlist => l_parameter_list);
5031:
5032: wf_event.AddParameterToList( p_name => 'MODE_OF_TRANSPORT',

Line 5033: p_value => wf_engine.GetItemAttrText('FTETEREQ',

5029: l_item_key,'TENDERED_DATE'),
5030: p_parameterlist => l_parameter_list);
5031:
5032: wf_event.AddParameterToList( p_name => 'MODE_OF_TRANSPORT',
5033: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5034: l_item_key,'MODE_OF_TRANSPORT'),
5035: p_parameterlist => l_parameter_list);
5036:
5037: wf_event.AddParameterToList( p_name => 'SHIPPER_WAIT_TIME',

Line 5038: p_value => wf_engine.GetItemAttrText('FTETEREQ',

5034: l_item_key,'MODE_OF_TRANSPORT'),
5035: p_parameterlist => l_parameter_list);
5036:
5037: wf_event.AddParameterToList( p_name => 'SHIPPER_WAIT_TIME',
5038: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5039: l_item_key,'SHIPPER_WAIT_TIME'),
5040: p_parameterlist => l_parameter_list);
5041:
5042:

Line 5044: p_value => wf_engine.GetItemAttrText('FTETEREQ',

5040: p_parameterlist => l_parameter_list);
5041:
5042:
5043: wf_event.AddParameterToList( p_name => 'SHIPPING_ORG_NAME',
5044: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5045: l_item_key,'SHIPPING_ORG_NAME'),
5046: p_parameterlist => l_parameter_list);
5047:
5048: wf_event.AddParameterToList( p_name => 'TENDER_ID',

Line 5049: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',

5045: l_item_key,'SHIPPING_ORG_NAME'),
5046: p_parameterlist => l_parameter_list);
5047:
5048: wf_event.AddParameterToList( p_name => 'TENDER_ID',
5049: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5050: l_item_key,'TENDER_ID'),
5051: p_parameterlist => l_parameter_list);
5052:
5053: wf_event.AddParameterToList( p_name => 'SHIPPER_NAME',

Line 5054: p_value => wf_engine.GetItemAttrText('FTETEREQ',

5050: l_item_key,'TENDER_ID'),
5051: p_parameterlist => l_parameter_list);
5052:
5053: wf_event.AddParameterToList( p_name => 'SHIPPER_NAME',
5054: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5055: l_item_key,'SHIPPER_NAME'),
5056: p_parameterlist => l_parameter_list);
5057:
5058: wf_event.AddParameterToList( p_name => 'CONTACT_PERFORMER',

Line 5059: p_value => wf_engine.GetItemAttrText('FTETEREQ',

5055: l_item_key,'SHIPPER_NAME'),
5056: p_parameterlist => l_parameter_list);
5057:
5058: wf_event.AddParameterToList( p_name => 'CONTACT_PERFORMER',
5059: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5060: l_item_key,'CONTACT_PERFORMER'),
5061: p_parameterlist => l_parameter_list);
5062:
5063: wf_event.AddParameterToList( p_name => 'CARRIER_ID',

Line 5064: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',

5060: l_item_key,'CONTACT_PERFORMER'),
5061: p_parameterlist => l_parameter_list);
5062:
5063: wf_event.AddParameterToList( p_name => 'CARRIER_ID',
5064: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5065: l_item_key,'CARRIER_ID'),
5066: p_parameterlist => l_parameter_list);
5067:
5068: wf_event.AddParameterToList( p_name => 'CARRIER_SITE_ID',

Line 5069: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',

5065: l_item_key,'CARRIER_ID'),
5066: p_parameterlist => l_parameter_list);
5067:
5068: wf_event.AddParameterToList( p_name => 'CARRIER_SITE_ID',
5069: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5070: l_item_key,'CARRIER_SITE_ID'),
5071: p_parameterlist => l_parameter_list);
5072:
5073: wf_event.AddParameterToList( p_name => 'RESPONSE_URL',

Line 5074: p_value => wf_engine.GetItemAttrText('FTETEREQ',

5070: l_item_key,'CARRIER_SITE_ID'),
5071: p_parameterlist => l_parameter_list);
5072:
5073: wf_event.AddParameterToList( p_name => 'RESPONSE_URL',
5074: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5075: l_item_key,'RESPONSE_URL'),
5076: p_parameterlist => l_parameter_list);
5077:
5078: wf_event.AddParameterToList( p_name => 'NOTIF_TYPE',

Line 5079: p_value => wf_engine.GetItemAttrText('FTETEREQ',

5075: l_item_key,'RESPONSE_URL'),
5076: p_parameterlist => l_parameter_list);
5077:
5078: wf_event.AddParameterToList( p_name => 'NOTIF_TYPE',
5079: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5080: l_item_key,'NOTIF_TYPE'),
5081: p_parameterlist => l_parameter_list);
5082:
5083: wf_event.AddParameterToList( p_name => 'TRIP_ID',

Line 5084: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',

5080: l_item_key,'NOTIF_TYPE'),
5081: p_parameterlist => l_parameter_list);
5082:
5083: wf_event.AddParameterToList( p_name => 'TRIP_ID',
5084: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5085: l_item_key,'TRIP_ID'),
5086: p_parameterlist => l_parameter_list);
5087:
5088: wf_event.AddParameterToList( p_name => 'SHIPPER_USER_ID',

Line 5089: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',

5085: l_item_key,'TRIP_ID'),
5086: p_parameterlist => l_parameter_list);
5087:
5088: wf_event.AddParameterToList( p_name => 'SHIPPER_USER_ID',
5089: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5090: l_item_key,'SHIPPER_USER_ID'),
5091: p_parameterlist => l_parameter_list);
5092:
5093: wf_event.AddParameterToList(p_name=> 'USER_ID',

Line 5094: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',

5090: l_item_key,'SHIPPER_USER_ID'),
5091: p_parameterlist => l_parameter_list);
5092:
5093: wf_event.AddParameterToList(p_name=> 'USER_ID',
5094: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
5095: l_item_key,'USER_ID'),
5096: p_parameterlist=>l_parameter_list);
5097:
5098:

Line 5100: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',

5096: p_parameterlist=>l_parameter_list);
5097:
5098:
5099: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',
5100: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
5101: l_item_key,'RESPONSIBILITY_ID'),
5102: p_parameterlist=>l_parameter_list);
5103:
5104: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',

Line 5105: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',

5101: l_item_key,'RESPONSIBILITY_ID'),
5102: p_parameterlist=>l_parameter_list);
5103:
5104: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',
5105: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
5106: l_item_key,'RESP_APPL_ID'),
5107: p_parameterlist=>l_parameter_list);
5108:
5109: