1 PACKAGE CSTPSCCR AUTHID CURRENT_USER AS
2 /* $Header: CSTSCCRS.pls 120.0 2005/05/25 05:56:27 appldev noship $ */
3
4 FUNCTION cstrlock (
5 table_name IN VARCHAR2,
6 l_dest_cost_type_id IN NUMBER,
7 l_default_cost_type_id IN NUMBER,
8 l_rollup_id IN NUMBER,
9 err_buf OUT NOCOPY VARCHAR2,
10 l_locking_flag IN NUMBER := 2
11 )
12 RETURN INTEGER;
13
14 FUNCTION cstrwait_lock(
15 l_dest_cost_type_id IN NUMBER,
16 l_default_cost_type_id IN NUMBER,
17 l_rollup_id IN NUMBER,
18 err_buf OUT NOCOPY VARCHAR2,
19 l_locking_flag IN NUMBER := 2
20 )
21 RETURN INTEGER;
22
23 FUNCTION remove_rolledup_costs(
24 p_rollup_id IN NUMBER,
25 p_rollup_date IN VARCHAR2,
26 p_buy_cost_type_id IN NUMBER,
27 p_dest_cost_type_id IN NUMBER,
28 p_conc_flag IN NUMBER,
29 req_id IN NUMBER,
30 prgm_appl_id IN NUMBER,
31 prgm_id IN NUMBER,
32 x_err_buf OUT NOCOPY VARCHAR2,
33 p_lot_size_option IN NUMBER := NULL, -- SCAPI: dynamic lot size
34 p_lot_size_setting IN NUMBER := NULL,
35 p_locking_flag IN NUMBER := 2 -- Bug 3111820
36 )
37 RETURN INTEGER;
38
39 FUNCTION cstsccru (
40 l_rollup_id IN NUMBER,
41 req_id IN NUMBER,
42 l_buy_cost_type_id IN NUMBER,
43 l_dest_cost_type_id IN NUMBER,
44 l_assignment_set_id IN NUMBER,
45 prgm_appl_id IN NUMBER,
46 prgm_id IN NUMBER,
47 l_last_updated_by IN NUMBER,
48 conc_flag IN NUMBER,
49 unimp_flag IN NUMBER,
50 locking_flag IN NUMBER,
51 rollup_date IN VARCHAR2,
52 revision_date IN VARCHAR2,
53 alt_bom_designator IN VARCHAR2,
54 alt_rtg_designator IN VARCHAR2,
55 rollup_option IN NUMBER,
56 report_option IN NUMBER,
57 l_mfg_flag IN NUMBER,
58 err_buf OUT NOCOPY VARCHAR2,
59 buy_cost_detail IN NUMBER := NULL -- SCAPI: option to perserve buy cost details
60 )
61 RETURN INTEGER;
62
63 PROCEDURE populate_markup_costs (
64 l_rollup_id IN NUMBER,
65 l_item_id IN NUMBER,
66 l_org_id IN NUMBER,
67 l_assignment_set_id IN NUMBER,
68 l_buy_cost_type_id IN NUMBER,
69 l_dest_cost_type_id IN NUMBER,
70 x_err_code OUT NOCOPY NUMBER,
71 x_err_buf OUT NOCOPY VARCHAR2);
72
73 PROCEDURE populate_buy_costs (
74 l_rollup_id IN NUMBER,
75 l_assignment_set_id IN NUMBER,
76 l_item_id IN NUMBER,
77 l_org_id IN NUMBER,
78 l_buy_cost_type_id IN NUMBER,
79 x_err_code OUT NOCOPY NUMBER,
80 x_err_buf OUT NOCOPY VARCHAR2);
81
82 PROCEDURE populate_shipping_costs (
83 l_rollup_id IN NUMBER,
84 l_item_id IN NUMBER,
85 l_org_id IN NUMBER,
86 l_assignment_set_id IN NUMBER,
87 l_buy_cost_type_id IN NUMBER,
88 l_dest_cost_type_id IN NUMBER,
89 x_err_code OUT NOCOPY NUMBER,
90 x_err_buf OUT NOCOPY VARCHAR2);
91
92
93 FUNCTION process_sc_rollup_op_yields(
94 ext_precision IN NUMBER,
95 l_rollup_id IN NUMBER,
96 conc_flag IN NUMBER,
97 req_id IN NUMBER,
98 prgm_appl_id IN NUMBER,
99 prgm_id IN NUMBER,
100 l_last_updated_by IN NUMBER,
101 alt_rtg_designator IN VARCHAR2,
102 rollup_date IN VARCHAR2,
103 l_organization_id IN NUMBER,
104 l_level IN NUMBER,
105 l_cost_type_id IN NUMBER,
106 -- Output error message for bug 3097347
107 x_err_buf OUT NOCOPY VARCHAR2)
108 return NUMBER;
109
110 function supply_chain_snapshot (
111 l_rollup_id in number,
112 l_cost_type_id in number,
113 l_mfg_flag in number,
114 alt_bom_designator in varchar2,
115 l_conc_flag in number,
116 l_unimp_flag in number,
117 revision_date in varchar2,
118 l_last_updated_by in number,
119 l_rollup_date in varchar2,
120 req_id in number,
121 p_prg_appl_id in number,
122 p_prg_id in number,
123 err_buf out NOCOPY varchar2)
124 return integer;
125
126 SLEEP_TIME CONSTANT number := 10;
127 NUM_TRIES CONSTANT number := 10;
128
129
130 END CSTPSCCR;