DBA Data[Home] [Help]

APPS.PODUS dependencies on PODUS

Line 1: package body podus as

1: package body podus as
2: --$Header: ICXPODUB.pls 115.3 99/07/17 03:20:16 porting ship $
3: --
4: --
5: procedure podusauths ( p_requisition_header_id in number,

Line 5: procedure podusauths ( p_requisition_header_id in number,

1: package body podus as
2: --$Header: ICXPODUB.pls 115.3 99/07/17 03:20:16 porting ship $
3: --
4: --
5: procedure podusauths ( p_requisition_header_id in number,
6: p_new_status in varchar2 ) is
7: --
8: begin
9: --

Line 20: procedure podusipah ( p_requisition_header_id in number,

16: --
17: end;
18: --
19: --
20: procedure podusipah ( p_requisition_header_id in number,
21: p_action in varchar2,
22: p_fwd_to_id in number,
23: p_note in varchar2 ) is
24: l_sequence_number number;

Line 79: end podusipah;

75: '',
76: l_approval_path_id,
77: l_offline_code );
78:
79: end podusipah;
80: --
81: --
82: procedure podusupah ( p_requisition_header_id in number,
83: p_action in varchar2,

Line 82: procedure podusupah ( p_requisition_header_id in number,

78:
79: end podusipah;
80: --
81: --
82: procedure podusupah ( p_requisition_header_id in number,
83: p_action in varchar2,
84: p_note in varchar2 ) is
85: --
86: begin

Line 100: end podusupah;

96: WHERE object_id = p_requisition_header_id
97: AND object_type_code = 'REQUISITION'
98: AND action_code IS NULL;
99: --
100: end podusupah;
101: --
102: --
103: procedure podufwd ( p_requisition_header_id in number,
104: p_action in varchar2,

Line 110: podusipah ( p_requisition_header_id => p_requisition_header_id,

106: p_note in varchar2 ) is
107: begin
108: --
109: --
110: podusipah ( p_requisition_header_id => p_requisition_header_id,
111: p_action => to_char(null),
112: p_fwd_to_id => p_fwd_to_id,
113: p_note => p_note );
114:

Line 120: procedure podustate ( p_requisition_header_id in number,

116: --
117: end;
118: --
119: --
120: procedure podustate ( p_requisition_header_id in number,
121: p_action in varchar2,
122: p_emp_id in number,
123: p_note in varchar2,
124: p_new_status in varchar2 ) is

Line 137: podusipah( p_requisition_header_id => p_requisition_header_id,

133: --
134: --
135: if ( l_old_status in ( 'INCOMPLETE', 'RETURNED', 'REJECTED', 'REQUIRES REAPPROVAL') ) then
136: --
137: podusipah( p_requisition_header_id => p_requisition_header_id,
138: p_action => 'SUBMIT',
139: p_fwd_to_id => p_emp_id,
140: p_note => p_note );
141: --

Line 145: podusipah( p_requisition_header_id => p_requisition_header_id,

141: --
142: --
143: if ( p_action <> 'SUBMIT' ) then
144: --
145: podusipah( p_requisition_header_id => p_requisition_header_id,
146: p_action => p_action,
147: p_fwd_to_id => p_emp_id,
148: p_note => p_note );
149: end if;

Line 156: podusupah( p_requisition_header_id => p_requisition_header_id,

152: elsif ( l_old_status in ('IN PROCESS','PRE-APPROVED') ) then
153: --
154: -- Update previous record with action being performed
155: --
156: podusupah( p_requisition_header_id => p_requisition_header_id,
157: p_action => p_action,
158: p_note => p_note );
159:
160: elsif ( l_old_status = 'APPROVED' ) then

Line 168: podusauths ( p_requisition_header_id => p_requisition_header_id,

164: end if;
165: --
166: if ( p_new_status is not null ) then
167: --
168: podusauths ( p_requisition_header_id => p_requisition_header_id,
169: p_new_status => p_new_status );
170: --
171: end if;
172: --

Line 173: end podustate;

169: p_new_status => p_new_status );
170: --
171: end if;
172: --
173: end podustate;
174: --
175: --
176: end podus;

Line 176: end podus;

172: --
173: end podustate;
174: --
175: --
176: end podus;