1 PACKAGE PO_PALT_ASSIGNMENTS AUTHID CURRENT_USER AS
2 /* $Header: POPTASGS.pls 120.11.12020000.2 2013/02/11 02:02:24 vegajula ship $ */
3
4 TYPE Req_Details IS RECORD (Requisition_line_Id NUMBER);
5 TYPE Requisition_Details is table of Req_Details INDEX BY BINARY_INTEGER;
6
7 Function GetAssignmentNumber(pReqLInes IN VARCHAR2) RETURN VARCHAR2;
8
9 Procedure ManageAssignementAction
10 (pAssignmentId IN NUMBER,
11 pOldBuyerId IN NUMBER,
12 pnewBuyerId IN NUMBER,
13 pOldStatus IN NUMBER,
14 pNewStatus IN NUMBER,
15 pReason IN VARCHAR2
16 );
17
18 PROCEDURE getAssociatedReqLines(pReqLineId IN NUMBER,
19 x_associated_line_ids OUT NOCOPY PO_TBL_NUMBER);
20
21 PROCEDURE removeLinesFromAssignments(pAssignmentNums IN PO_TBL_VARCHAR30
22 ,pLineIds IN PO_TBL_VARCHAR30
23 ,xReturnStatus OUT NOCOPY VARCHAR2
24 ,xErrAssigmentNums OUT NOCOPY PO_TBL_VARCHAR30);
25
26 PROCEDURE launchNotifyByrWf (pAssignmentId IN NUMBER);
27
28 PROCEDURE launchNotifyByrWf (pAssignmentId IN NUMBER,
29 pPrevBuyerId IN NUMBER,
30 pReason IN VARCHAR2);
31
32 Function GetCurrencyCode(pAssignmentNum IN VARCHAR2) RETURN VARCHAR2;
33
34 FUNCTION GetLineFuncCurrCode(p_org_id IN NUMBER) RETURN VARCHAR2;
35
36 FUNCTION GetReqLineFuncCurrCode(p_line_id IN NUMBER) RETURN VARCHAR2;
37
38 Procedure updateSuggestedBuyer(pAssignmentId IN NUMBER, pnewBuyerId IN NUMBER);
39
40 --<PAR Project> : Create autoassignmnet for pAR at the end of PAR approval
41 PROCEDURE create_auto_assignment_for_par(itemtype IN VARCHAR2,
42 itemkey IN VARCHAR2,
43 actid IN NUMBER,
44 funcmode IN VARCHAR2,
45 resultout OUT NOCOPY VARCHAR2);
46
47 END PO_PALT_ASSIGNMENTS;