eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_APR_PUB_W dependencies on ASO_APR_PUB

Line 1: PACKAGE BODY ASO_APR_PUB_W as

1: PACKAGE BODY ASO_APR_PUB_W as
2: /* $Header: asowaprb.pls 120.1 2005/10/12 14:43:36 skulkarn noship $ */
3: -- Start of Comments
4: -- Package name : ASO_APR_PUB_W
5: -- Purpose : Rosetta wrappers for ASO Approval APIs

Line 4: -- Package name : ASO_APR_PUB_W

1: PACKAGE BODY ASO_APR_PUB_W as
2: /* $Header: asowaprb.pls 120.1 2005/10/12 14:43:36 skulkarn noship $ */
3: -- Start of Comments
4: -- Package name : ASO_APR_PUB_W
5: -- Purpose : Rosetta wrappers for ASO Approval APIs
6: -- History : Created on 12/02/01
7: -- NOTE :
8: -- END of Comments

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_APR_PUB_W';

8: -- END of Comments
9: ROSETTA_G_MISTAKE_DATE DATE := TO_DATE('01/01/+4713', 'MM/DD/SYYYY');
10: ROSETTA_G_MISS_NUM NUMBER := 0-1962.0724;
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_APR_PUB_W';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asowaprb.pls';
14:
15: FUNCTION rosetta_g_miss_num_map(n number) RETURN number as
16: a number := fnd_api.g_miss_num;

Line 25: p_qte_approvers_list_tbl IN ASO_Apr_Pub.Approvers_List_Tbl_Type,

21: RETURN n;
22: END;
23:
24: PROCEDURE Set_Approvers_List_Tbl_Out(
25: p_qte_approvers_list_tbl IN ASO_Apr_Pub.Approvers_List_Tbl_Type,
26: x_approval_det_id OUT NOCOPY jtf_number_table,
27: x_object_approval_id OUT NOCOPY jtf_number_table,
28: x_approver_person_id OUT NOCOPY jtf_number_table,
29: x_approver_user_id OUT NOCOPY jtf_number_table,

Line 90: p_qte_rules_list_tbl IN ASO_Apr_Pub.Rules_List_Tbl_Type,

86:
87:
88:
89: PROCEDURE Set_Rules_List_Tbl_Out(
90: p_qte_rules_list_tbl IN ASO_Apr_Pub.Rules_List_Tbl_Type,
91: x_rule_id OUT NOCOPY jtf_number_table,
92: x_object_approval_id OUT NOCOPY jtf_number_table,
93: x_rule_action_id OUT NOCOPY jtf_number_table,
94: x_rule_description OUT NOCOPY jtf_varchar2_table_300,

Line 157: lx_approvers_list_tbl ASO_Apr_Pub.Approvers_List_Tbl_Type;

153: x_msg_count OUT NOCOPY NUMBER ,
154: x_msg_data OUT NOCOPY VARCHAR2
155: )
156: AS
157: lx_approvers_list_tbl ASO_Apr_Pub.Approvers_List_Tbl_Type;
158: lx_rules_list_tbl ASO_Apr_Pub.Rules_List_Tbl_Type;
159:
160: l_debug VARCHAR2(1);
161: l_msg_count NUMBER;

Line 158: lx_rules_list_tbl ASO_Apr_Pub.Rules_List_Tbl_Type;

154: x_msg_data OUT NOCOPY VARCHAR2
155: )
156: AS
157: lx_approvers_list_tbl ASO_Apr_Pub.Approvers_List_Tbl_Type;
158: lx_rules_list_tbl ASO_Apr_Pub.Rules_List_Tbl_Type;
159:
160: l_debug VARCHAR2(1);
161: l_msg_count NUMBER;
162: l_msg_data VARCHAR2(10000);

Line 168: 'Begin calling ASO_Apr_Pub.Get_All_Approvers',

