1 PACKAGE GMP_APS_WRITER AUTHID CURRENT_USER AS
2 /* $Header: GMPAPSWS.pls 120.3.12020000.1 2012/06/27 15:05:37 appldev ship $ */
3
4 e_msg VARCHAR2(8000) := NULL;
5 orig_last_update_date DATE := NULL ;
6
7 l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('GMP_DEBUG_ENABLED'),'N');
8
9 PROCEDURE main_process(
10 p_batch_id IN NUMBER,
11 p_group_id IN NUMBER,
12 p_header_id IN NUMBER,
13 p_start_date IN DATE,
14 p_end_date IN DATE,
15 p_required_completion IN DATE, -- For R12.0
16 p_order_priority IN NUMBER, -- For R12.0
17 p_organization_id IN NUMBER, -- For R12.0
18 p_eff_id IN NUMBER,
19 p_action_type IN NUMBER,
20 p_creation_date IN DATE,
21 p_user_id IN NUMBER,
22 p_login_id IN NUMBER,
23 return_msg OUT NOCOPY VARCHAR2,
24 return_status OUT NOCOPY NUMBER) ;
25
26 PROCEDURE lock_batch_details(
27 pbatch_id IN NUMBER,
28 pbatch_status OUT NOCOPY NUMBER,
29 pbatch_last_update OUT NOCOPY DATE,
30 return_status OUT NOCOPY NUMBER);
31
32 PROCEDURE update_batch_header(
33 pbatch_id IN NUMBER,
34 pstart_date IN DATE,
35 pend_date IN DATE,
36 preq_completion_date IN DATE, -- For R12.0
37 pord_priority IN NUMBER, -- For R12.0
38 pbatch_status IN NUMBER,
39 pfirm_flag IN NUMBER, -- B5897392
40 puser_id IN NUMBER,
41 plogin_id IN NUMBER,
42 return_status OUT NOCOPY NUMBER);
43
44 PROCEDURE update_materails (
45 pbatch_id IN NUMBER,
46 porganization_id IN NUMBER,
47 return_status OUT NOCOPY NUMBER);
48
49 PROCEDURE update_batch_steps(
50 pbatch_id IN NUMBER,
51 pstep_no IN NUMBER,
52 pstep_id IN NUMBER,
53 pstart_date IN DATE,
54 pend_date IN DATE,
55 pdue_date IN DATE, -- B4962912
56 puser_id IN NUMBER,
57 plogin_id IN NUMBER,
58 return_status OUT NOCOPY NUMBER);
59
60 PROCEDURE update_step_resources(
61 pbatch_id IN NUMBER,
62 porganization_id IN NUMBER, -- For R12.0
63 pstep_resource_id IN NUMBER,
64 prsrc_usage IN NUMBER,
65 psequence_dep_usage IN NUMBER, -- For R12.0
66 pgme_resource IN VARCHAR2,
67 paps_resource IN VARCHAR2,
68 pstart_date IN DATE,
69 pend_date IN DATE,
70 pbs_usage_uom IN VARCHAR2, -- Gme UOM code
71 passigned_unit IN NUMBER,
72 paps_data_use IN NUMBER,
73 psetup_id IN NUMBER, -- For R12.0
74 pgroup_sequence_id IN NUMBER, -- For R12.0
75 pgroup_sequence_number IN NUMBER, -- For R12.0
76 pfirm_flag IN NUMBER, -- For R12.0
77 pscale_type IN NUMBER, -- For R12.0
78 puser_id IN NUMBER,
79 plogin_id IN NUMBER,
80 pnew_act_res OUT NOCOPY NUMBER,
81 return_status OUT NOCOPY NUMBER ) ;
82
83 PROCEDURE update_resource_transactions(
84 pbatch_id IN NUMBER,
85 pbstep_rsrc_id IN NUMBER,
86 porganization_id IN NUMBER, -- For R12.0
87 prsrc_hour IN NUMBER,
88 paps_resource IN VARCHAR2,
89 pstart_date IN DATE,
90 pend_date IN DATE,
91 puom_code IN VARCHAR2,
92 prsrc_inst_id IN NUMBER, -- For R12.0 resource_instance_id
93 pseq_dep_ind IN NUMBER, -- For R12.0 sequence dependent
94 puser_id IN NUMBER,
95 plogin_id IN NUMBER,
96 return_status OUT NOCOPY NUMBER );
97
98 PROCEDURE update_batch_activities(
99 pbatch_id IN NUMBER,
100 porganization_id IN NUMBER, -- For R12.0
101 pstep_id IN NUMBER,
102 pactivity_id IN NUMBER,
103 pstart_date IN DATE,
104 pend_date IN DATE,
105 puom_hour IN VARCHAR2,
106 puser_id IN NUMBER,
107 plogin_id IN NUMBER,
108 return_status OUT NOCOPY NUMBER) ;
109
110 PROCEDURE validate_structure (
111 pfmeff_id IN NUMBER,
112 porganization_id IN NUMBER, -- For R12.0
113 pgroup_id IN NUMBER,
114 pheader_id IN NUMBER,
115 struc_size OUT NOCOPY NUMBER,
116 return_status OUT NOCOPY NUMBER);
117
118 PROCEDURE log_message(
119 pbuff IN VARCHAR2);
120
121 PROCEDURE time_stamp ;
122
123 PROCEDURE update_activity_offsets ( batch_id IN NUMBER) ;
124
125 PROCEDURE update_batches;
126
127 PROCEDURE Insert_charges (
128 pbatch_id IN NUMBER,
129 pgroup_id IN NUMBER,
130 pheader_id IN NUMBER,
131 return_status OUT NOCOPY NUMBER);
132
133 PROCEDURE gmp_debug_message(pBUFF IN VARCHAR2); -- Vpedarla
134
135 END gmp_aps_writer;