[Home] [Help]
PACKAGE: APPS.POR_CONTRACTOR_NOTIFY
Source
1 PACKAGE POR_CONTRACTOR_NOTIFY AUTHID CURRENT_USER AS
2 /* $Header: PORGCNTS.pls 115.2 2004/06/17 18:30:23 mahmad noship $*/
3
4 /*===========================================================================
5 PROCEDURE NAME: SUPPLIER_NEED_NOTIFY
6 DESCRIPTION: Checks if supplier for this requisition needs to be notified
7 ===========================================================================*/
8
9 PROCEDURE SUPPLIER_NEED_NOTIFY (ITEMTYPE IN VARCHAR2,
10 ITEMKEY IN VARCHAR2,
11 ACTID IN NUMBER,
12 FUNCMODE IN VARCHAR2,
13 RESULTOUT OUT NOCOPY VARCHAR2 );
14
15 /*===========================================================================
16 PROCEDURE NAME: SELECT_SUPPLIER_NOTIFY
17 DESCRIPTION:
18 ===========================================================================*/
19
20 PROCEDURE SELECT_SUPPLIER_NOTIFY (ITEMTYPE IN VARCHAR2,
21 ITEMKEY IN VARCHAR2,
22 ACTID IN NUMBER,
23 FUNCMODE IN VARCHAR2,
24 RESULTOUT OUT NOCOPY VARCHAR2 );
25
26 /*===========================================================================
27 PROCEDURE NAME: UPDATE_NOTIFY_SUPPLIER
28 DESCRIPTION:
29 ===========================================================================*/
30
31 PROCEDURE UPDATE_NOTIFY_SUPPLIER (ITEMTYPE IN VARCHAR2,
32 ITEMKEY IN VARCHAR2,
33 ACTID IN NUMBER,
34 FUNCMODE IN VARCHAR2,
35 RESULTOUT OUT NOCOPY VARCHAR2 );
36
37 /*===========================================================================
38 FUNCTION NAME: GET_ADHOC_EMAIL_ROLE
39 DESCRIPTION: RETURNS ADHOC ROLE BASED ON THE EMAIL ADDRESS IN VENDOR SITE AND VENDOR CONTACT
40 ===========================================================================*/
41
42 FUNCTION GET_ADHOC_EMAIL_ROLE(L_REQ_SUPPLIER_ID NUMBER,
43 L_REQ_LINE_ID NUMBER,
44 ITEMTYPE VARCHAR2,
45 ITEMKEY VARCHAR2)
46 RETURN varchar2;
47
48 /*===========================================================================
49 PROCEDURE NAME: SET_REQSINPOOL_FLAG
50 DESCRIPTION: Sets the REQS_IN_POOL flag in the po_requisition_lines_all table to 'Y'
51 ===========================================================================*/
52
53 PROCEDURE SET_REQSINPOOL_FLAG (ITEMTYPE IN VARCHAR2,
54 ITEMKEY IN VARCHAR2,
55 ACTID IN NUMBER,
56 FUNCMODE IN VARCHAR2,
57 RESULTOUT OUT NOCOPY VARCHAR2 );
58
59 END POR_CONTRACTOR_NOTIFY;
60