1 PACKAGE PO_AGENTS_SV1 AS
2 /* $Header: POXPIAGS.pls 120.0.12010000.1 2008/09/18 12:21:09 appldev noship $ */
3
4 /*==================================================================
5 FUNCTION NAME: derive_agent_id()
6
7 DESCRIPTION: This API is used to derive agent_id in PO_HEADERS
8 given apgent_name as an input parameter. Agent_name
9 is assumed to be the full name of the employee in
10 po_buyers_val_v.
11
12 PARAMETERS: x_agent_name IN VARCHAR2
13
14
15 DESIGN
16 REFERENCES: 832dvapi.dd
17
18 ALGORITHM: returns agent_id (NUMBER) if found; NULL otherwise.
19
20 NOTES:
21
22 OPEN ISSUES:
23
24 CLOSE ISSUES:
25
26 CHANGE
27 HISTORY: Created 03-Mar-1996 Rajan Odayar
28 Modified 12-MAR-1996 Daisy Yu
29
30 =======================================================================*/
31
32 FUNCTION derive_agent_id(X_agent_name IN VARCHAR2)return NUMBER;
33
34 /*==================================================================
35 FUNCTION NAME: val_agent_id()
36
37 DESCRIPTION: This API used to check if X_agent_id is an active and
38 valid buyer.
39
40 PARAMETERS: x_agent_id IN NUMBER
41
42
43
44 DESIGN
45 REFERENCES: 832vlapi.doc
46
47 ALGORITHM: API returns TRUE if validation succeeds; FALSE
48 otherwise.
49
50 NOTES:
51
52 OPEN ISSUES:
53
54 CLOSE ISSUES:
55
56 CHANGE
57 HISTORY: Created 03-Mar-1996 Rajan
58
59
60 =======================================================================*/
61 FUNCTION val_agent_id(x_agent_id IN NUMBER) RETURN BOOLEAN;
62
63 END PO_AGENTS_SV1;