1 PACKAGE WSM_JobCopies_PVT AUTHID CURRENT_USER AS
2 /* $Header: WSMVCPYS.pls 120.2.12000000.1 2007/01/12 05:37:38 appldev ship $ */
3
4 g_debug VARCHAR2(1);
5
6 PROCEDURE Create_JobCopies (x_err_buf OUT NOCOPY VARCHAR2,
7 x_err_code OUT NOCOPY NUMBER,
8 p_wip_entity_id IN NUMBER,
9 p_org_id IN NUMBER,
10 p_primary_item_id IN NUMBER,
11 p_routing_item_id IN NUMBER,
12 p_alt_rtg_desig IN VARCHAR2,
13 p_rtg_seq_id IN NUMBER, -- Will be NULL till reqd for some functionality
14 p_common_rtg_seq_id IN NUMBER,
15 p_rtg_rev_date IN DATE,
16 p_bill_item_id IN NUMBER,
17 p_alt_bom_desig IN VARCHAR2,
18 p_bill_seq_id IN NUMBER,
19 p_common_bill_seq_id IN NUMBER,
20 p_bom_rev_date IN DATE,
21 p_wip_supply_type IN NUMBER,
22 p_last_update_date IN DATE,
23 p_last_updated_by IN NUMBER,
24 p_last_update_login IN NUMBER,
25 p_creation_date IN DATE,
26 p_created_by IN NUMBER,
27 p_request_id IN NUMBER,
28 p_program_app_id IN NUMBER,
29 p_program_id IN NUMBER,
30 p_program_update_date IN DATE,
31 p_inf_sch_flag IN VARCHAR2, --Y/N
32 p_inf_sch_mode IN NUMBER, --NULL/FORWARDS/BACKWARDS/MIDPOINT_FORWARDS/MIDPOINT_BACKWARDS/CURRENT_OP
33 p_inf_sch_date IN DATE, --based on mode, this will be start/completion date
34 p_new_job IN NUMBER DEFAULT NULL,
35 p_insert_wip IN NUMBER DEFAULT NULL,
36 p_phantom_exists IN NUMBER DEFAULT NULL,
37 p_charges_exist IN NUMBER DEFAULT NULL
38 );
39
40 PROCEDURE Create_RepJobCopies (x_err_buf OUT NOCOPY VARCHAR2,
41 x_err_code OUT NOCOPY NUMBER,
42 p_rep_wip_entity_id IN NUMBER,
43 p_new_wip_entity_id IN NUMBER,
44 p_last_update_date IN DATE,
45 p_last_updated_by IN NUMBER,
46 p_last_update_login IN NUMBER,
47 p_creation_date IN DATE,
48 p_created_by IN NUMBER,
49 p_request_id IN NUMBER,
50 p_program_app_id IN NUMBER,
51 p_program_id IN NUMBER,
52 p_program_update_date IN DATE,
53 p_inf_sch_flag IN VARCHAR2,--Y/N
54 p_inf_sch_mode IN NUMBER, --NULL/MIDPOINT_FORWARDS/CURRENT_OP
55 p_inf_sch_date IN DATE --based on mode, this will be start/completion date
56 );
57
58 PROCEDURE Upgrade_JobCopies (x_err_buf OUT NOCOPY VARCHAR2,
59 x_err_code OUT NOCOPY NUMBER
60 );
61 PROCEDURE process_wip_info( p_wip_entity_id IN NUMBER,
62 p_org_id IN NUMBER,
63 p_last_update_date IN DATE,
64 p_last_updated_by IN NUMBER,
65 p_last_update_login IN NUMBER,
66 p_creation_date IN DATE,
67 p_created_by IN NUMBER,
68 p_request_id IN NUMBER,
69 p_program_app_id IN NUMBER,
70 p_program_id IN NUMBER,
71 p_program_update_date IN DATE,
72 p_phantom_exists IN NUMBER,
73 p_current_op_seq_num IN NUMBER,
74 x_err_buf OUT NOCOPY VARCHAR2,
75 x_err_code OUT NOCOPY NUMBER);
76
77 FUNCTION max_res_seq (p_op_seq_id NUMBER) return NUMBER;
78
79 END WSM_JobCopies_PVT;