[Home] [Help]
PACKAGE: APPS.MRP_SOURCING_API_PK
Source
1 PACKAGE MRP_SOURCING_API_PK AUTHID CURRENT_USER AS
2 /* $Header: MRPSAPIS.pls 120.1 2005/06/17 09:25:39 ichoudhu noship $ */
3
4 SYS_YES CONSTANT INTEGER := 1;
5 SYS_NO CONSTANT INTEGER := 2;
6 NULL_VALUE constant number := -23453;
7
8 FUNCTION mrp_sourcing(
9 arg_mode IN VARCHAR2,
10 arg_item_id IN NUMBER,
11 arg_commodity_id IN NUMBER,
12 arg_dest_organization_id IN NUMBER,
13 arg_dest_subinventory IN VARCHAR2,
14 arg_autosource_date IN DATE,
15 arg_vendor_id OUT NOCOPY NUMBER,
16 arg_vendor_site_id OUT NOCOPY NUMBER,
17 arg_source_organization_id IN OUT NOCOPY NUMBER,
18 arg_source_subinventory IN OUT NOCOPY VARCHAR2,/* Bug # 1646303 - changed */
19 /* datatype to varchar2 */
20 arg_sourcing_rule_id OUT NOCOPY NUMBER,
21 arg_error_message OUT NOCOPY VARCHAR2)
22 RETURN BOOLEAN;
23
24 FUNCTION mrp_sourcing(
25 arg_mode IN VARCHAR2,
26 arg_item_id IN NUMBER,
27 arg_commodity_id IN NUMBER,
28 arg_dest_organization_id IN NUMBER,
29 arg_dest_subinventory IN VARCHAR2,
30 arg_autosource_date IN DATE,
31 arg_vendor_id OUT NOCOPY NUMBER,
32 arg_vendor_site_code OUT NOCOPY VARCHAR2,
33 arg_source_organization_id IN OUT NOCOPY NUMBER,
34 arg_source_subinventory IN OUT NOCOPY VARCHAR2,
35 arg_sourcing_rule_id OUT NOCOPY NUMBER,
36 arg_error_message OUT NOCOPY VARCHAR2)
37 RETURN BOOLEAN;
38
39 MPS_CONSUME_PROFILE_VALUE NUMBER := FND_PROFILE.value('MPS_CONSUME_PROFILE_VALUE');
40
41 FUNCTION mrp_sourcing_rule_exists
42 (
43 arg_item_id IN NUMBER,
44 arg_category_id IN NUMBER,
45 arg_supplier_id IN NUMBER,
46 arg_supplier_site_id IN NUMBER,
47 arg_message OUT NOCOPY VARCHAR2
48 ) RETURN NUMBER;
49
50 FUNCTION MRP_GET_SOURCING_HISTORY(
51 arg_source_org IN NUMBER,
52 arg_vendor_id IN NUMBER,
53 arg_vendor_site_id IN NUMBER,
54 arg_item_id IN NUMBER,
55 arg_org_id IN NUMBER,
56 arg_sourcing_rule_id IN NUMBER,
57 arg_start_date IN OUT
58 NOCOPY NUMBER,
59 arg_end_date IN NUMBER,
60 arg_err_mesg OUT NOCOPY VARCHAR2)
61 RETURN NUMBER;
62
63 FUNCTION mrp_po_historical_alloc(
64 arg_source_org IN NUMBER,
65 arg_vendor_id IN NUMBER,
66 arg_vendor_site_id IN NUMBER,
67 arg_item_id IN NUMBER,
68 arg_org_id IN NUMBER,
69 arg_start_date IN DATE,
70 arg_end_date IN DATE)
71 RETURN NUMBER;
72 PRAGMA RESTRICT_REFERENCES (mrp_po_historical_alloc, WNDS);
73
74 END MRP_SOURCING_API_PK;