eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_UTIL_PKG dependencies on WF_ITEM

Line 636: wf_itemkey IN OUT NOCOPY VARCHAR2,

632: x_wip_operation_seq_num NUMBER,
633: x_wip_resource_seq_num NUMBER,
634: x_po_encumberance_flag VARCHAR2,
635: x_gl_encumbered_date DATE,
636: wf_itemkey IN OUT NOCOPY VARCHAR2,
637: V_new_combination IN OUT NOCOPY VARCHAR2,
638: header_att1 VARCHAR2,
639: header_att2 VARCHAR2,
640: header_att3 VARCHAR2,

Line 747: wf_itemkey,

743: x_wip_operation_seq_num,
744: x_wip_resource_seq_num,
745: x_po_encumberance_flag,
746: x_gl_encumbered_date,
747: wf_itemkey,
748: x_new_combination,
749: header_att1,
750: header_att2,
751: header_att3,

Line 814: WF_ITEM_ACTIVITY_STATUS.CLEARCACHE;

810: V_new_combination := bool_to_varchar(x_new_combination);
811:
812: WF_ENGINE_UTIL.CLEARCACHE;
813: WF_ACTIVITY.CLEARCACHE;
814: WF_ITEM_ACTIVITY_STATUS.CLEARCACHE;
815: WF_ITEM.CLEARCACHE;
816: WF_PROCESS_ACTIVITY.CLEARCACHE;
817:
818: RETURN bool_to_varchar(x_return);

Line 815: WF_ITEM.CLEARCACHE;

811:
812: WF_ENGINE_UTIL.CLEARCACHE;
813: WF_ACTIVITY.CLEARCACHE;
814: WF_ITEM_ACTIVITY_STATUS.CLEARCACHE;
815: WF_ITEM.CLEARCACHE;
816: WF_PROCESS_ACTIVITY.CLEARCACHE;
817:
818: RETURN bool_to_varchar(x_return);
819: EXCEPTION

Line 970: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;

966: END update_gms_distributions;
967:
968: PROCEDURE update_notif_header_attr(p_header_id IN NUMBER) IS
969:
970: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
971: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
972: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
973: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
974:

Line 971: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;

967:
968: PROCEDURE update_notif_header_attr(p_header_id IN NUMBER) IS
969:
970: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
971: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
972: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
973: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
974:
975: l_notif_id number;

Line 972: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;

968: PROCEDURE update_notif_header_attr(p_header_id IN NUMBER) IS
969:
970: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
971: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
972: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
973: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
974:
975: l_notif_id number;
976: l_description varchar2(240);

Line 973: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;

969:
970: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
971: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
972: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
973: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
974:
975: l_notif_id number;
976: l_description varchar2(240);
977: l_req_total varchar2(240);

