APPS.INV_SHORTCHECKEXEC_PVT dependencies on WF_NOTIFICATION

Line 794: L_notification_id := WF_NOTIFICATION.Send (

790: LOOP
791: FETCH L_ShortTemp_csr INTO L_user_name;
792: EXIT WHEN L_ShortTemp_csr%NOTFOUND;
793: -- Call the send message wf procedure
794: L_notification_id := WF_NOTIFICATION.Send (
795: role => L_user_name,
796: msg_type => 'INVSHMSG',
797: msg_name => L_msg_name,
798: due_date => NULL,

Line 804: -- Added call to wf_notification.denormalize_notification for bug 3101169

800: context => NULL,
801: send_comment => NULL );
802: -- Set message attributes
803: -- Open Form Command for View shortage form
804: -- Added call to wf_notification.denormalize_notification for bug 3101169
805: WF_NOTIFICATION.SetAttrText (
806: nid => L_notification_id,
807: aname => 'OPEN_FORM_COMMAND',
808: avalue => 'INV_INVSHINQ:ORG_ID="'||'&'||

Line 805: WF_NOTIFICATION.SetAttrText (

801: send_comment => NULL );
802: -- Set message attributes
803: -- Open Form Command for View shortage form
804: -- Added call to wf_notification.denormalize_notification for bug 3101169
805: WF_NOTIFICATION.SetAttrText (
806: nid => L_notification_id,
807: aname => 'OPEN_FORM_COMMAND',
808: avalue => 'INV_INVSHINQ:ORG_ID="'||'&'||
809: 'ORGANIZATION_ID" ITEM_ID="'||'&'||'INVENTORY_ITEM_ID"' );

Line 811: WF_NOTIFICATION.SetAttrNumber (

807: aname => 'OPEN_FORM_COMMAND',
808: avalue => 'INV_INVSHINQ:ORG_ID="'||'&'||
809: 'ORGANIZATION_ID" ITEM_ID="'||'&'||'INVENTORY_ITEM_ID"' );
810: -- Item id
811: WF_NOTIFICATION.SetAttrNumber (
812: nid => L_notification_id,
813: aname => 'INVENTORY_ITEM_ID',
814: avalue => p_inventory_item_id );
815: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);

Line 815: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);

811: WF_NOTIFICATION.SetAttrNumber (
812: nid => L_notification_id,
813: aname => 'INVENTORY_ITEM_ID',
814: avalue => p_inventory_item_id );
815: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);
816: -- Item concatenated segments
817: WF_NOTIFICATION.SetAttrText (
818: nid => L_notification_id,
819: aname => 'INVENTORY_ITEM_CONC_SEGMENTS',

Line 817: WF_NOTIFICATION.SetAttrText (

813: aname => 'INVENTORY_ITEM_ID',
814: avalue => p_inventory_item_id );
815: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);
816: -- Item concatenated segments
817: WF_NOTIFICATION.SetAttrText (
818: nid => L_notification_id,
819: aname => 'INVENTORY_ITEM_CONC_SEGMENTS',
820: avalue => L_item_conc_segments );
821: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);

Line 821: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);

817: WF_NOTIFICATION.SetAttrText (
818: nid => L_notification_id,
819: aname => 'INVENTORY_ITEM_CONC_SEGMENTS',
820: avalue => L_item_conc_segments );
821: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);
822: -- Organization id
823: WF_NOTIFICATION.SetAttrNumber (
824: nid => L_notification_id,
825: aname => 'ORGANIZATION_ID',

Line 823: WF_NOTIFICATION.SetAttrNumber (

819: aname => 'INVENTORY_ITEM_CONC_SEGMENTS',
820: avalue => L_item_conc_segments );
821: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);
822: -- Organization id
823: WF_NOTIFICATION.SetAttrNumber (
824: nid => L_notification_id,
825: aname => 'ORGANIZATION_ID',
826: avalue => p_organization_id );
827: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);

Line 827: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);

823: WF_NOTIFICATION.SetAttrNumber (
824: nid => L_notification_id,
825: aname => 'ORGANIZATION_ID',
826: avalue => p_organization_id );
827: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);
828: -- Organization code
829: WF_NOTIFICATION.SetAttrText (
830: nid => L_notification_id,
831: aname => 'ORGANIZATION_CODE',

Line 829: WF_NOTIFICATION.SetAttrText (

825: aname => 'ORGANIZATION_ID',
826: avalue => p_organization_id );
827: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);
828: -- Organization code
829: WF_NOTIFICATION.SetAttrText (
830: nid => L_notification_id,
831: aname => 'ORGANIZATION_CODE',
832: avalue => L_organization_code );
833: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);

Line 833: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);

829: WF_NOTIFICATION.SetAttrText (
830: nid => L_notification_id,
831: aname => 'ORGANIZATION_CODE',
832: avalue => L_organization_code );
833: WF_NOTIFICATION.Denormalize_Notification(L_notification_id);
834: --
835: END LOOP;
836: CLOSE L_ShortTemp_csr;
837: -- Standard check of p_commit