164: BEGIN
165:
166: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
167: aso_debug_pub.ADD (
168: 'Begin calling ASO_Apr_Pub.Get_All_Approvers',
169: 1,
170: 'N'
171: );
172: END IF;

Line 174: ASO_Apr_Pub.Get_All_Approvers(

170: 'N'
171: );
172: END IF;
173:
174: ASO_Apr_Pub.Get_All_Approvers(
175: p_api_version_number => p_api_version_number,
176: p_init_msg_list => p_init_msg_list,
177: p_commit => p_commit,
178: p_object_id => p_object_id,

Line 189: 'Returning from ASO_Apr_Pub.Get_All_Approvers',

185: x_rules_list => lx_rules_list_tbl);
186:
187: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
188: aso_debug_pub.ADD (
189: 'Returning from ASO_Apr_Pub.Get_All_Approvers',
190: 1,
191: 'N'
192: );
193: END IF;

Line 195: ASO_APR_PUB_W.Set_Approvers_List_Tbl_Out(

191: 'N'
192: );
193: END IF;
194:
195: ASO_APR_PUB_W.Set_Approvers_List_Tbl_Out(
196: p_qte_approvers_list_tbl => lx_approvers_list_tbl,
197: x_approval_det_id => x_qa_approval_det_id,
198: x_object_approval_id => x_qa_object_approval_id,
199: x_approver_person_id => x_qa_approver_person_id,

Line 210: ASO_APR_PUB_W.Set_Rules_List_Tbl_Out(

206: x_date_sent => x_qa_date_sent,
207: x_date_received => x_qa_date_received
208: );
209:
210: ASO_APR_PUB_W.Set_Rules_List_Tbl_Out(
211: p_qte_rules_list_tbl => lx_rules_list_tbl,
212: x_rule_id => x_qr_rule_id,
213: x_object_approval_id => x_qr_object_approval_id,
214: x_rule_action_id => x_qr_rule_action_id,

Line 246: lx_rules_list_tbl ASO_Apr_Pub.Rules_List_Tbl_Type;

242: x_msg_count OUT NOCOPY NUMBER ,
243: x_msg_data OUT NOCOPY VARCHAR2
244: )
245: AS
246: lx_rules_list_tbl ASO_Apr_Pub.Rules_List_Tbl_Type;
247: l_debug VARCHAR2(1);
248: BEGIN
249:
250: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 252: 'Begin calling ASO_Apr_Pub.Get_Rule_Details',

248: BEGIN
249:
250: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
251: aso_debug_pub.ADD (
252: 'Begin calling ASO_Apr_Pub.Get_Rule_Details',
253: 1,
254: 'N'
255: );
256: END IF;

Line 258: ASO_Apr_Pub.Get_Rule_Details(

254: 'N'
255: );
256: END IF;
257:
258: ASO_Apr_Pub.Get_Rule_Details(
259: p_api_version_number => p_api_version_number,
260: p_init_msg_list => p_init_msg_list,
261: p_commit => p_commit,
262: p_object_approval_id => p_object_approval_id,

Line 270: 'Returning from ASO_Apr_Pub.Get_Rule_Details',

266: x_rules_list => lx_rules_list_tbl);
267:
268: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
269: aso_debug_pub.ADD (
270: 'Returning from ASO_Apr_Pub.Get_Rule_Details',
271: 1,
272: 'N'
273: );
274: END IF;

Line 276: ASO_APR_PUB_W.Set_Rules_List_Tbl_Out(

272: 'N'
273: );
274: END IF;
275:
276: ASO_APR_PUB_W.Set_Rules_List_Tbl_Out(
277: p_qte_rules_list_tbl => lx_rules_list_tbl,
278: x_rule_id => x_qr_rule_id,
279: x_object_approval_id => x_qr_object_approval_id,
280: x_rule_action_id => x_qr_rule_action_id,

Line 295: END ASO_APR_PUB_W;

291: END IF;
292:
293: END Get_Rule_Details;
294:
295: END ASO_APR_PUB_W;