APPS.PO_CHANGE_RESPONSE_PVT dependencies on WF_ITEM

Line 62: WF_Item_type, WF_Item_key, Parent_Change_Request_Id, Validation_Error,

58: Old_Supplier_Reference_Number, New_Supplier_Reference_Number,
59: Requester_Id, Responded_by, Response_date, Response_Reason,
60: Old_Currency_Unit_Price, New_Currency_Unit_Price,
61: Recoverable_Tax, Nonrecoverable_Tax,
62: WF_Item_type, WF_Item_key, Parent_Change_Request_Id, Validation_Error,
63: Approval_Required_Flag, Old_Supplier_Order_Number, New_Supplier_Order_Number,
64: Old_Supplier_Order_Line_Number, New_Supplier_Order_Line_Number,Old_Amount,New_Amount) -- Added Amount for FPS Changes
65: SELECT
66: PCR.Change_Request_Group_Id,

Line 88: PCR.WF_Item_type, PCR.WF_Item_key, PCR.Parent_Change_Request_Id,

84: PCR.Old_Supplier_Reference_Number, PCR.New_Supplier_Reference_Number,
85: PCR.Requester_Id, PCR.Responded_by, PCR.Response_date, PCR.Response_Reason,
86: PCR.Old_Currency_Unit_Price, PCR.New_Currency_Unit_Price,
87: PCR.Recoverable_Tax, PCR.Nonrecoverable_Tax,
88: PCR.WF_Item_type, PCR.WF_Item_key, PCR.Parent_Change_Request_Id,
89: PCR.Validation_Error, PCR.Approval_Required_Flag,
90: PCR.Old_Supplier_Order_Number, PCR.New_Supplier_Order_Number,
91: PCR.Old_Supplier_Order_Line_Number, PCR.New_Supplier_Order_Line_Number,PCR.Old_Amount,PCR.New_Amount
92: FROM po_change_requests PCR, po_distributions_all POD

Line 775: l_wf_item_key po_change_requests.wf_item_key%TYPE;

771: p_line_location_id in NUMBER,
772: p_splitFlag in VARCHAR2,
773: p_cancel_backing_req in VARCHAR2) is
774:
775: l_wf_item_key po_change_requests.wf_item_key%TYPE;
776: l_wf_item_type po_change_requests.wf_item_type%TYPE;
777:
778: BEGIN
779:

Line 776: l_wf_item_type po_change_requests.wf_item_type%TYPE;

772: p_splitFlag in VARCHAR2,
773: p_cancel_backing_req in VARCHAR2) is
774:
775: l_wf_item_key po_change_requests.wf_item_key%TYPE;
776: l_wf_item_type po_change_requests.wf_item_type%TYPE;
777:
778: BEGIN
779:
780: -- first update the line or shipment record in po_change_requests

Line 811: select wf_item_type, wf_item_key

807:
808:
809: begin
810:
811: select wf_item_type, wf_item_key
812: into l_wf_item_type, l_wf_item_key
813: from po_change_requests
814: where change_request_id = p_change_request_id;
815:

Line 812: into l_wf_item_type, l_wf_item_key

808:
809: begin
810:
811: select wf_item_type, wf_item_key
812: into l_wf_item_type, l_wf_item_key
813: from po_change_requests
814: where change_request_id = p_change_request_id;
815:
816: if (Wf_Item.Item_Exist(l_wf_item_type, l_wf_item_key)) then

Line 816: if (Wf_Item.Item_Exist(l_wf_item_type, l_wf_item_key)) then

812: into l_wf_item_type, l_wf_item_key
813: from po_change_requests
814: where change_request_id = p_change_request_id;
815:
816: if (Wf_Item.Item_Exist(l_wf_item_type, l_wf_item_key)) then
817:
818: wf_engine.abortprocess(l_wf_item_type, l_wf_item_key);
819:
820: end if;

Line 818: wf_engine.abortprocess(l_wf_item_type, l_wf_item_key);

814: where change_request_id = p_change_request_id;
815:
816: if (Wf_Item.Item_Exist(l_wf_item_type, l_wf_item_key)) then
817:
818: wf_engine.abortprocess(l_wf_item_type, l_wf_item_key);
819:
820: end if;
821:
822: exception when others then