1 package CTO_UPDATE_CONFIGS_PK AUTHID CURRENT_USER as
2 /* $Header: CTOUCFGS.pls 115.8 2004/03/06 00:29:39 kkonada noship $*/
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 x_return_status out NOCOPY varchar2,
65 x_msg_count out NOCOPY number,
66 x_msg_data out NOCOPY varchar2);
67
68 PROCEDURE populate_config(
69 p_changed_src IN varchar2,
70 p_open_lines IN varchar2,
71 p_config_id IN number,
72 x_return_status out NOCOPY varchar2,
73 x_msg_count out NOCOPY number,
74 x_msg_data out NOCOPY varchar2);
75
76 PROCEDURE populate_bcolu_from_bac(
77 p_config_id IN number,
78 x_return_status out NOCOPY varchar2,
79 x_msg_count out NOCOPY number,
80 x_msg_data out NOCOPY varchar2);
81
82
83 PROCEDURE populate_child_config(
84 t_bcol IN OUT NOCOPY bcol_tab,
85 p_parent_index IN NUMBER,
86 p_child_config_id IN NUMBER,
87 x_return_status out NOCOPY varchar2,
88 x_msg_count out NOCOPY number,
89 x_msg_data out NOCOPY varchar2);
90
91
92 PROCEDURE populate_link_to_line_id(
93 p_bcol_tab IN OUT NOCOPY bcol_tab,
94 x_return_status OUT NOCOPY varchar2);
95
96
97 PROCEDURE populate_plan_level(
98 p_t_bcol IN OUT NOCOPY bcol_tab,
99 x_return_status OUT NOCOPY varchar2);
100
101
102 PROCEDURE populate_wip_supply_type(
103 p_t_bcol IN OUT NOCOPY bcol_tab,
104 x_return_status OUT NOCOPY varchar2);
105
106
107 PROCEDURE populate_parent_ato(
108 p_t_bcol in out NOCOPY bcol_tab,
109 p_bcol_line_id in bom_cto_order_lines.line_id%type,
110 x_return_status OUT NOCOPY varchar2);
111
112
113 PROCEDURE contiguous_to_sparse_bcol(
114 p_t_bcol in out NOCOPY bcol_tab,
115 x_return_status OUT NOCOPY varchar2);
116
117
118 PROCEDURE WriteToLog (p_message in varchar2 default null,
119 p_level in number default 0);
120
121
122 PROCEDURE Write_Config_Status(
123 x_return_status out NOCOPY varchar2);
124
125 --bugfix 3259017
126 --added no copy to out variables
127 Procedure update_atp_attributes(
128 p_item IN Number,
129 p_cat_id IN Number,
130 p_config_id IN Number,
131 x_return_status OUT NOCOPY varchar2,
132 x_msg_data OUT NOCOPY Varchar2,
133 x_msg_count OUT NOCOPY Number);
134
135
136
137 END CTO_UPDATE_CONFIGS_PK;