1 package CSTPSCEX AUTHID CURRENT_USER as
2 /* $Header: CSTSCEXS.pls 120.1 2011/04/21 12:10:31 pbasrani ship $ */
3
4
5 -- This procedure expects that top level assemblies to be inserted
6 -- into CST_SC_LISTS with the appropriate rollup_id first. This
7 -- is the same rollup_id that is expected by the procedure call.
8
9 procedure supply_chain_rollup (
10 i_rollup_id in number, -- rollup ID, CST_LISTS_S
11 i_explosion_levels in number, -- levels to explode, NULL for all levels
12 i_report_levels in number, -- levels in report, NULL for no report
13 i_assignment_set_id in number, -- MRP assignment_set_id, NULL for none
14 i_conversion_type in varchar2, -- GL_DAILY_CONVERSION_TYPES
15 i_cost_type_id in number, -- rollup cost type
16 i_buy_cost_type_id in number, -- buy cost cost type
17 i_effective_date in date, -- BIC.effectivity_date
18 i_exclude_unimpl_eco in number, -- 1 = exclude unimplemented, 2 = include
19 i_exclude_eng in number, -- 1 = exclude eng items, 2 = include
20 i_alt_bom_desg in varchar2, -- alternate BOM designator
21 i_alt_rtg_desg in varchar2, -- alternate routing designator
22 i_lock_flag in number, -- 1 = wait for locks, 2 = no
23 i_user_id in number,
24 i_login_id in number,
25 i_request_id in number,
26 i_prog_id in number,
27 i_prog_appl_id in number,
28 o_error_code out NOCOPY number,
29 o_error_msg out NOCOPY varchar2,
30 i_lot_size_option in number := null, -- SCAPI: dynamic lot size
31 i_lot_size_setting in number := null,
32 i_report_option_type in number := null,
33 i_report_type_type in number := null,
34 i_buy_cost_detail in number := null
35 );
36
37
38
39 procedure snapshot_sc_bom_structures (
40 i_rollup_id in number,
41 i_cost_type_id in number,
42 i_report_levels in number,
43 i_effective_date in date,
44 i_user_id in number,
45 i_login_id in number,
46 i_request_id in number,
47 i_prog_id in number,
48 i_prog_appl_id in number,
49 o_error_code out NOCOPY number,
50 o_error_msg out NOCOPY varchar2,
51 i_report_type_type in number := null -- SCAPI: support consolidated report
52 );
53
54
55
56 end CSTPSCEX;