[Home] [Help]
PACKAGE: APPS.MSC_CL_MISCELLANEOUS
Source
1 PACKAGE MSC_CL_MISCELLANEOUS AUTHID CURRENT_USER AS -- specification
2 /* $Header: MSCCLGAS.pls 120.0 2005/05/25 19:52:59 appldev noship $ */
3
4 ----- CONSTANTS --------------------------------------------------------
5
6 SYS_YES CONSTANT NUMBER := 1;
7 SYS_NO CONSTANT NUMBER := 2;
8
9 G_SUCCESS CONSTANT NUMBER := 0;
10 G_WARNING CONSTANT NUMBER := 1;
11 G_ERROR CONSTANT NUMBER := 2;
12
13 G_APPS107 CONSTANT NUMBER := 1;
14 G_APPS110 CONSTANT NUMBER := 2;
15 G_APPS115 CONSTANT NUMBER := 3;
16
17 G_INS_DISCRETE CONSTANT NUMBER := 1;
18 G_INS_PROCESS CONSTANT NUMBER := 2;
19 G_INS_OTHER CONSTANT NUMBER := 3;
20 G_INS_MIXED CONSTANT NUMBER := 4;
21
22 -- STAGING TABLE STATUS --
23
24 G_ST_EMPTY CONSTANT NUMBER := 0; -- no instance data exists;
25 G_ST_PULLING CONSTANT NUMBER := 1;
26 G_ST_READY CONSTANT NUMBER := 2;
27 G_ST_COLLECTING CONSTANT NUMBER := 3;
28
29 ----- PARAMETERS --------------------------------------------------------
30
31 v_lrn NUMBER; -- Last Refresh Number
32 v_crn NUMBER; -- Current Refresh Number
33 v_refresh_number NUMBER;
34 v_instance_id NUMBER;
35 v_dblink VARCHAR2(128);
36 v_current_date DATE;
37 v_current_user NUMBER;
38 v_request_id NUMBER;
39 v_last_calculated_date DATE;
40
41 v_debug BOOLEAN := FALSE;
42
43 v_cp_enabled NUMBER; -- SYS_YES: This program is launched as a concurrent program.
44
45 -- ================== Worker Status ===================
46
47 OK CONSTANT NUMBER := 1;
48 FAIL CONSTANT NUMBER := 0;
49
50 ---------------------- Task Number ----------------------------
51
52 UNRESOLVABLE_ERROR CONSTANT NUMBER := -9999999;
53
54 ----------------------------------------------------------
55 v_sql_stmt VARCHAR2(4000);
56
57 -- ================= Procedures ====================
58
59 PROCEDURE load_sourcing_history
60 ( arg_instance_id IN NUMBER,
61 arg_refresh_number IN NUMBER,
62 arg_current_date IN DATE,
63 arg_current_user IN NUMBER,
64 arg_request_id IN NUMBER );
65
66 PROCEDURE load_po_receipts
67 ( arg_instance_id IN NUMBER,
68 arg_org_sub_str IN VARCHAR2 := NULL,
69 arg_refresh_number IN NUMBER,
70 arg_current_date IN DATE,
71 arg_current_user IN NUMBER,
72 arg_request_id IN NUMBER );
73
74 PROCEDURE load_sourcing_history_sub1
75 ( arg_assignment_set_id IN NUMBER );
76
77 PROCEDURE get_sourcing_history
78 ( arg_source_org IN NUMBER,
79 arg_sr_supplier_id IN NUMBER,
80 arg_supplier_id IN NUMBER,
81 arg_sr_supplier_site_id IN NUMBER,
82 arg_supplier_site_id IN NUMBER,
83 arg_sr_item_id IN NUMBER,
84 arg_item_id IN NUMBER,
85 arg_org_id IN NUMBER,
86 arg_sourcing_rule_id IN NUMBER,
87 arg_start_date IN DATE,
88 arg_end_date IN DATE );
89
90 FUNCTION inner_org_trx_qty
91 ( arg_inventory_item_id IN NUMBER,
92 arg_organization_id IN NUMBER,
93 arg_start_date IN DATE,
94 arg_end_date IN DATE)
95 RETURN NUMBER;
96
97 FUNCTION inter_org_trx_qty
98 ( arg_inventory_item_id IN NUMBER,
99 arg_organization_id IN NUMBER,
100 arg_source_org_id IN NUMBER,
101 arg_start_date IN DATE,
102 arg_end_date IN DATE)
103 RETURN NUMBER;
104
105 FUNCTION po_supplier_trx_qty
106 ( arg_inventory_item_id IN NUMBER,
107 arg_organization_id IN NUMBER,
108 arg_supplier_id IN NUMBER,
109 arg_supplier_site_id IN NUMBER,
110 arg_start_date IN DATE,
111 arg_end_date IN DATE)
112 RETURN NUMBER;
113
114 PROCEDURE LOG_MESSAGE( pBUFF IN VARCHAR2);
115
116 END MSC_CL_MISCELLANEOUS;