Line 988: cursor ame_child_wf (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is

984: l_procedure_name CONSTANT VARCHAR2(30) := 'update_notif_header_attr';
985: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
986:
987:
988: cursor ame_child_wf (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
989: select item_type, item_key
990: from wf_items
991: where parent_item_type = l_wf_itemtype
992: and parent_item_key = l_wf_itemkey;

Line 990: from wf_items

986:
987:
988: cursor ame_child_wf (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
989: select item_type, item_key
990: from wf_items
991: where parent_item_type = l_wf_itemtype
992: and parent_item_key = l_wf_itemkey;
993:
994: cursor wf_notifs (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is

Line 991: where parent_item_type = l_wf_itemtype

987:
988: cursor ame_child_wf (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
989: select item_type, item_key
990: from wf_items
991: where parent_item_type = l_wf_itemtype
992: and parent_item_key = l_wf_itemkey;
993:
994: cursor wf_notifs (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
995: select notification_id

Line 992: and parent_item_key = l_wf_itemkey;

988: cursor ame_child_wf (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
989: select item_type, item_key
990: from wf_items
991: where parent_item_type = l_wf_itemtype
992: and parent_item_key = l_wf_itemkey;
993:
994: cursor wf_notifs (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
995: select notification_id
996: from wf_item_activity_statuses

Line 994: cursor wf_notifs (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is

990: from wf_items
991: where parent_item_type = l_wf_itemtype
992: and parent_item_key = l_wf_itemkey;
993:
994: cursor wf_notifs (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
995: select notification_id
996: from wf_item_activity_statuses
997: where item_type = l_wf_itemtype
998: and item_key = l_wf_itemkey

Line 996: from wf_item_activity_statuses

992: and parent_item_key = l_wf_itemkey;
993:
994: cursor wf_notifs (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
995: select notification_id
996: from wf_item_activity_statuses
997: where item_type = l_wf_itemtype
998: and item_key = l_wf_itemkey
999: and notification_id is not null;
1000:

Line 997: where item_type = l_wf_itemtype

993:
994: cursor wf_notifs (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
995: select notification_id
996: from wf_item_activity_statuses
997: where item_type = l_wf_itemtype
998: and item_key = l_wf_itemkey
999: and notification_id is not null;
1000:
1001:

Line 998: and item_key = l_wf_itemkey

994: cursor wf_notifs (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
995: select notification_id
996: from wf_item_activity_statuses
997: where item_type = l_wf_itemtype
998: and item_key = l_wf_itemkey
999: and notification_id is not null;
1000:
1001:
1002: BEGIN

Line 1006: SELECT wf_item_type, wf_item_key

1002: BEGIN
1003:
1004: l_progress := '001';
1005:
1006: SELECT wf_item_type, wf_item_key
1007: INTO l_wf_itemtype, l_wf_itemkey
1008: FROM PO_REQUISITION_HEADERS_ALL
1009: WHERE REQUISITION_HEADER_ID = p_header_id;
1010:

Line 1007: INTO l_wf_itemtype, l_wf_itemkey

1003:
1004: l_progress := '001';
1005:
1006: SELECT wf_item_type, wf_item_key
1007: INTO l_wf_itemtype, l_wf_itemkey
1008: FROM PO_REQUISITION_HEADERS_ALL
1009: WHERE REQUISITION_HEADER_ID = p_header_id;
1010:
1011: l_progress := '002';

Line 1016: itemtype => l_wf_itemtype,

1012:
1013: -- call PO_REQAPPROVAL_INIT1.GetReqAttributes to update item attributes for the wf.
1014: PO_REQAPPROVAL_INIT1.GetReqAttributes(
1015: p_requisition_header_id =>p_header_id,
1016: itemtype => l_wf_itemtype,
1017: itemkey => l_wf_itemkey);
1018:
1019: l_is_ame_approval:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1020: itemkey => l_wf_itemkey,

Line 1017: itemkey => l_wf_itemkey);

1013: -- call PO_REQAPPROVAL_INIT1.GetReqAttributes to update item attributes for the wf.
1014: PO_REQAPPROVAL_INIT1.GetReqAttributes(
1015: p_requisition_header_id =>p_header_id,
1016: itemtype => l_wf_itemtype,
1017: itemkey => l_wf_itemkey);
1018:
1019: l_is_ame_approval:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1020: itemkey => l_wf_itemkey,
1021: aname => 'IS_AME_APPROVAL');

Line 1019: l_is_ame_approval:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,

1015: p_requisition_header_id =>p_header_id,
1016: itemtype => l_wf_itemtype,
1017: itemkey => l_wf_itemkey);
1018:
1019: l_is_ame_approval:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1020: itemkey => l_wf_itemkey,
1021: aname => 'IS_AME_APPROVAL');
1022: l_progress := '003';
1023:

Line 1020: itemkey => l_wf_itemkey,

1016: itemtype => l_wf_itemtype,
1017: itemkey => l_wf_itemkey);
1018:
1019: l_is_ame_approval:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1020: itemkey => l_wf_itemkey,
1021: aname => 'IS_AME_APPROVAL');
1022: l_progress := '003';
1023:
1024: -- Then we can use the updated item attributes to update notification attributes

Line 1027: l_description := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,

1023:
1024: -- Then we can use the updated item attributes to update notification attributes
1025: If ( l_is_ame_approval = 'N') then
1026:
1027: l_description := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1028: itemkey => l_wf_itemkey,
1029: aname => 'REQ_DESCRIPTION');
1030:
1031: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,

Line 1028: itemkey => l_wf_itemkey,

1024: -- Then we can use the updated item attributes to update notification attributes
1025: If ( l_is_ame_approval = 'N') then
1026:
1027: l_description := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1028: itemkey => l_wf_itemkey,
1029: aname => 'REQ_DESCRIPTION');
1030:
1031: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1032: itemkey => l_wf_itemkey,

Line 1031: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,

1027: l_description := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1028: itemkey => l_wf_itemkey,
1029: aname => 'REQ_DESCRIPTION');
1030:
1031: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1032: itemkey => l_wf_itemkey,
1033: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1034:
1035: l_justification := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,

Line 1032: itemkey => l_wf_itemkey,

1028: itemkey => l_wf_itemkey,
1029: aname => 'REQ_DESCRIPTION');
1030:
1031: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1032: itemkey => l_wf_itemkey,
1033: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1034:
1035: l_justification := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1036: itemkey => l_wf_itemkey,

Line 1035: l_justification := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,

1031: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1032: itemkey => l_wf_itemkey,
1033: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1034:
1035: l_justification := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1036: itemkey => l_wf_itemkey,
1037: aname => 'JUSTIFICATION');
1038:
1039: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,

Line 1036: itemkey => l_wf_itemkey,

1032: itemkey => l_wf_itemkey,
1033: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1034:
1035: l_justification := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1036: itemkey => l_wf_itemkey,
1037: aname => 'JUSTIFICATION');
1038:
1039: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1040: itemkey => l_wf_itemkey,

Line 1039: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,

1035: l_justification := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1036: itemkey => l_wf_itemkey,
1037: aname => 'JUSTIFICATION');
1038:
1039: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1040: itemkey => l_wf_itemkey,
1041: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1042:
1043: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,

