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