DBA Data[Home] [Help]

APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on WF_ENGINE

Line 3749: l_notif_type := wf_engine.GetItemAttrText(

3745:
3746: IF ( funcmode = 'RUN' ) THEN
3747:
3748: /* Get the notification type from the workflow Itemtype 'PVXNUTIL' */
3749: l_notif_type := wf_engine.GetItemAttrText(
3750: ITEMTYPE => l_itemtype,
3751: ITEMKEY => l_itemkey,
3752: ANAME => 'NOTIFICATION_TYPE' );
3753:

Line 3755: l_wait_in_days := wf_engine.GetItemAttrNumber(

3751: ITEMKEY => l_itemkey,
3752: ANAME => 'NOTIFICATION_TYPE' );
3753:
3754: /* Get wait in Days, applicable for any type of notification. */
3755: l_wait_in_days := wf_engine.GetItemAttrNumber(
3756: ITEMTYPE => l_itemtype,
3757: ITEMKEY => l_itemkey,
3758: ANAME => 'WAIT_PERIOD_IN_DAYS' );
3759:

Line 3764: l_mbrship_id := wf_engine.GetItemAttrNumber(

3760: /* Check for Notification Type. It may be 'PG_MEM_EXP' or 'PG_CONTRCT_NRCVD' */
3761: IF (l_notif_type = 'PG_MEM_EXP' ) THEN
3762:
3763: /* Get the membership Id from the workflow Itemtype 'PVXNUTIL' */
3764: l_mbrship_id := wf_engine.GetItemAttrNumber(
3765: ITEMTYPE => l_itemtype,
3766: ITEMKEY => l_itemkey,
3767: ANAME => 'MEMBERSHIP_ID' );
3768:

Line 3791: l_enrl_req_id := wf_engine.GetItemAttrNumber(

3787:
3788:
3789: ELSIF (l_notif_type = 'PG_CONTRCT_NRCVD' ) THEN
3790: /* Get the Enrollment Request Id from the workflow Itemtype 'PVXNUTIL' */
3791: l_enrl_req_id := wf_engine.GetItemAttrNumber(
3792: ITEMTYPE => l_itemtype,
3793: ITEMKEY => l_itemkey,
3794: ANAME => 'ENROLLMENT_REQUEST_ID' );
3795:

Line 3895: l_wait_in_days := wf_engine.GetItemAttrText(

3891:
3892: IF ( funcmode = 'RUN' ) THEN
3893:
3894: /* Get the WAIT_PERIOD_IN_DAYS attribute from the workflow Itemtype 'PVXNUTIL' */
3895: l_wait_in_days := wf_engine.GetItemAttrText(
3896: ITEMTYPE => l_itemtype,
3897: ITEMKEY => l_itemkey,
3898: ANAME => 'WAIT_PERIOD_IN_DAYS' );
3899: /* Check for WAIT_PERIOD_IN_DAYS */

Line 3903: l_notif_type := wf_engine.GetItemAttrText(

3899: /* Check for WAIT_PERIOD_IN_DAYS */
3900: IF ( l_wait_in_days > 0)
3901: THEN
3902: /* Get the notification type from the workflow Itemtype 'PVXNUTIL' */
3903: l_notif_type := wf_engine.GetItemAttrText(
3904: ITEMTYPE => l_itemtype,
3905: ITEMKEY => l_itemkey,
3906: ANAME => 'NOTIFICATION_TYPE' );
3907:

Line 3911: l_mbrship_id := wf_engine.GetItemAttrNumber(

3907:
3908: /* Check for Notification Type. It may be 'PG_MEM_EXP' or 'PG_CONTRCT_NRCVD' */
3909: IF (l_notif_type = 'PG_MEM_EXP' ) THEN
3910: /* Get the membership Id from the workflow Itemtype 'PVXNUTIL' */
3911: l_mbrship_id := wf_engine.GetItemAttrNumber(
3912: ITEMTYPE => l_itemtype,
3913: ITEMKEY => l_itemkey,
3914: ANAME => 'MEMBERSHIP_ID' );
3915:

Line 3920: l_end_date:= wf_engine.GetItemAttrDate(

3916: OPEN c_Check_Memexp_Rmdr_Flg(l_mbrship_id);
3917: FETCH c_Check_Memexp_Rmdr_Flg INTO l_rmdr_flag;
3918:
3919: IF ( l_rmdr_flag = 'Y' ) THEN
3920: l_end_date:= wf_engine.GetItemAttrDate(
3921: ITEMTYPE => l_itemtype,
3922: ITEMKEY => l_itemkey,
3923: ANAME => 'END_DATE' );
3924: --l_date_format := 'DD-MON-YYYY';

Line 3929: wf_engine.setItemAttrText

3925: l_expiry_days := to_number(trunc( fnd_date.displaydate_to_date( l_end_date ) - fnd_date.displaydate_to_date( sysdate )));
3926: IF l_expiry_days <0 THEN
3927: l_expiry_days := 0;
3928: END IF;
3929: wf_engine.setItemAttrText
3930: (
3931: ITEMTYPE => l_itemtype
3932: , ITEMKEY => l_itemkey
3933: , ANAME => 'MBRSHIP_EXPIRY_IN_DAYS'

Line 3943: l_enrl_req_id := wf_engine.GetItemAttrNumber(

3939: END IF; /* End if for l_rmdr_flag check */
3940:
3941: ELSIF (l_notif_type = 'PG_CONTRCT_NRCVD' ) THEN
3942: /* Get the Enrollment Request Id from the workflow Itemtype 'PVXNUTIL' */
3943: l_enrl_req_id := wf_engine.GetItemAttrNumber(
3944: ITEMTYPE => l_itemtype,
3945: ITEMKEY => l_itemkey,
3946: ANAME => 'ENROLLMENT_REQUEST_ID' );
3947:

Line 4609: l_event_code := WF_ENGINE.GetItemAttrText (

4605: l_api_name CONSTANT VARCHAR2(30) := 'SET_EVENT_CODE';
4606: l_event_code VARCHAR2(30) ;
4607: BEGIN
4608:
4609: l_event_code := WF_ENGINE.GetItemAttrText (
4610: itemtype => itemtype
4611: , itemkey => itemkey
4612: , aname => 'PARTNER_EVENT_CODE'
4613: );

Line 4706: l_notification_id := wf_engine.context_nid;

4702: x_msg_data VARCHAR2(4000);
4703:
4704: BEGIN
4705:
4706: l_notification_id := wf_engine.context_nid;
4707:
4708: IF (PV_DEBUG_HIGH_ON) THEN
4709: PVX_UTILITY_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);
4710: END IF;

Line 4714: l_event_code := WF_ENGINE.GetItemAttrText

4710: END IF;
4711:
4712:
4713:
4714: l_event_code := WF_ENGINE.GetItemAttrText
4715: (
4716: itemtype => itemtype
4717: , itemkey => itemkey
4718: , aname => 'PARTNER_EVENT_CODE'

Line 4721: l_partner_id := WF_ENGINE.GetItemAttrText

4717: , itemkey => itemkey
4718: , aname => 'PARTNER_EVENT_CODE'
4719: );
4720:
4721: l_partner_id := WF_ENGINE.GetItemAttrText
4722: (
4723: itemtype => itemtype
4724: , itemkey => itemkey
4725: , aname => 'PARTNER_ID'

Line 4728: l_user_id := WF_ENGINE.GetItemAttrText

4724: , itemkey => itemkey
4725: , aname => 'PARTNER_ID'
4726: );
4727:
4728: l_user_id := WF_ENGINE.GetItemAttrText
4729: (
4730: itemtype => itemtype
4731: , itemkey => itemkey
4732: , aname => 'RECIPIENT_USER_ID'

Line 4735: l_entity_code := WF_ENGINE.GetItemAttrText

4731: , itemkey => itemkey
4732: , aname => 'RECIPIENT_USER_ID'
4733: );
4734:
4735: l_entity_code := WF_ENGINE.GetItemAttrText
4736: (
4737: itemtype => itemtype
4738: , itemkey => itemkey
4739: , aname => 'ENTITY_CODE'

Line 4742: l_entity_id := WF_ENGINE.GetItemAttrNumber

4738: , itemkey => itemkey
4739: , aname => 'ENTITY_CODE'
4740: );
4741:
4742: l_entity_id := WF_ENGINE.GetItemAttrNumber
4743: (
4744: itemtype => itemtype
4745: , itemkey => itemkey
4746: , aname => 'ENTITY_ID'

Line 5250: wf_engine.CreateProcess

5246: IF l_pt_role_list.count < 1 THEN
5247: return;
5248: ELSE
5249: -- Once the parameters for workflow is validated, start the workflow
5250: wf_engine.CreateProcess
5251: (
5252: ItemType => l_itemType
5253: , ItemKey => l_itemKey
5254: , process => 'EVENT_NOTIF_PROCESS'

Line 5257: wf_engine.SetItemUserKey

5253: , ItemKey => l_itemKey
5254: , process => 'EVENT_NOTIF_PROCESS'
5255: );
5256:
5257: wf_engine.SetItemUserKey
5258: (
5259: ItemType => l_itemType
5260: , ItemKey => l_itemKey
5261: , userKey => l_itemkey

Line 5264: wf_engine.SetItemAttrText

5260: , ItemKey => l_itemKey
5261: , userKey => l_itemkey
5262: );
5263:
5264: wf_engine.SetItemAttrText
5265: (
5266: ItemType => l_itemType
5267: , ItemKey => l_itemKey
5268: , aname => 'NOTIFY_ROLE'

Line 5272: wf_engine.SetItemAttrText

5268: , aname => 'NOTIFY_ROLE'
5269: , avalue => l_pt_adhoc_role
5270: );
5271:
5272: wf_engine.SetItemAttrText
5273: (
5274: ItemType => l_itemType
5275: , ItemKey => l_itemKey
5276: , aname => 'PARTNER_EVENT_CODE'

Line 5284: wf_engine.SetItemAttrText

5280: -- NOTIFICATION_TYPE can be different from the event in some cases
5281: -- so that can be set accordingly here or later in the workflow process
5282: -- so right now setting it to p_notif_event_code
5283:
5284: wf_engine.SetItemAttrText
5285: (
5286: ItemType => l_itemType
5287: , ItemKey => l_itemKey
5288: , aname => 'NOTIFICATION_TYPE'

Line 5292: wf_engine.SetItemAttrNumber

5288: , aname => 'NOTIFICATION_TYPE'
5289: , avalue => p_notif_event_code
5290: );
5291:
5292: wf_engine.SetItemAttrNumber
5293: (
5294: ItemType => l_itemType
5295: , ItemKey => l_itemKey
5296: , aname => 'PARTNER_ID'

Line 5300: wf_engine.SetItemAttrNumber

5296: , aname => 'PARTNER_ID'
5297: , avalue => l_notif_targeted_ptr_id --the partner_id to whom the notificationneeds to be sent
5298: );
5299:
5300: wf_engine.SetItemAttrNumber
5301: (
5302: ItemType => l_itemType
5303: , ItemKey => l_itemKey
5304: , aname => 'ENTITY_ID'

Line 5308: wf_engine.SetItemAttrText

5304: , aname => 'ENTITY_ID'
5305: , avalue => p_entity_id
5306: );
5307:
5308: wf_engine.SetItemAttrText
5309: (
5310: ItemType => l_itemType
5311: , ItemKey => l_itemKey
5312: , aname => 'ENTITY_CODE'

Line 5316: wf_engine.SetItemAttrText

5312: , aname => 'ENTITY_CODE'
5313: , avalue => l_entity_code
5314: );
5315:
5316: wf_engine.SetItemAttrText
5317: (
5318: ItemType => l_itemType
5319: , ItemKey => l_itemKey
5320: , aname => 'RECIPIENT_USER_ID'

Line 5325: wf_engine.setItemAttrNumber(

5321: , avalue => l_notif_user_id
5322: );
5323:
5324: -- set wait period in number of days in the workflow
5325: wf_engine.setItemAttrNumber(
5326: ITEMTYPE => l_itemtype,
5327: ITEMKEY => l_itemkey,
5328: ANAME => 'WAIT_PERIOD_IN_DAYS',
5329: AVALUE => p_wait_time

Line 5334: wf_engine.setItemAttrText

5330: );
5331:
5332: l_login_url := FND_PROFILE.VALUE('PV_WORKFLOW_ISTORE_URL');
5333: --l_prtner_portal_url := ''|| l_partner_program || '';
5334: wf_engine.setItemAttrText
5335: (
5336: ITEMTYPE => l_itemtype
5337: , ITEMKEY => l_itemkey
5338: , ANAME => 'ISTORE_LOGIN_URL'

Line 5344: wf_engine.setItemAttrText

5340: );
5341:
5342: IF l_entity_code = 'ENRQ' THEN
5343: -- set the program name
5344: wf_engine.setItemAttrText
5345: (
5346: ITEMTYPE => l_itemtype
5347: , ITEMKEY => l_itemkey
5348: , ANAME => 'PROGRAM_NAME'

Line 5353: wf_engine.setItemAttrText

5349: , AVALUE => l_partner_program
5350: );
5351:
5352: -- set the vendor org name
5353: wf_engine.setItemAttrText
5354: (
5355: ITEMTYPE => l_itemtype
5356: , ITEMKEY => l_itemkey
5357: , ANAME => 'VENDOR_ORG_NAME'

Line 5362: wf_engine.setItemAttrText

5358: , AVALUE => l_vendor_name
5359: );
5360:
5361: -- set the PARTNER_NAME
5362: wf_engine.setItemAttrText
5363: (
5364: ITEMTYPE => l_itemtype
5365: , ITEMKEY => l_itemkey
5366: , ANAME => 'PARTNER_NAME'

Line 5371: wf_engine.setItemAttrText

5367: , AVALUE => l_partner_comp_name
5368: );
5369:
5370: -- set the REQUESTOR_NAME
5371: wf_engine.setItemAttrText
5372: (
5373: ITEMTYPE => l_itemtype
5374: , ITEMKEY => l_itemkey
5375: , ANAME => 'REQUESTOR_NAME'

Line 5380: wf_engine.setItemAttrDate

5376: , AVALUE => l_source_name
5377: );
5378:
5379: -- set the submit date
5380: wf_engine.setItemAttrDate
5381: (
5382: ITEMTYPE => l_itemtype
5383: , ITEMKEY => l_itemkey
5384: , ANAME => 'ENROLL_SUBMIT_DATE'

Line 5389: wf_engine.setItemAttrText

5385: , AVALUE => l_req_submission_date
5386: );
5387:
5388: -- set the enroll type
5389: wf_engine.setItemAttrText
5390: (
5391: ITEMTYPE => l_itemtype
5392: , ITEMKEY => l_itemkey
5393: , ANAME => 'ENROLLMENT_TYPE'

Line 5398: wf_engine.setItemAttrText

5394: , AVALUE => l_enrollment_type
5395: );
5396:
5397: -- set the Enrollment Duration
5398: wf_engine.setItemAttrText
5399: (
5400: ITEMTYPE => l_itemtype
5401: , ITEMKEY => l_itemkey
5402: , ANAME => 'ENROLLMENT_DURATION'

Line 5406: wf_engine.setItemAttrDate

5402: , ANAME => 'ENROLLMENT_DURATION'
5403: , AVALUE => l_enrollment_duration
5404: );
5405: -- set the START_DATE
5406: wf_engine.setItemAttrDate
5407: (
5408: ITEMTYPE => l_itemtype
5409: , ITEMKEY => l_itemkey
5410: , ANAME => 'START_DATE'

Line 5415: wf_engine.setItemAttrDate

5411: , AVALUE => l_start_date
5412: );
5413:
5414: -- set the END_DATE
5415: wf_engine.setItemAttrDate
5416: (
5417: ITEMTYPE => l_itemtype
5418: , ITEMKEY => l_itemkey
5419: , ANAME => 'END_DATE'

Line 5424: wf_engine.setItemAttrNumber

5420: , AVALUE => l_end_date
5421: );
5422:
5423: -- set membership id.
5424: wf_engine.setItemAttrNumber
5425: (
5426: ITEMTYPE => l_itemtype
5427: , ITEMKEY => l_itemkey
5428: , ANAME => 'MEMBERSHIP_ID'

Line 5433: wf_engine.setItemAttrNumber

5429: , AVALUE => l_membership_id
5430: );
5431:
5432: --set enrollment request_id
5433: wf_engine.setItemAttrNumber
5434: (
5435: ITEMTYPE => l_itemtype
5436: , ITEMKEY => l_itemkey
5437: , ANAME => 'ENROLLMENT_REQUEST_ID'

Line 5447: wf_engine.setItemAttrText

5443: IF l_expiry_days <0 THEN
5444: l_expiry_days := 0;
5445: END IF;
5446:
5447: wf_engine.setItemAttrText
5448: (
5449: ITEMTYPE => l_itemtype
5450: , ITEMKEY => l_itemkey
5451: , ANAME => 'MBRSHIP_EXPIRY_IN_DAYS'

Line 5464: wf_engine.setItemAttrText

5460: , p_lookup_code => p_context_code
5461: , x_return_status => x_return_status
5462: , x_meaning => l_event_meaning
5463: );
5464: wf_engine.setItemAttrText
5465: (
5466: ITEMTYPE => l_itemtype
5467: , ITEMKEY => l_itemkey
5468: , ANAME => 'EVENT_MEANING'

Line 5493: wf_engine.setItemAttrText

5489: , x_meaning => l_event_meaning
5490: );
5491: END IF;
5492:
5493: wf_engine.setItemAttrText
5494: (
5495: ITEMTYPE => l_itemtype
5496: , ITEMKEY => l_itemkey
5497: , ANAME => 'EVENT_MEANING'

Line 5503: wf_engine.setItemAttrText

5499: );
5500: END IF;
5501:
5502: IF p_notif_event_code = 'PG_DOWNGRADE' THEN
5503: wf_engine.setItemAttrText
5504: (
5505: ITEMTYPE => l_itemtype
5506: , ITEMKEY => l_itemkey
5507: , ANAME => 'FROM_PROGRAM'

Line 5515: wf_engine.setItemAttrText

5511: OPEN c_prgm_csr(p_context_id);
5512: FETCH c_prgm_csr INTO l_to_partner_program;
5513: CLOSE c_prgm_csr;
5514:
5515: wf_engine.setItemAttrText
5516: (
5517: ITEMTYPE => l_itemtype
5518: , ITEMKEY => l_itemkey
5519: , ANAME => 'TO_PROGRAM'

Line 5554: wf_engine.setItemAttrText

5550: END IF;
5551: END IF;
5552:
5553: -- set the vendor org name
5554: wf_engine.setItemAttrText
5555: (
5556: ITEMTYPE => l_itemtype
5557: , ITEMKEY => l_itemkey
5558: , ANAME => 'VENDOR_ORG_NAME'

Line 5563: wf_engine.setItemAttrText

5559: , AVALUE => l_vendor_name
5560: );
5561:
5562: -- set the PARTNER_NAME
5563: wf_engine.setItemAttrText
5564: (
5565: ITEMTYPE => l_itemtype
5566: , ITEMKEY => l_itemkey
5567: , ANAME => 'PARTNER_NAME'

Line 5575: wf_engine.setItemAttrText

5571: IF p_notif_event_code IN ( 'PG_INVITE', 'VAD_INVITE_IMP' ) THEN
5572: OPEN c_inv_csr (p_entity_id);
5573: FETCH c_inv_csr INTO l_partner_program;
5574: CLOSE c_inv_csr ;
5575: wf_engine.setItemAttrText
5576: (
5577: ITEMTYPE => l_itemtype
5578: , ITEMKEY => l_itemkey
5579: , ANAME => 'PROGRAM_NAME'

Line 5585: wf_engine.setItemAttrText

5581: );
5582: END IF;
5583:
5584: IF p_notif_event_code = 'MEMBER_TYPE_CHANGE' THEN
5585: wf_engine.setItemAttrText
5586: (
5587: ITEMTYPE => l_itemtype
5588: , ITEMKEY => l_itemkey
5589: , ANAME => 'FROM_MEMBER_TYPE'

Line 5593: wf_engine.setItemAttrText

5589: , ANAME => 'FROM_MEMBER_TYPE'
5590: , AVALUE => p_context_code
5591: );
5592:
5593: wf_engine.setItemAttrText
5594: (
5595: ITEMTYPE => l_itemtype
5596: , ITEMKEY => l_itemkey
5597: , ANAME => 'TO_MEMBER_TYPE'

Line 5607: wf_engine.StartProcess

5603: END IF; -- END OF IF .
5604:
5605:
5606:
5607: wf_engine.StartProcess
5608: (
5609: ItemType => l_itemType
5610: , ItemKey => l_itemKey
5611: );

Line 5833: wf_engine.CreateProcess

5829: IF l_pt_role_list.count < 1 THEN
5830: return;
5831: ELSE
5832: -- Once the parameters for workflow is validated, start the workflow
5833: wf_engine.CreateProcess
5834: (
5835: ItemType => l_itemType
5836: , ItemKey => l_itemKey
5837: , process => 'EVENT_NOTIF_PROCESS'

Line 5840: wf_engine.SetItemUserKey

5836: , ItemKey => l_itemKey
5837: , process => 'EVENT_NOTIF_PROCESS'
5838: );
5839:
5840: wf_engine.SetItemUserKey
5841: (
5842: ItemType => l_itemType
5843: , ItemKey => l_itemKey
5844: , userKey => l_itemkey

Line 5847: wf_engine.SetItemAttrText

5843: , ItemKey => l_itemKey
5844: , userKey => l_itemkey
5845: );
5846:
5847: wf_engine.SetItemAttrText
5848: (
5849: ItemType => l_itemType
5850: , ItemKey => l_itemKey
5851: , aname => 'NOTIFY_ROLE'

Line 5884: wf_engine.SetItemAttrText

5880: l_string := SUBSTR(fnd_message.get,1,1000);
5881:
5882: END IF;
5883:
5884: wf_engine.SetItemAttrText
5885: (
5886: ItemType => l_itemType
5887: , ItemKey => l_itemKey
5888: , aname => 'DISCOUNT_STRING'

Line 5892: wf_engine.SetItemAttrText

5888: , aname => 'DISCOUNT_STRING'
5889: , avalue => l_string
5890: );
5891:
5892: wf_engine.SetItemAttrText
5893: (
5894: ItemType => l_itemType
5895: , ItemKey => l_itemKey
5896: , aname => 'PARTNER_EVENT_CODE'

Line 5904: wf_engine.SetItemAttrText

5900: -- NOTIFICATION_TYPE can be different from the event in some cases
5901: -- so that can be set accordingly here or later in the workflow process
5902: -- so right now setting it to p_notif_event_code
5903:
5904: wf_engine.SetItemAttrText
5905: (
5906: ItemType => l_itemType
5907: , ItemKey => l_itemKey
5908: , aname => 'NOTIFICATION_TYPE'

Line 5912: wf_engine.SetItemAttrNumber

5908: , aname => 'NOTIFICATION_TYPE'
5909: , avalue => p_notif_event_code
5910: );
5911:
5912: wf_engine.SetItemAttrNumber
5913: (
5914: ItemType => l_itemType
5915: , ItemKey => l_itemKey
5916: , aname => 'PARTNER_ID'

Line 5920: wf_engine.SetItemAttrNumber

5916: , aname => 'PARTNER_ID'
5917: , avalue => p_partner_id --the partner_id to whom the notificationneeds to be sent
5918: );
5919:
5920: wf_engine.SetItemAttrNumber
5921: (
5922: ItemType => l_itemType
5923: , ItemKey => l_itemKey
5924: , aname => 'ENTITY_ID'

Line 5928: wf_engine.SetItemAttrText

5924: , aname => 'ENTITY_ID'
5925: , avalue => p_invite_header_id
5926: );
5927:
5928: wf_engine.SetItemAttrText
5929: (
5930: ItemType => l_itemType
5931: , ItemKey => l_itemKey
5932: , aname => 'ENTITY_CODE'

Line 5936: wf_engine.SetItemAttrText

5932: , aname => 'ENTITY_CODE'
5933: , avalue => 'INVITE'
5934: );
5935:
5936: wf_engine.SetItemAttrText
5937: (
5938: ItemType => l_itemType
5939: , ItemKey => l_itemKey
5940: , aname => 'RECIPIENT_USER_ID'

Line 5945: wf_engine.setItemAttrNumber(

5941: , avalue => l_notif_user_id
5942: );
5943:
5944: -- set wait period in number of days in the workflow
5945: wf_engine.setItemAttrNumber(
5946: ITEMTYPE => l_itemtype,
5947: ITEMKEY => l_itemkey,
5948: ANAME => 'WAIT_PERIOD_IN_DAYS',
5949: AVALUE => 0

Line 5954: wf_engine.setItemAttrText

5950: );
5951:
5952: l_login_url := FND_PROFILE.VALUE('PV_WORKFLOW_ISTORE_URL');
5953: --l_prtner_portal_url := ''|| l_partner_program || '';
5954: wf_engine.setItemAttrText
5955: (
5956: ITEMTYPE => l_itemtype
5957: , ITEMKEY => l_itemkey
5958: , ANAME => 'ISTORE_LOGIN_URL'

Line 5984: wf_engine.setItemAttrText

5980: END IF;
5981: END IF;
5982:
5983: -- set the vendor org name
5984: wf_engine.setItemAttrText
5985: (
5986: ITEMTYPE => l_itemtype
5987: , ITEMKEY => l_itemkey
5988: , ANAME => 'VENDOR_ORG_NAME'

Line 5993: wf_engine.setItemAttrText

5989: , AVALUE => l_vendor_name
5990: );
5991:
5992: -- set the PARTNER_NAME
5993: wf_engine.setItemAttrText
5994: (
5995: ITEMTYPE => l_itemtype
5996: , ITEMKEY => l_itemkey
5997: , ANAME => 'PARTNER_NAME'

Line 6006: wf_engine.setItemAttrText

6002: OPEN c_inv_csr (p_invite_header_id);
6003: FETCH c_inv_csr INTO l_partner_program;
6004: CLOSE c_inv_csr ;
6005:
6006: wf_engine.setItemAttrText
6007: (
6008: ITEMTYPE => l_itemtype
6009: , ITEMKEY => l_itemkey
6010: , ANAME => 'PROGRAM_NAME'

Line 6014: wf_engine.setItemAttrText

6010: , ANAME => 'PROGRAM_NAME'
6011: , AVALUE => l_partner_program
6012: );
6013:
6014: wf_engine.setItemAttrText
6015: (
6016: ITEMTYPE => l_itemtype
6017: , ITEMKEY => l_itemkey
6018: , ANAME => 'TO_PROGRAM'

Line 6027: wf_engine.setItemAttrText

6023: OPEN c_prgm_csr(p_from_program_id);
6024: FETCH c_prgm_csr INTO l_from_partner_program;
6025: CLOSE c_prgm_csr;
6026:
6027: wf_engine.setItemAttrText
6028: (
6029: ITEMTYPE => l_itemtype
6030: , ITEMKEY => l_itemkey
6031: , ANAME => 'FROM_PROGRAM'

Line 6036: wf_engine.StartProcess

6032: , AVALUE => l_from_partner_program
6033: );
6034: END IF;
6035:
6036: wf_engine.StartProcess
6037: (
6038: ItemType => l_itemType
6039: , ItemKey => l_itemKey
6040: );