Line 1040: itemkey => l_wf_itemkey,

1036: itemkey => l_wf_itemkey,
1037: aname => 'JUSTIFICATION');
1038:
1039: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1040: itemkey => l_wf_itemkey,
1041: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1042:
1043: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1044: itemkey => l_wf_itemkey,

Line 1043: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,

1039: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1040: itemkey => l_wf_itemkey,
1041: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1042:
1043: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1044: itemkey => l_wf_itemkey,
1045: aname => 'TOTAL_AMOUNT_DSP');
1046:
1047: l_progress := '004';

Line 1044: itemkey => l_wf_itemkey,

1040: itemkey => l_wf_itemkey,
1041: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1042:
1043: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1044: itemkey => l_wf_itemkey,
1045: aname => 'TOTAL_AMOUNT_DSP');
1046:
1047: l_progress := '004';
1048:

Line 1049: open wf_notifs( l_wf_itemtype,l_wf_itemkey);

1045: aname => 'TOTAL_AMOUNT_DSP');
1046:
1047: l_progress := '004';
1048:
1049: open wf_notifs( l_wf_itemtype,l_wf_itemkey);
1050:
1051: loop
1052: fetch wf_notifs
1053: into l_notif_id;

Line 1075: open ame_child_wf ( l_wf_itemtype,l_wf_itemkey );

1071: else
1072:
1073: l_progress := '006';
1074:
1075: open ame_child_wf ( l_wf_itemtype,l_wf_itemkey );
1076: loop
1077: fetch ame_child_wf
1078: into l_child_wf_itemtype,
1079: l_child_wf_itemkey;

Line 1078: into l_child_wf_itemtype,

1074:
1075: open ame_child_wf ( l_wf_itemtype,l_wf_itemkey );
1076: loop
1077: fetch ame_child_wf
1078: into l_child_wf_itemtype,
1079: l_child_wf_itemkey;
1080:
1081: exit when ame_child_wf%NOTFOUND;
1082:

Line 1079: l_child_wf_itemkey;

1075: open ame_child_wf ( l_wf_itemtype,l_wf_itemkey );
1076: loop
1077: fetch ame_child_wf
1078: into l_child_wf_itemtype,
1079: l_child_wf_itemkey;
1080:
1081: exit when ame_child_wf%NOTFOUND;
1082:
1083: PO_REQAPPROVAL_INIT1.GetReqAttributes(

Line 1085: itemtype => l_child_wf_itemtype,

1081: exit when ame_child_wf%NOTFOUND;
1082:
1083: PO_REQAPPROVAL_INIT1.GetReqAttributes(
1084: p_requisition_header_id =>p_header_id,
1085: itemtype => l_child_wf_itemtype,
1086: itemkey => l_child_wf_itemkey);
1087:
1088: l_description :=PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1089: itemkey => l_child_wf_itemkey,

Line 1086: itemkey => l_child_wf_itemkey);

