DBA Data[Home] [Help]

APPS.PO_CHORD_WF1 dependencies on WF_ENGINE

Line 56: result := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

52: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
53: '*** Finish: chord_hd ***' );
54: END IF;
55:
56: result := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
57: return;
58:
59: EXCEPTION
60:

Line 644: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

640: ** and distributions do not exist hence there is no need to calculate the
641: ** po total change. Morever this is not even considered in blanket_po_reapproval.
642: */
643:
644: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
645: itemkey => itemkey,
646: aname => 'DOCUMENT_TYPE');
647:
648: l_document_subtype := wf_engine.GetItemAttrText (itemtype =>itemtype,

Line 648: l_document_subtype := wf_engine.GetItemAttrText (itemtype =>itemtype,

644: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
645: itemkey => itemkey,
646: aname => 'DOCUMENT_TYPE');
647:
648: l_document_subtype := wf_engine.GetItemAttrText (itemtype =>itemtype,
649: itemkey => itemkey,
650: aname => 'DOCUMENT_SUBTYPE');
651:
652: if ((l_document_type = 'PA') and (l_document_subtype = 'BLANKET')) then

Line 853: wf_engine.SetItemAttrText(itemtype,

849: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
850: '*** In procedure set_wf_header_control ***');
851: END IF;
852:
853: wf_engine.SetItemAttrText(itemtype,
854: itemkey,
855: 'CO_H_AGENT_MODIFIED',
856: x_header_control.agent_id);
857:

Line 858: wf_engine.SetItemAttrText(itemtype,

854: itemkey,
855: 'CO_H_AGENT_MODIFIED',
856: x_header_control.agent_id);
857:
858: wf_engine.SetItemAttrText(itemtype,
859: itemkey,
860: 'CO_H_VENDOR_SITE_MODIFIED',
861: x_header_control.vendor_site_id);
862:

Line 863: wf_engine.SetItemAttrText(itemtype,

859: itemkey,
860: 'CO_H_VENDOR_SITE_MODIFIED',
861: x_header_control.vendor_site_id);
862:
863: wf_engine.SetItemAttrText(itemtype,
864: itemkey,
865: 'CO_H_VENDOR_CONTACT_MODIFIED',
866: x_header_control.vendor_contact_id);
867:

Line 868: wf_engine.SetItemAttrText(itemtype,

864: itemkey,
865: 'CO_H_VENDOR_CONTACT_MODIFIED',
866: x_header_control.vendor_contact_id);
867:
868: wf_engine.SetItemAttrText(itemtype,
869: itemkey,
870: 'CO_H_SHIP_TO_MODIFIED',
871: x_header_control.ship_to_location_id);
872:

Line 873: wf_engine.SetItemAttrText(itemtype,

869: itemkey,
870: 'CO_H_SHIP_TO_MODIFIED',
871: x_header_control.ship_to_location_id);
872:
873: wf_engine.SetItemAttrText(itemtype,
874: itemkey,
875: 'CO_H_BILL_TO_MODIFIED',
876: x_header_control.bill_to_location_id);
877:

Line 878: wf_engine.SetItemAttrText(itemtype,

874: itemkey,
875: 'CO_H_BILL_TO_MODIFIED',
876: x_header_control.bill_to_location_id);
877:
878: wf_engine.SetItemAttrText(itemtype,
879: itemkey,
880: 'CO_H_TERMS_MODIFIED',
881: x_header_control.terms_id);
882:

Line 883: wf_engine.SetItemAttrText(itemtype,

879: itemkey,
880: 'CO_H_TERMS_MODIFIED',
881: x_header_control.terms_id);
882:
883: wf_engine.SetItemAttrText(itemtype,
884: itemkey,
885: 'CO_H_SHIP_VIA_MODIFIED',
886: x_header_control.ship_via_lookup_code);
887:

Line 888: wf_engine.SetItemAttrText(itemtype,

884: itemkey,
885: 'CO_H_SHIP_VIA_MODIFIED',
886: x_header_control.ship_via_lookup_code);
887:
888: wf_engine.SetItemAttrText(itemtype,
889: itemkey,
890: 'CO_H_FOB_MODIFIED',
891: x_header_control.fob_lookup_code);
892:

Line 893: wf_engine.SetItemAttrText(itemtype,

889: itemkey,
890: 'CO_H_FOB_MODIFIED',
891: x_header_control.fob_lookup_code);
892:
893: wf_engine.SetItemAttrText(itemtype,
894: itemkey,
895: 'CO_H_FREIGHT_MODIFIED',
896: x_header_control.freight_terms_lookup_code);
897:

Line 898: wf_engine.SetItemAttrText(itemtype,

894: itemkey,
895: 'CO_H_FREIGHT_MODIFIED',
896: x_header_control.freight_terms_lookup_code);
897:
898: wf_engine.SetItemAttrText(itemtype,
899: itemkey,
900: 'CO_H_NOTE_TO_VENDOR_MODIFIED',
901: x_header_control.note_to_vendor);
902:

Line 903: wf_engine.SetItemAttrText(itemtype,

899: itemkey,
900: 'CO_H_NOTE_TO_VENDOR_MODIFIED',
901: x_header_control.note_to_vendor);
902:
903: wf_engine.SetItemAttrText(itemtype,
904: itemkey,
905: 'CO_H_CONFIRMING_ORDER_MODIFIED',
906: x_header_control.confirming_order_flag);
907:

Line 908: wf_engine.SetItemAttrText(itemtype,

904: itemkey,
905: 'CO_H_CONFIRMING_ORDER_MODIFIED',
906: x_header_control.confirming_order_flag);
907:
908: wf_engine.SetItemAttrText(itemtype,
909: itemkey,
910: 'CO_H_ACCEPT_REQUIRED_MODIFIED',
911: x_header_control.acceptance_required_flag);
912:

Line 913: wf_engine.SetItemAttrText(itemtype,

909: itemkey,
910: 'CO_H_ACCEPT_REQUIRED_MODIFIED',
911: x_header_control.acceptance_required_flag);
912:
913: wf_engine.SetItemAttrText(itemtype,
914: itemkey,
915: 'CO_H_ACCEPT_DUE_MODIFIED',
916: x_header_control.acceptance_due_date);
917:

Line 919: wf_engine.SetItemAttrText(itemtype,

915: 'CO_H_ACCEPT_DUE_MODIFIED',
916: x_header_control.acceptance_due_date);
917:
918:
919: wf_engine.SetItemAttrText(itemtype,
920: itemkey,
921: 'CO_H_START_DATE_MODIFIED',
922: x_header_control.start_date);
923:

Line 924: wf_engine.SetItemAttrText(itemtype,

920: itemkey,
921: 'CO_H_START_DATE_MODIFIED',
922: x_header_control.start_date);
923:
924: wf_engine.SetItemAttrText(itemtype,
925: itemkey,
926: 'CO_H_END_DATE_MODIFIED',
927: x_header_control.end_date);
928:

Line 930: wf_engine.SetItemAttrText(itemtype,

926: 'CO_H_END_DATE_MODIFIED',
927: x_header_control.end_date);
928:
929:
930: wf_engine.SetItemAttrText(itemtype,
931: itemkey,
932: 'CO_H_CANCEL_FLAG',
933: x_header_control.cancel_flag);
934:

Line 935: wf_engine.SetItemAttrNumber(itemtype,

931: itemkey,
932: 'CO_H_CANCEL_FLAG',
933: x_header_control.cancel_flag);
934:
935: wf_engine.SetItemAttrNumber(itemtype,
936: itemkey,
937: 'CO_H_BLANKET_TOTAL_CHANGE',
938: x_header_control.blanket_total_change);
939:

Line 940: wf_engine.SetItemAttrNumber(itemtype,

936: itemkey,
937: 'CO_H_BLANKET_TOTAL_CHANGE',
938: x_header_control.blanket_total_change);
939:
940: wf_engine.SetItemAttrNumber(itemtype,
941: itemkey,
942: 'CO_H_AMOUNT_LIMIT_CHANGE',
943: x_header_control.amount_limit_change);
944:

Line 945: wf_engine.SetItemAttrText(itemtype,

941: itemkey,
942: 'CO_H_AMOUNT_LIMIT_CHANGE',
943: x_header_control.amount_limit_change);
944:
945: wf_engine.SetItemAttrText(itemtype,
946: itemkey,
947: 'CO_H_PO_ACKNOWLEDGED',
948: x_header_control.po_acknowledged);
949:

Line 950: wf_engine.SetItemAttrText(itemtype,

946: itemkey,
947: 'CO_H_PO_ACKNOWLEDGED',
948: x_header_control.po_acknowledged);
949:
950: wf_engine.SetItemAttrText(itemtype,
951: itemkey,
952: 'CO_H_PO_ACCEPTED',
953: x_header_control.po_accepted);
954:

Line 955: wf_engine.SetItemAttrNumber(itemtype,

951: itemkey,
952: 'CO_H_PO_ACCEPTED',
953: x_header_control.po_accepted);
954:
955: wf_engine.SetItemAttrNumber(itemtype,
956: itemkey,
957: 'CO_H_PO_TOTAL_CHANGE',
958: x_header_control.po_total_change);
959:

Line 962: wf_engine.SetItemAttrText(itemtype,

958: x_header_control.po_total_change);
959:
960: /* Added following for Bug 6616522 */
961:
962: wf_engine.SetItemAttrText(itemtype,
963: itemkey,
964: 'CO_H_AMOUNT_LIMIT_MODIFIED',
965: x_header_control.amount_limit);
966:

Line 987: wf_engine.GetItemAttrText(itemtype,

983: '*** In procedure get_wf_header_control ***');
984: END IF;
985:
986: x_header_control.agent_id :=
987: wf_engine.GetItemAttrText(itemtype,
988: itemkey,
989: 'CO_H_AGENT_MODIFIED');
990:
991: x_header_control.vendor_site_id :=

Line 992: wf_engine.GetItemAttrText(itemtype,

988: itemkey,
989: 'CO_H_AGENT_MODIFIED');
990:
991: x_header_control.vendor_site_id :=
992: wf_engine.GetItemAttrText(itemtype,
993: itemkey,
994: 'CO_H_VENDOR_SITE_MODIFIED');
995:
996: x_header_control.vendor_contact_id :=

Line 997: wf_engine.GetItemAttrText(itemtype,

993: itemkey,
994: 'CO_H_VENDOR_SITE_MODIFIED');
995:
996: x_header_control.vendor_contact_id :=
997: wf_engine.GetItemAttrText(itemtype,
998: itemkey,
999: 'CO_H_VENDOR_CONTACT_MODIFIED');
1000:
1001: x_header_control.ship_to_location_id :=

Line 1002: wf_engine.GetItemAttrText(itemtype,

998: itemkey,
999: 'CO_H_VENDOR_CONTACT_MODIFIED');
1000:
1001: x_header_control.ship_to_location_id :=
1002: wf_engine.GetItemAttrText(itemtype,
1003: itemkey,
1004: 'CO_H_SHIP_TO_MODIFIED');
1005:
1006: x_header_control.bill_to_location_id :=

Line 1007: wf_engine.GetItemAttrText(itemtype,

1003: itemkey,
1004: 'CO_H_SHIP_TO_MODIFIED');
1005:
1006: x_header_control.bill_to_location_id :=
1007: wf_engine.GetItemAttrText(itemtype,
1008: itemkey,
1009: 'CO_H_BILL_TO_MODIFIED');
1010:
1011: x_header_control.terms_id :=

Line 1012: wf_engine.GetItemAttrText(itemtype,

1008: itemkey,
1009: 'CO_H_BILL_TO_MODIFIED');
1010:
1011: x_header_control.terms_id :=
1012: wf_engine.GetItemAttrText(itemtype,
1013: itemkey,
1014: 'CO_H_TERMS_MODIFIED');
1015:
1016: x_header_control.ship_via_lookup_code :=

Line 1017: wf_engine.GetItemAttrText(itemtype,

1013: itemkey,
1014: 'CO_H_TERMS_MODIFIED');
1015:
1016: x_header_control.ship_via_lookup_code :=
1017: wf_engine.GetItemAttrText(itemtype,
1018: itemkey,
1019: 'CO_H_SHIP_VIA_MODIFIED');
1020:
1021: x_header_control.fob_lookup_code :=

Line 1022: wf_engine.GetItemAttrText(itemtype,

1018: itemkey,
1019: 'CO_H_SHIP_VIA_MODIFIED');
1020:
1021: x_header_control.fob_lookup_code :=
1022: wf_engine.GetItemAttrText(itemtype,
1023: itemkey,
1024: 'CO_H_FOB_MODIFIED');
1025:
1026: x_header_control.freight_terms_lookup_code :=

Line 1027: wf_engine.GetItemAttrText(itemtype,

1023: itemkey,
1024: 'CO_H_FOB_MODIFIED');
1025:
1026: x_header_control.freight_terms_lookup_code :=
1027: wf_engine.GetItemAttrText(itemtype,
1028: itemkey,
1029: 'CO_H_FREIGHT_MODIFIED');
1030:
1031: x_header_control.note_to_vendor :=

Line 1032: wf_engine.GetItemAttrText(itemtype,

1028: itemkey,
1029: 'CO_H_FREIGHT_MODIFIED');
1030:
1031: x_header_control.note_to_vendor :=
1032: wf_engine.GetItemAttrText(itemtype,
1033: itemkey,
1034: 'CO_H_NOTE_TO_VENDOR_MODIFIED');
1035:
1036: x_header_control.confirming_order_flag :=

Line 1037: wf_engine.GetItemAttrText(itemtype,

1033: itemkey,
1034: 'CO_H_NOTE_TO_VENDOR_MODIFIED');
1035:
1036: x_header_control.confirming_order_flag :=
1037: wf_engine.GetItemAttrText(itemtype,
1038: itemkey,
1039: 'CO_H_CONFIRMING_ORDER_MODIFIED');
1040:
1041: x_header_control.acceptance_required_flag :=

Line 1042: wf_engine.GetItemAttrText(itemtype,

1038: itemkey,
1039: 'CO_H_CONFIRMING_ORDER_MODIFIED');
1040:
1041: x_header_control.acceptance_required_flag :=
1042: wf_engine.GetItemAttrText(itemtype,
1043: itemkey,
1044: 'CO_H_ACCEPT_REQUIRED_MODIFIED');
1045:
1046: x_header_control.acceptance_due_date :=

Line 1047: wf_engine.GetItemAttrText(itemtype,

1043: itemkey,
1044: 'CO_H_ACCEPT_REQUIRED_MODIFIED');
1045:
1046: x_header_control.acceptance_due_date :=
1047: wf_engine.GetItemAttrText(itemtype,
1048: itemkey,
1049: 'CO_H_ACCEPT_DUE_MODIFIED');
1050:
1051: x_header_control.start_date :=

Line 1052: wf_engine.GetItemAttrText(itemtype,

1048: itemkey,
1049: 'CO_H_ACCEPT_DUE_MODIFIED');
1050:
1051: x_header_control.start_date :=
1052: wf_engine.GetItemAttrText(itemtype,
1053: itemkey,
1054: 'CO_H_START_DATE_MODIFIED');
1055:
1056: x_header_control.end_date :=

Line 1057: wf_engine.GetItemAttrText(itemtype,

1053: itemkey,
1054: 'CO_H_START_DATE_MODIFIED');
1055:
1056: x_header_control.end_date :=
1057: wf_engine.GetItemAttrText(itemtype,
1058: itemkey,
1059: 'CO_H_END_DATE_MODIFIED');
1060:
1061: x_header_control.cancel_flag :=

Line 1062: wf_engine.GetItemAttrText(itemtype,

1058: itemkey,
1059: 'CO_H_END_DATE_MODIFIED');
1060:
1061: x_header_control.cancel_flag :=
1062: wf_engine.GetItemAttrText(itemtype,
1063: itemkey,
1064: 'CO_H_CANCEL_FLAG');
1065:
1066: x_header_control.blanket_total_change :=

Line 1067: wf_engine.GetItemAttrNumber(itemtype,

1063: itemkey,
1064: 'CO_H_CANCEL_FLAG');
1065:
1066: x_header_control.blanket_total_change :=
1067: wf_engine.GetItemAttrNumber(itemtype,
1068: itemkey,
1069: 'CO_H_BLANKET_TOTAL_CHANGE');
1070:
1071: x_header_control.amount_limit_change :=

Line 1072: wf_engine.GetItemAttrNumber(itemtype,

1068: itemkey,
1069: 'CO_H_BLANKET_TOTAL_CHANGE');
1070:
1071: x_header_control.amount_limit_change :=
1072: wf_engine.GetItemAttrNumber(itemtype,
1073: itemkey,
1074: 'CO_H_AMOUNT_LIMIT_CHANGE');
1075:
1076: x_header_control.po_acknowledged:=

Line 1077: wf_engine.GetItemAttrText(itemtype,

1073: itemkey,
1074: 'CO_H_AMOUNT_LIMIT_CHANGE');
1075:
1076: x_header_control.po_acknowledged:=
1077: wf_engine.GetItemAttrText(itemtype,
1078: itemkey,
1079: 'CO_H_PO_ACKNOWLEDGED');
1080:
1081: x_header_control.po_accepted:=

Line 1082: wf_engine.GetItemAttrText(itemtype,

1078: itemkey,
1079: 'CO_H_PO_ACKNOWLEDGED');
1080:
1081: x_header_control.po_accepted:=
1082: wf_engine.GetItemAttrText(itemtype,
1083: itemkey,
1084: 'CO_H_PO_ACCEPTED');
1085:
1086: x_header_control.po_total_change:=

Line 1087: wf_engine.GetItemAttrNumber(itemtype,

1083: itemkey,
1084: 'CO_H_PO_ACCEPTED');
1085:
1086: x_header_control.po_total_change:=
1087: wf_engine.GetItemAttrNumber(itemtype,
1088: itemkey,
1089: 'CO_H_PO_TOTAL_CHANGE');
1090:
1091: /* Added following for Bug 6616522 */

Line 1093: wf_engine.GetItemAttrText(itemtype,

1089: 'CO_H_PO_TOTAL_CHANGE');
1090:
1091: /* Added following for Bug 6616522 */
1092: x_header_control.amount_limit:=
1093: wf_engine.GetItemAttrText(itemtype,
1094: itemkey,
1095: 'CO_H_AMOUNT_LIMIT_MODIFIED');
1096:
1097: debug_header_control(itemtype, itemkey, x_header_control);

Line 1116: wf_engine.GetItemAttrNumber(itemtype,

1112: '*** In procedure get_wf_header_parameters ***');
1113: END IF;
1114:
1115: x_header_parameters.po_header_id :=
1116: wf_engine.GetItemAttrNumber(itemtype,
1117: itemkey,
1118: 'DOCUMENT_ID');
1119:
1120: IF (g_po_wf_debug = 'Y') THEN