1 package CTO_UPDATE_CONFIGS_PK AUTHID CURRENT_USER as
2 /* $Header: CTOUCFGS.pls 120.1.12020000.2 2012/07/05 09:39:31 ntungare ship $*/
3 /*----------------------------------------------------------------------------+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA
5 | All rights reserved.
6 | Oracle Manufacturing
7 |
8 |FILE NAME : CTOUCFGS.pls
9 |
10 |DESCRIPTION : Contains modules to :
11 |
12 |HISTORY : Created on 9-SEP-2003 by Sajani Sheth
13 |
14 | 01/27/04 Kiran Konada
15 | bugfix 3397123
16 | Changed the signature of Update_Configs
17 | To take in new parameters
18 | p_category_set_id
19 | p_dummy3
20 | The above two parameters are NOt used in the code,
21 | they had to be in teh signature as they are in Conc
22 | program definition
23 |
24 |
25 +-----------------------------------------------------------------------------*/
26
27 BAC_PROGRAM_ID NUMBER := 99;
28 G_BATCH_SIZE NUMBER := 100;
29 TYPE BCOL_TAB is TABLE of bom_cto_order_lines%rowtype index by binary_integer;
30 gDebugLevel NUMBER := to_number(nvl(FND_PROFILE.value('ONT_DEBUG_LEVEL'),0));
31
32 /***********************************************************************
33 This procedure is called by the Update Existing Configurations batch
34 progam.
35 ***********************************************************************/
36 PROCEDURE update_configs
37 (
38 errbuf OUT NOCOPY varchar2,
39 retcode OUT NOCOPY varchar2,
40 p_item IN number,
41 p_dummy IN varchar2,
42 p_dummy2 IN varchar2,
43 p_category_set_id IN number, --bugfix 3397123
44 p_dummy3 IN number, --bugfix 3397123
45 p_cat_id IN number,
46 p_config_id IN number,
47 p_changed_src IN varchar2,
48 p_open_lines IN varchar2,
49 p_upgrade_mode In Number
50 );
51
52
53 PROCEDURE populate_all_models(
54 p_changed_src IN varchar2,
55 p_open_lines IN varchar2,
56 x_return_status out NOCOPY varchar2,
57 x_msg_count out NOCOPY number,
58 x_msg_data out NOCOPY varchar2);
59
60 PROCEDURE populate_cat_models(
61 p_cat_id IN number,
62 p_changed_src IN varchar2,
63 p_open_lines IN varchar2,
64 -- bug 13876670
65 p_category_set_id IN NUMBER,
66 x_return_status out NOCOPY varchar2,
67 x_msg_count out NOCOPY number,
68 x_msg_data out NOCOPY varchar2);
69
70 PROCEDURE populate_config(
71 p_changed_src IN varchar2,
72 p_open_lines IN varchar2,
73 p_config_id IN number,
74 x_return_status out NOCOPY varchar2,
75 x_msg_count out NOCOPY number,
76 x_msg_data out NOCOPY varchar2);
77
78 PROCEDURE populate_bcolu_from_bac(
79 p_config_id IN number,
80 x_return_status out NOCOPY varchar2,
81 x_msg_count out NOCOPY number,
82 x_msg_data out NOCOPY varchar2);
83
84
85 PROCEDURE populate_child_config(
86 t_bcol IN OUT NOCOPY bcol_tab,
87 p_parent_index IN NUMBER,
88 p_child_config_id IN NUMBER,
89 x_return_status out NOCOPY varchar2,
90 x_msg_count out NOCOPY number,
91 x_msg_data out NOCOPY varchar2);
92
93
94 PROCEDURE populate_link_to_line_id(
95 p_bcol_tab IN OUT NOCOPY bcol_tab,
96 x_return_status OUT NOCOPY varchar2);
97
98
99 PROCEDURE populate_plan_level(
100 p_t_bcol IN OUT NOCOPY bcol_tab,
101 x_return_status OUT NOCOPY varchar2);
102
103
104 PROCEDURE populate_wip_supply_type(
105 p_t_bcol IN OUT NOCOPY bcol_tab,
106 x_return_status OUT NOCOPY varchar2);
107
108
109 PROCEDURE populate_parent_ato(
110 p_t_bcol in out NOCOPY bcol_tab,
111 p_bcol_line_id in bom_cto_order_lines.line_id%type,
112 x_return_status OUT NOCOPY varchar2);
113
114
115 PROCEDURE contiguous_to_sparse_bcol(
116 p_t_bcol in out NOCOPY bcol_tab,
117 x_return_status OUT NOCOPY varchar2);
118
119
120 PROCEDURE WriteToLog (p_message in varchar2 default null,
121 p_level in number default 0);
122
123
124 PROCEDURE Write_Config_Status(
125 x_return_status out NOCOPY varchar2,
126 --Bugfix 13362916
127 x_return_code out NOCOPY number);
128
129 --bugfix 3259017
130 --added no copy to out variables
131 Procedure update_atp_attributes(
132 p_item IN Number,
133 p_cat_id IN Number,
134 p_config_id IN Number,
135 x_return_status OUT NOCOPY varchar2,
136 x_msg_data OUT NOCOPY Varchar2,
137 x_msg_count OUT NOCOPY Number);
138
139
140
141 END CTO_UPDATE_CONFIGS_PK;