1082:
1083: PO_REQAPPROVAL_INIT1.GetReqAttributes(
1084: p_requisition_header_id =>p_header_id,
1085: itemtype => l_child_wf_itemtype,
1086: itemkey => l_child_wf_itemkey);
1087:
1088: l_description :=PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1089: itemkey => l_child_wf_itemkey,
1090: aname => 'REQ_DESCRIPTION');

Line 1088: l_description :=PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,

1084: p_requisition_header_id =>p_header_id,
1085: itemtype => l_child_wf_itemtype,
1086: itemkey => l_child_wf_itemkey);
1087:
1088: l_description :=PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1089: itemkey => l_child_wf_itemkey,
1090: aname => 'REQ_DESCRIPTION');
1091:
1092: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_child_wf_itemtype,

Line 1089: itemkey => l_child_wf_itemkey,

1085: itemtype => l_child_wf_itemtype,
1086: itemkey => l_child_wf_itemkey);
1087:
1088: l_description :=PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1089: itemkey => l_child_wf_itemkey,
1090: aname => 'REQ_DESCRIPTION');
1091:
1092: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_child_wf_itemtype,
1093: itemkey => l_child_wf_itemkey,

Line 1092: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_child_wf_itemtype,

1088: l_description :=PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1089: itemkey => l_child_wf_itemkey,
1090: aname => 'REQ_DESCRIPTION');
1091:
1092: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_child_wf_itemtype,
1093: itemkey => l_child_wf_itemkey,
1094: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1095:
1096: l_justification := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,

Line 1093: itemkey => l_child_wf_itemkey,

1089: itemkey => l_child_wf_itemkey,
1090: aname => 'REQ_DESCRIPTION');
1091:
1092: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_child_wf_itemtype,
1093: itemkey => l_child_wf_itemkey,
1094: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1095:
1096: l_justification := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1097: itemkey => l_child_wf_itemkey,

Line 1096: l_justification := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,

1092: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_child_wf_itemtype,
1093: itemkey => l_child_wf_itemkey,
1094: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1095:
1096: l_justification := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1097: itemkey => l_child_wf_itemkey,
1098: aname => 'JUSTIFICATION');
1099:
1100: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,

Line 1097: itemkey => l_child_wf_itemkey,

1093: itemkey => l_child_wf_itemkey,
1094: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1095:
1096: l_justification := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1097: itemkey => l_child_wf_itemkey,
1098: aname => 'JUSTIFICATION');
1099:
1100: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1101: itemkey => l_child_wf_itemkey,

Line 1100: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,

1096: l_justification := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1097: itemkey => l_child_wf_itemkey,
1098: aname => 'JUSTIFICATION');
1099:
1100: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1101: itemkey => l_child_wf_itemkey,
1102: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1103:
1104: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText

Line 1101: itemkey => l_child_wf_itemkey,

