[Home] [Help]
PACKAGE: APPS.MSC_CL_COPY_STG_TBL
Source
1 PACKAGE MSC_CL_COPY_STG_TBL AUTHID CURRENT_USER AS
2 /* $Header: MSCCOPYS.pls 120.1.12010000.2 2009/08/27 19:43:27 harshsha noship $ */
3
4 -- ================= Procedures ====================
5
6 v_sql_stmt VARCHAR2(32767);
7 G_ST_EMPTY CONSTANT NUMBER := 0; -- no instance data exists;
8 G_ST_PULLING CONSTANT NUMBER := 1;
9 G_ST_READY CONSTANT NUMBER := 2;
10 G_ST_COLLECTING CONSTANT NUMBER := 3;
11 G_ST_PURGING CONSTANT NUMBER := 4;
12
13
14 PROCEDURE LAUNCH_MONITOR( ERRBUF OUT NOCOPY VARCHAR2,
15 RETCODE OUT NOCOPY NUMBER,
16 pINSTANCE_ID IN NUMBER,
17 pSRC_INSTANCE_ID IN NUMBER,
18 pTIMEOUT IN NUMBER,
19 pTotalWorkerNum IN NUMBER,
20 RP_Source_Indicator IN NUMBER);
21 PROCEDURE COPY_CALENDAR_DATES ;
22 PROCEDURE COPY_RESOURCE_REQUIREMENTS ;
23 PROCEDURE COPY_ROUTING_OPERATIONS ;
24 PROCEDURE COPY_SOURCING_HISTORY ;
25 PROCEDURE COPY_SOURCING_RULES ;
26 PROCEDURE COPY_TRADING_PARTNER_SITES ;
27 PROCEDURE COPY_TRADING_PARTNERS ;
28 PROCEDURE COPY_APPS_INSTANCES ;
29 PROCEDURE COPY_ASSIGNMENT_SETS ;
30 PROCEDURE COPY_ATP_RULES ;
31 PROCEDURE COPY_BILL_OF_RESOURCES ;
32 PROCEDURE COPY_DEMANDS ;
33 PROCEDURE COPY_BIS_BUSINESS_PLANS ;
34 PROCEDURE COPY_BIS_PERIODS ;
35 PROCEDURE COPY_BIS_PFMC_MEASURES ;
36 PROCEDURE COPY_BIS_TARGET_LEVELS ;
37 PROCEDURE COPY_BIS_TARGETS ;
38 PROCEDURE COPY_BOR_REQUIREMENTS ;
39 PROCEDURE COPY_CAL_WEEK_START_DATES ;
40 PROCEDURE COPY_CAL_YEAR_START_DATES ;
41 PROCEDURE COPY_CALENDAR_ASSIGNMENTS ;
42 PROCEDURE COPY_CALENDAR_EXCEPTIONS ;
43 PROCEDURE COPY_ITEM_CATEGORIES ;
44 PROCEDURE COPY_CALENDAR_SHIFTS ;
45 PROCEDURE COPY_CALENDARS ;
46 PROCEDURE COPY_CARRIER_SERVICES ;
47 PROCEDURE COPY_CATEGORY_SETS ;
48 PROCEDURE COPY_CO_PRODUCTS ;
49 PROCEDURE COPY_COMPANY_USERS ;
50 PROCEDURE COPY_COMPONENT_SUBSTITUTES ;
51 PROCEDURE COPY_DEMAND_CLASSES ;
52 PROCEDURE COPY_DEPT_RES_INSTANCES ;
53 PROCEDURE COPY_DESIGNATORS ;
54 PROCEDURE COPY_NET_RES_INST_AVAIL ;
55 PROCEDURE COPY_GROUP_COMPANIES ;
56 PROCEDURE COPY_GROUPS ;
57 PROCEDURE COPY_INTERORG_SHIP_METHODS ;
58 PROCEDURE COPY_ITEM_CUSTOMERS ;
59 PROCEDURE COPY_ITEM_SOURCING ;
60 PROCEDURE COPY_ITEM_SUBSTITUTES ;
61 PROCEDURE COPY_ITEM_SUPPLIERS ;
62 PROCEDURE COPY_JOB_OP_RES_INSTANCES ;
63 PROCEDURE COPY_JOB_OPERATION_NETWORKS ;
64 PROCEDURE COPY_LOCATION_ASSOCIATIONS ;
65 PROCEDURE COPY_NET_RESOURCE_AVAIL ;
66 PROCEDURE COPY_OPERATION_NETWORKS ;
67 PROCEDURE COPY_PARAMETERS ;
68 PROCEDURE COPY_PARTNER_CONTACTS ;
69 PROCEDURE COPY_PERIOD_START_DATES ;
70 PROCEDURE COPY_PLANNERS ;
71 PROCEDURE COPY_PROJECT_TASKS ;
72 PROCEDURE COPY_PROJECTS ;
73 PROCEDURE COPY_REGION_LOCATIONS ;
74 PROCEDURE COPY_REGION_SITES ;
75 PROCEDURE COPY_OPERATION_COMPONENTS ;
76 PROCEDURE COPY_REGIONS ;
77 PROCEDURE COPY_RES_INSTANCE_CHANGES ;
78 PROCEDURE COPY_RESERVATIONS ;
79 PROCEDURE COPY_RESOURCE_CHANGES ;
80 PROCEDURE COPY_RESOURCE_CHARGES ;
81 PROCEDURE COPY_RESOURCE_GROUPS ;
82 PROCEDURE COPY_RESOURCE_SETUPS ;
83 PROCEDURE COPY_RESOURCE_SHIFTS ;
84 PROCEDURE COPY_ROUTINGS ;
85 PROCEDURE COPY_SAFETY_STOCKS ;
86 PROCEDURE COPY_SALES_ORDERS ;
87 PROCEDURE COPY_SETUP_TRANSITIONS ;
88 PROCEDURE COPY_SHIFT_EXCEPTIONS ;
89 PROCEDURE COPY_SHIFT_TIMES ;
90 PROCEDURE COPY_SIMULATION_SETS ;
91 PROCEDURE COPY_SR_ASSIGNMENTS ;
92 PROCEDURE COPY_SR_RECEIPT_ORG ;
93 PROCEDURE COPY_SR_SOURCE_ORG ;
94 PROCEDURE COPY_STD_OP_RESOURCES ;
95 PROCEDURE COPY_SUB_INVENTORIES ;
96 PROCEDURE COPY_SHIFT_DATES ;
97 PROCEDURE COPY_SUPPLIER_CAPACITIES ;
98 PROCEDURE COPY_SUPPLIER_FLEX_FENCES ;
99 PROCEDURE COPY_TRIP_STOPS ;
100 PROCEDURE COPY_TRIPS ;
101 PROCEDURE COPY_UNIT_NUMBERS ;
102 PROCEDURE COPY_UNITS_OF_MEASURE ;
103 PROCEDURE COPY_UOM_CLASS_CONVERSIONS ;
104 PROCEDURE COPY_UOM_CONVERSIONS ;
105 PROCEDURE COPY_WORKDAY_PATTERNS ;
106 PROCEDURE COPY_ZONE_REGIONS ;
107 PROCEDURE COPY_BOM_COMPONENTS ;
108 PROCEDURE COPY_SUPPLIES ;
109 PROCEDURE COPY_SR_LOOKUPS ;
110 PROCEDURE COPY_CALENDAR_MONTHS ;
111 PROCEDURE COPY_SYSTEM_ITEMS ;
112 PROCEDURE COPY_BOMS ;
113 PROCEDURE COPY_DEPARTMENT_RESOURCES ;
114 PROCEDURE COPY_JOB_OP_RESOURCES ;
115 PROCEDURE COPY_JOB_OPERATIONS ;
119 PROCEDURE COPY_PROCESS_EFFECTIVITY ;
116 PROCEDURE COPY_JOB_REQUIREMENT_OPS ;
117 PROCEDURE COPY_OPERATION_RESOURCE_SEQS ;
118 PROCEDURE COPY_OPERATION_RESOURCES ;
120 PROCEDURE COPY_RESOURCE_INSTANCE_REQS ;
121 PROCEDURE COPY_OPEN_PAYBACKS;
122 PROCEDURE COPY_COLL_PARAMETERS (
123 pINSTANCE_ID IN NUMBER);
124 -- PROCEDURE COPY_ABC_CLASSES ;
125 PROCEDURE GET_SOURCE_INSTANCE_ID (
126 SOURCE_ID_INDICATOR IN NUMBER,
127 SOURCE_INSTANCE_CODE OUT NOCOPY VARCHAR2,
128 SOURCE_INSTANCE_ID OUT NOCOPY NUMBER );
129 PROCEDURE SUBMIT_COPY_REQUEST(instance_id in NUMBER
130 ,sr_instance_id in NUMBER,
131 rp_source_ind in NUMBER,
135 p_application_name IN VARCHAR2,
132 p_request_id OUT NOCOPY NUMBER);
133 PROCEDURE RP_INITIALIZE_AND_LAUNCH(p_user_name IN VARCHAR2,
134 p_resp_name IN VARCHAR2,
136 p_sr_instance_id IN NUMBER,
137 p_instance_id IN NUMBER,
138 p_RP_source_ind IN NUMBER,
139 p_request_id OUT NOCOPY NUMBER);
140
141 END MSC_CL_COPY_STG_TBL;