1 PACKAGE INV_ITEM_DATA_SCRIPTS AUTHID CURRENT_USER AS
2 /* $Header: INVIDSES.pls 120.2 2011/08/30 11:00:41 ccsingh noship $ */
3
4 /* Main procedure that gets called from the concurrent program
5 'Items Data Scripts Execution' (INVIDSEP)*/
6 PROCEDURE run_data_scripts(
7 errbuf OUT NOCOPY VARCHAR2,
8 retcode OUT NOCOPY NUMBER);
9
10
11 /* Procedure to modify internal_ordered_flag, internal_order_enabled flag and shippable flag.
12 This datafix was originally given through bug 7572178 (datafix) and was necessiated
13 due to the functional change introduced through bug 5533216 */
14 PROCEDURE proc_io_shippable_flags(
15 errbuf OUT NOCOPY VARCHAR2,
16 retcode OUT NOCOPY NUMBER);
17 -- added as part of bug 12927243
18 /* Procedure to call generic script that updates the mtl_item_categories table
19 to correct the following conditions
20 Note: This is valid only for Master Controlled Category Sets and is valid
21 for both single and multi assignment category sets.
22 Case 1: There are category assignments at the master and child
23 organizations, but the values are not the same.
24 Case 2: There are category assignments at the master and child organizations
25 that have the same values, but there are also an additional category
26 assigment record for the child organization.
27 Case 3: There are category assignments in the master organization for which
28 there is no corresponding child organization category assignment. */
29
30 PROCEDURE proc_cat_datafix(
31 errbuf OUT NOCOPY VARCHAR2,
32 retcode OUT NOCOPY NUMBER);
33
34 END INV_ITEM_DATA_SCRIPTS;
[Home] [Help]