1097: itemkey => l_child_wf_itemkey,
1098: aname => 'JUSTIFICATION');
1099:
1100: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1101: itemkey => l_child_wf_itemkey,
1102: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1103:
1104: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText
1105: ( itemtype => l_child_wf_itemtype,

Line 1105: ( itemtype => l_child_wf_itemtype,

1101: itemkey => l_child_wf_itemkey,
1102: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1103:
1104: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText
1105: ( itemtype => l_child_wf_itemtype,
1106: itemkey => l_child_wf_itemkey,
1107: aname => 'TOTAL_AMOUNT_DSP');
1108:
1109: open wf_notifs( l_child_wf_itemtype,l_child_wf_itemkey);

Line 1106: itemkey => l_child_wf_itemkey,

1102: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1103:
1104: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText
1105: ( itemtype => l_child_wf_itemtype,
1106: itemkey => l_child_wf_itemkey,
1107: aname => 'TOTAL_AMOUNT_DSP');
1108:
1109: open wf_notifs( l_child_wf_itemtype,l_child_wf_itemkey);
1110: loop

Line 1109: open wf_notifs( l_child_wf_itemtype,l_child_wf_itemkey);

1105: ( itemtype => l_child_wf_itemtype,
1106: itemkey => l_child_wf_itemkey,
1107: aname => 'TOTAL_AMOUNT_DSP');
1108:
1109: open wf_notifs( l_child_wf_itemtype,l_child_wf_itemkey);
1110: loop
1111: fetch wf_notifs
1112: into l_notif_id;
1113: exit when wf_notifs%NOTFOUND;

Line 1330: X_WF_ITEM_KEY IN VARCHAR2,

1326: req_Header_Id IN NUMBER,
1327: X_AUTHORIZATION_STATUS IN VARCHAR2,
1328: X_SUPPL_NOTIFIED_FLAG IN VARCHAR2,
1329: X_CONTRACTOR_REQ_FLAG IN VARCHAR2,
1330: X_WF_ITEM_KEY IN VARCHAR2,
1331: X_WF_ITEM_TYPE IN VARCHAR2,
1332: resume_contractor IN OUT NOCOPY VARCHAR2)
1333: IS
1334:

Line 1331: X_WF_ITEM_TYPE IN VARCHAR2,

1327: X_AUTHORIZATION_STATUS IN VARCHAR2,
1328: X_SUPPL_NOTIFIED_FLAG IN VARCHAR2,
1329: X_CONTRACTOR_REQ_FLAG IN VARCHAR2,
1330: X_WF_ITEM_KEY IN VARCHAR2,
1331: X_WF_ITEM_TYPE IN VARCHAR2,
1332: resume_contractor IN OUT NOCOPY VARCHAR2)
1333: IS
1334:
1335: BEGIN

Line 1349: wf_engine.CompleteActivity(X_WF_ITEM_TYPE, X_WF_ITEM_KEY, 'COMM_CONTR_SUPPLIER_BLOCK','NULL');

1345:
1346: IF X_AUTHORIZATION_STATUS = 'APPROVED' THEN
1347: -- REMOVE THE BLOCK
1348: BEGIN
1349: wf_engine.CompleteActivity(X_WF_ITEM_TYPE, X_WF_ITEM_KEY, 'COMM_CONTR_SUPPLIER_BLOCK','NULL');
1350: EXCEPTION
1351: WHEN OTHERS THEN
1352: PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1353: 'ERROR while running wf_engine.CompleteActivity:' || SQLERRM);

Line 1352: PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,

1348: BEGIN
1349: wf_engine.CompleteActivity(X_WF_ITEM_TYPE, X_WF_ITEM_KEY, 'COMM_CONTR_SUPPLIER_BLOCK','NULL');
1350: EXCEPTION
1351: WHEN OTHERS THEN
1352: PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1353: 'ERROR while running wf_engine.CompleteActivity:' || SQLERRM);
1354: END;
1355: IF (g_po_wf_debug = 'Y') THEN
1356: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,

Line 1356: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,

1352: PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1353: 'ERROR while running wf_engine.CompleteActivity:' || SQLERRM);
1354: END;
1355: IF (g_po_wf_debug = 'Y') THEN
1356: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1357: 'AFTER wf_engine.CompleteActivity');
1358: END IF;
1359: resume_contractor := 'Y';
1360: ELSE

Line 1363: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,

1359: resume_contractor := 'Y';
1360: ELSE
1361: IF X_AUTHORIZATION_STATUS = 'IN PROCESS' THEN
1362: IF (g_po_wf_debug = 'Y') THEN
1363: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1364: 'X_AUTHORIZATION_STATUS = IN PROCESS');
1365: END IF;
1366: --ABORT THE EXISTING WF
1367: WF_Engine.AbortProcess(X_WF_ITEM_TYPE, X_WF_ITEM_KEY);

Line 1367: WF_Engine.AbortProcess(X_WF_ITEM_TYPE, X_WF_ITEM_KEY);

