1 PACKAGE WSM_JobCopies_PUB AUTHID CURRENT_USER AS
2 /* $Header: WSMPCPYS.pls 120.1 2007/06/11 12:55:04 adasa ship $ */
3
4 g_debug VARCHAR2(1);
5
6 PROCEDURE Refresh_JobCopies(x_err_buf OUT NOCOPY VARCHAR2,
7 x_err_code OUT NOCOPY NUMBER,
8 p_refresh_all_open_jobs IN NUMBER, -- 1=Yes, 2=No, Default=2
9 p_from_job_name IN VARCHAR2,
10 p_to_job_name IN VARCHAR2,
11 p_job_assembly_id IN NUMBER,
12 p_job_type IN NUMBER,
13 p_bill_item_id IN NUMBER,
14 p_alt_bom_designator IN VARCHAR2,
15 p_rtg_item_id IN NUMBER,
16 p_alt_rtg_designator IN VARCHAR2,
17 p_select_jobs_by_status IN NUMBER, -- 1=Yes, 2=No, Default=1
18 p_rel_jobs IN NUMBER, -- 1=Yes, 2=No, Default=2
19 p_unrel_jobs IN NUMBER, -- 1=Yes, 2=No, Default=2
20 p_onhold_jobs IN NUMBER, -- 1=Yes, 2=No, Default=2
21 p_complete_jobs IN NUMBER, -- 1=Yes, 2=No, Default=2
22 p_closed_jobs IN NUMBER, -- 1=Yes, 2=No, Default=2
23 p_cancelled_jobs IN NUMBER, -- 1=Yes, 2=No, Default=2
24 p_org_id IN NUMBER,
25 P_rout_rev_basis IN NUMBER, -- 1= Job revision Date,2=New revision Date /* last six arguments added in 12.1 refresh bom/routing revision date project */
26 p_dummy IN NUMBER, -- this dummy parameter is added to conditionally enable and disable New Routing Revision Date Parameter
27 p_new_rev_date_rou IN VARCHAR2,
28 P_bom_rev_basis IN NUMBER, --1= Job revision Date,2=New revision Date
29 p_dummy2 IN NUMBER, -- this dummy parameter is added to conditionally enable and disable New BOM Revision Date Parameter
30 p_new_rev_date_bom IN VARCHAR2
31 );
32
33 END WSM_JobCopies_PUB;