DBA Data[Home] [Help]

PACKAGE: APPS.PO_PALT_ASSIGNMENTS

Source


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;