1363: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1364: 'X_AUTHORIZATION_STATUS = IN PROCESS');
1365: END IF;
1366: --ABORT THE EXISTING WF
1367: WF_Engine.AbortProcess(X_WF_ITEM_TYPE, X_WF_ITEM_KEY);
1368: WF_PURGE.total (X_WF_ITEM_TYPE, X_WF_ITEM_KEY);
1369: update po_requisition_headers_all
1370: set WF_ITEM_TYPE = NULL, WF_ITEM_KEY = NULL
1371: where REQUISITION_HEADER_ID = req_Header_Id;

Line 1368: WF_PURGE.total (X_WF_ITEM_TYPE, X_WF_ITEM_KEY);

1364: 'X_AUTHORIZATION_STATUS = IN PROCESS');
1365: END IF;
1366: --ABORT THE EXISTING WF
1367: WF_Engine.AbortProcess(X_WF_ITEM_TYPE, X_WF_ITEM_KEY);
1368: WF_PURGE.total (X_WF_ITEM_TYPE, X_WF_ITEM_KEY);
1369: update po_requisition_headers_all
1370: set WF_ITEM_TYPE = NULL, WF_ITEM_KEY = NULL
1371: where REQUISITION_HEADER_ID = req_Header_Id;
1372: END IF;

Line 1370: set WF_ITEM_TYPE = NULL, WF_ITEM_KEY = NULL

1366: --ABORT THE EXISTING WF
1367: WF_Engine.AbortProcess(X_WF_ITEM_TYPE, X_WF_ITEM_KEY);
1368: WF_PURGE.total (X_WF_ITEM_TYPE, X_WF_ITEM_KEY);
1369: update po_requisition_headers_all
1370: set WF_ITEM_TYPE = NULL, WF_ITEM_KEY = NULL
1371: where REQUISITION_HEADER_ID = req_Header_Id;
1372: END IF;
1373: END IF;
1374: END IF;

Line 1400: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;

1396: p_document_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE := 'PURCHASE';
1397: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1398: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1399: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1400: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1401: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1402: BEGIN
1403:
1404: begin

Line 1401: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;

1397: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1398: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1399: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1400: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1401: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1402: BEGIN
1403:
1404: begin
1405:

Line 1409: contractor_requisition_flag, wf_item_key, wf_item_type,

1405:
1406: --If it is contractor req and status is approved, we should continue the
1407: --existing wf else we abort the earlier wf is it exists and launch a new wf
1408: SELECT authorization_status, supplier_notified_flag,
1409: contractor_requisition_flag, wf_item_key, wf_item_type,
1410: type_lookup_code
1411: INTO X_AUTHORIZATION_STATUS, X_SUPPL_NOTIFIED_FLAG,
1412: X_CONTRACTOR_REQ_FLAG, X_WF_ITEM_KEY, X_WF_ITEM_TYPE,
1413: p_document_subtype

Line 1412: X_CONTRACTOR_REQ_FLAG, X_WF_ITEM_KEY, X_WF_ITEM_TYPE,

1408: SELECT authorization_status, supplier_notified_flag,
1409: contractor_requisition_flag, wf_item_key, wf_item_type,
1410: type_lookup_code
1411: INTO X_AUTHORIZATION_STATUS, X_SUPPL_NOTIFIED_FLAG,
1412: X_CONTRACTOR_REQ_FLAG, X_WF_ITEM_KEY, X_WF_ITEM_TYPE,
1413: p_document_subtype
1414: FROM PO_REQUISITION_HEADERS_ALL
1415: WHERE REQUISITION_HEADER_ID = req_Header_Id;
1416:

Line 1420: PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,

1416:
1417: IF (g_po_wf_debug = 'Y') THEN
1418:
1419: /* DEBUG */
1420: PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1421: 'X_AUTHORIZATION_STATUS, X_SUPPL_NOTIFIED_FLAG,
1422: X_CONTRACTOR_REQ_FLAG, X_WF_ITEM_KEY, X_WF_ITEM_TYPE:' ||
1423: X_AUTHORIZATION_STATUS || X_SUPPL_NOTIFIED_FLAG ||
1424: X_CONTRACTOR_REQ_FLAG || X_WF_ITEM_KEY || X_WF_ITEM_TYPE);

Line 1422: X_CONTRACTOR_REQ_FLAG, X_WF_ITEM_KEY, X_WF_ITEM_TYPE:' ||

1418:
1419: /* DEBUG */
1420: PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1421: 'X_AUTHORIZATION_STATUS, X_SUPPL_NOTIFIED_FLAG,
1422: X_CONTRACTOR_REQ_FLAG, X_WF_ITEM_KEY, X_WF_ITEM_TYPE:' ||
1423: X_AUTHORIZATION_STATUS || X_SUPPL_NOTIFIED_FLAG ||
1424: X_CONTRACTOR_REQ_FLAG || X_WF_ITEM_KEY || X_WF_ITEM_TYPE);
1425:
1426: END IF;

Line 1424: X_CONTRACTOR_REQ_FLAG || X_WF_ITEM_KEY || X_WF_ITEM_TYPE);

1420: PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1421: 'X_AUTHORIZATION_STATUS, X_SUPPL_NOTIFIED_FLAG,
1422: X_CONTRACTOR_REQ_FLAG, X_WF_ITEM_KEY, X_WF_ITEM_TYPE:' ||
1423: X_AUTHORIZATION_STATUS || X_SUPPL_NOTIFIED_FLAG ||
1424: X_CONTRACTOR_REQ_FLAG || X_WF_ITEM_KEY || X_WF_ITEM_TYPE);
1425:
1426: END IF;
1427:
1428: resume_contractor_appr_wf(req_Header_Id, X_AUTHORIZATION_STATUS, X_SUPPL_NOTIFIED_FLAG, X_CONTRACTOR_REQ_FLAG, X_WF_ITEM_KEY, X_WF_ITEM_TYPE, p_resume_contractor);

Line 1428: resume_contractor_appr_wf(req_Header_Id, X_AUTHORIZATION_STATUS, X_SUPPL_NOTIFIED_FLAG, X_CONTRACTOR_REQ_FLAG, X_WF_ITEM_KEY, X_WF_ITEM_TYPE, p_resume_contractor);

1424: X_CONTRACTOR_REQ_FLAG || X_WF_ITEM_KEY || X_WF_ITEM_TYPE);
1425:
1426: END IF;
1427:
1428: resume_contractor_appr_wf(req_Header_Id, X_AUTHORIZATION_STATUS, X_SUPPL_NOTIFIED_FLAG, X_CONTRACTOR_REQ_FLAG, X_WF_ITEM_KEY, X_WF_ITEM_TYPE, p_resume_contractor);
1429:
1430: -- If it is a contractor req, supplier is notified, and req is approved then continue wf
1431: IF (p_resume_contractor = 'Y') THEN
1432: RETURN 'Y';

Line 1441: to_char(req_Header_Id) || '-' || to_char(PO_WF_ITEMKEY_S.nextval)

1437: raise;
1438: end;
1439:
1440: SELECT
1441: to_char(req_Header_Id) || '-' || to_char(PO_WF_ITEMKEY_S.nextval)
1442: INTO p_item_key
1443: FROM sys.dual;
1444:
1445: SELECT

Line 2072: from wf_items item

2068: ORDER BY sequence_num desc;
2069:
2070: cursor c1(itemtype varchar2, itemkey varchar2) is
2071: select item_key
2072: from wf_items item
2073: where item.item_type = itemtype
2074: AND item.parent_item_key = itemkey;
2075:
2076: BEGIN

Line 2086: SELECT wf_item_type, wf_item_key, type_lookup_code

2082: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Entering withdraw_req...');
2083: END IF;
2084:
2085: -- abort workflow
2086: SELECT wf_item_type, wf_item_key, type_lookup_code
2087: INTO l_item_type, l_item_key, l_doc_sub_type
2088: FROM po_requisition_headers_all
2089: WHERE requisition_header_id= p_headerId;
2090:

Line 2095: SET wf_item_type = NULL,

2091: l_progress := '010';
2092:
2093: -- update wf keys and status
2094: UPDATE po_requisition_headers_all
2095: SET wf_item_type = NULL,
2096: wf_item_key = NULL,
2097: authorization_status = 'INCOMPLETE'
2098: WHERE requisition_header_id = p_headerId;
2099:

Line 2096: wf_item_key = NULL,

2092:
2093: -- update wf keys and status
2094: UPDATE po_requisition_headers_all
2095: SET wf_item_type = NULL,
2096: wf_item_key = NULL,
2097: authorization_status = 'INCOMPLETE'
2098: WHERE requisition_header_id = p_headerId;
2099:
2100: l_progress := '020';

Line 2116: FROM wf_item_activity_statuses wfs,

2112:
2113: BEGIN
2114: SELECT NVL(activity_status, 'N')
2115: INTO l_activity_status
2116: FROM wf_item_activity_statuses wfs,
2117: wf_items wfi,
2118: wf_process_activities wfa
2119: WHERE wfi.item_type = l_item_type
2120: and wfi.item_key = l_item_key

Line 2117: wf_items wfi,

2113: BEGIN
2114: SELECT NVL(activity_status, 'N')
2115: INTO l_activity_status
2116: FROM wf_item_activity_statuses wfs,
2117: wf_items wfi,
2118: wf_process_activities wfa
2119: WHERE wfi.item_type = l_item_type
2120: and wfi.item_key = l_item_key
2121: and wfa.activity_name = wfi.root_activity

Line 2155: FROM wf_item_activity_statuses wfs,

2151:
2152: BEGIN
2153: SELECT NVL(activity_status, 'N')
2154: INTO l_activity_status
2155: FROM wf_item_activity_statuses wfs,
2156: wf_items wfi,
2157: wf_process_activities wfa
2158: WHERE wfi.item_type = l_item_type
2159: and wfi.item_key = c1_rec.item_key

Line 2156: wf_items wfi,

2152: BEGIN
2153: SELECT NVL(activity_status, 'N')
2154: INTO l_activity_status
2155: FROM wf_item_activity_statuses wfs,
2156: wf_items wfi,
2157: wf_process_activities wfa
2158: WHERE wfi.item_type = l_item_type
2159: and wfi.item_key = c1_rec.item_key
2160: and wfa.activity_name = wfi.root_activity

Line 2862: from wf_item_activity_statuses stat,

2858: PROCEDURE cancel_workflow(p_headerId in NUMBER) IS
2859:
2860: cursor c1(itemtype varchar2, itemkey varchar2) is
2861: select stat.notification_id
2862: from wf_item_activity_statuses stat,
2863: wf_items item
2864: where stat.item_type = itemtype
2865: AND item.item_type = itemtype
2866: AND item.parent_item_key = itemkey

Line 2863: wf_items item

2859:
2860: cursor c1(itemtype varchar2, itemkey varchar2) is
2861: select stat.notification_id
2862: from wf_item_activity_statuses stat,
2863: wf_items item
2864: where stat.item_type = itemtype
2865: AND item.item_type = itemtype
2866: AND item.parent_item_key = itemkey
2867: AND stat.item_key = item.item_key

Line 2871: from wf_item_activity_statuses

2867: AND stat.item_key = item.item_key
2868: AND stat.activity_status = 'NOTIFIED'
2869: UNION
2870: select notification_id
2871: from wf_item_activity_statuses
2872: where item_type = itemtype
2873: AND item_key = itemkey
2874: AND activity_status = 'NOTIFIED'
2875: AND notification_id is NOT NULL;

Line 2895: select wf_item_type, wf_item_key

2891: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Entering cancel_workflow...');
2892: END IF;
2893:
2894: -- get item_type and item_key
2895: select wf_item_type, wf_item_key
2896: into itype, ikey
2897: from po_requisition_headers
2898: where requisition_header_id = p_headerId;
2899:

Line 2902: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_type = ' || itype);

2898: where requisition_header_id = p_headerId;
2899:
2900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2901: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' p_headerId = ' || p_headerId);
2902: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_type = ' || itype);
2903: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_key = ' || ikey);
2904: END IF;
2905:
2906: for c1_rec in c1(itype, ikey) LOOP

Line 2903: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_key = ' || ikey);

2899:
2900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2901: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' p_headerId = ' || p_headerId);
2902: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_type = ' || itype);
2903: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_key = ' || ikey);
2904: END IF;
2905:
2906: for c1_rec in c1(itype, ikey) LOOP
2907: