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_PA_APR_PUB_W dependencies on ASO_PA_APR_PUB

Line 1: PACKAGE BODY ASO_PA_APR_PUB_W as

1: PACKAGE BODY ASO_PA_APR_PUB_W as
2: /* $Header: asowpapb.pls 120.0.12020000.1 2013/03/19 20:30:27 cazhou noship $ */
3: -- Start of Comments
4: -- Package name : ASO_PA_APR_PUB_W
5: -- Purpose : Rosetta wrappers for ASO Approval APIs

Line 4: -- Package name : ASO_PA_APR_PUB_W

1: PACKAGE BODY ASO_PA_APR_PUB_W as
2: /* $Header: asowpapb.pls 120.0.12020000.1 2013/03/19 20:30:27 cazhou noship $ */
3: -- Start of Comments
4: -- Package name : ASO_PA_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_PA_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_PA_APR_PUB_W';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asowpapb.pls';
14:
15: FUNCTION rosetta_g_miss_num_map(n number) RETURN number as
16: a number := fnd_api.g_miss_num;

Line 48: )RETURN ASO_PA_APR_PUB.approvers_list_tbl_type

44: p_occurrence IN jtf_number_table := NULL,
45: p_authority IN jtf_varchar2_table_100 := NULL,
46: p_date_sent IN jtf_date_table := NULL,
47: p_date_received IN jtf_date_table := NULL
48: )RETURN ASO_PA_APR_PUB.approvers_list_tbl_type
49: IS
50: l_approvers_list_tbl ASO_PA_APR_Pub.approvers_list_tbl_type;
51: l_table_size PLS_INTEGER := 0;
52: i PLS_INTEGER;

Line 50: l_approvers_list_tbl ASO_PA_APR_Pub.approvers_list_tbl_type;

46: p_date_sent IN jtf_date_table := NULL,
47: p_date_received IN jtf_date_table := NULL
48: )RETURN ASO_PA_APR_PUB.approvers_list_tbl_type
49: IS
50: l_approvers_list_tbl ASO_PA_APR_Pub.approvers_list_tbl_type;
51: l_table_size PLS_INTEGER := 0;
52: i PLS_INTEGER;
53: BEGIN
54: IF p_approver_name IS NOT NULL THEN

Line 178: RETURN ASO_PA_APR_Pub.G_MISS_APPROVERS_LIST_TBL;

174: END LOOP;
175:
176: RETURN l_approvers_list_tbl;
177: ELSE
178: RETURN ASO_PA_APR_Pub.G_MISS_APPROVERS_LIST_TBL;
179: END IF;
180: END Construct_Approvers_List_Tbl;
181:
182:

Line 184: p_qte_approvers_list_tbl IN ASO_PA_Apr_Pub.Approvers_List_Tbl_Type,

180: END Construct_Approvers_List_Tbl;
181:
182:
183: PROCEDURE Set_Approvers_List_Tbl_Out(
184: p_qte_approvers_list_tbl IN ASO_PA_Apr_Pub.Approvers_List_Tbl_Type,
185: x_approval_det_id OUT NOCOPY jtf_number_table,
186: x_object_approval_id OUT NOCOPY jtf_number_table,
187: x_approver_person_id OUT NOCOPY jtf_number_table,
188: x_approver_user_id OUT NOCOPY jtf_number_table,

Line 297: p_qte_rules_list_tbl IN ASO_PA_Apr_Pub.Rules_List_Tbl_Type,

293:
294:
295:
296: PROCEDURE Set_Rules_List_Tbl_Out(
297: p_qte_rules_list_tbl IN ASO_PA_Apr_Pub.Rules_List_Tbl_Type,
298: x_rule_id OUT NOCOPY jtf_number_table,
299: x_object_approval_id OUT NOCOPY jtf_number_table,
300: x_rule_action_id OUT NOCOPY jtf_number_table,
301: x_rule_description OUT NOCOPY jtf_varchar2_table_300,

Line 394: lx_approvers_list_tbl ASO_PA_Apr_Pub.Approvers_List_Tbl_Type;

390: x_msg_count OUT NOCOPY NUMBER ,
391: x_msg_data OUT NOCOPY VARCHAR2
392: )
393: AS
394: lx_approvers_list_tbl ASO_PA_Apr_Pub.Approvers_List_Tbl_Type;
395: lx_rules_list_tbl ASO_PA_Apr_Pub.Rules_List_Tbl_Type;
396:
397: l_debug VARCHAR2(1);
398: l_msg_count NUMBER;

Line 395: lx_rules_list_tbl ASO_PA_Apr_Pub.Rules_List_Tbl_Type;

391: x_msg_data OUT NOCOPY VARCHAR2
392: )
393: AS
394: lx_approvers_list_tbl ASO_PA_Apr_Pub.Approvers_List_Tbl_Type;
395: lx_rules_list_tbl ASO_PA_Apr_Pub.Rules_List_Tbl_Type;
396:
397: l_debug VARCHAR2(1);
398: l_msg_count NUMBER;
399: l_msg_data VARCHAR2(10000);

Line 405: 'Begin calling ASO_PA_Apr_Pub.Get_All_Approvers',

401: BEGIN
402:
403: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
404: aso_debug_pub.ADD (
405: 'Begin calling ASO_PA_Apr_Pub.Get_All_Approvers',
406: 1,
407: 'N'
408: );
409: END IF;

Line 411: ASO_PA_Apr_Pub.Get_All_Approvers(

407: 'N'
408: );
409: END IF;
410:
411: ASO_PA_Apr_Pub.Get_All_Approvers(
412: p_api_version_number => p_api_version_number,
413: p_init_msg_list => p_init_msg_list,
414: p_commit => p_commit,
415: p_object_id => p_object_id,

Line 435: ASO_PA_APR_PUB_W.Set_Approvers_List_Tbl_Out(

431: 'N'
432: );
433: END IF;
434:
435: ASO_PA_APR_PUB_W.Set_Approvers_List_Tbl_Out(
436: p_qte_approvers_list_tbl => lx_approvers_list_tbl,
437: x_approval_det_id => x_qa_approval_det_id,
438: x_object_approval_id => x_qa_object_approval_id,
439: x_approver_person_id => x_qa_approver_person_id,

Line 462: ASO_PA_APR_PUB_W.Set_Rules_List_Tbl_Out(

458: x_date_sent => x_qa_date_sent,
459: x_date_received => x_qa_date_received
460: );
461:
462: ASO_PA_APR_PUB_W.Set_Rules_List_Tbl_Out(
463: p_qte_rules_list_tbl => lx_rules_list_tbl,
464: x_rule_id => x_qr_rule_id,
465: x_object_approval_id => x_qr_object_approval_id,
466: x_rule_action_id => x_qr_rule_action_id,

Line 525: l_approvers_list_tbl ASO_PA_Apr_Pub.Approvers_list_Tbl_Type;

521: x_msg_count OUT NOCOPY NUMBER,
522: x_msg_data OUT NOCOPY VARCHAR2
523: )
524: AS
525: l_approvers_list_tbl ASO_PA_Apr_Pub.Approvers_list_Tbl_Type;
526: l_debug VARCHAR2(1);
527: l_msg_count NUMBER;
528: l_msg_data VARCHAR2(10000);
529: BEGIN

Line 533: 'Begin calling ASO_PA_Apr_Pub.start_papproval_proccess',

529: BEGIN
530:
531: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
532: aso_debug_pub.ADD (
533: 'Begin calling ASO_PA_Apr_Pub.start_papproval_proccess',
534: 1,
535: 'N'
536: );
537: END IF;

Line 539: l_approvers_list_tbl := ASO_PA_APR_PUB_W.Construct_Approvers_List_Tbl(

535: 'N'
536: );
537: END IF;
538:
539: l_approvers_list_tbl := ASO_PA_APR_PUB_W.Construct_Approvers_List_Tbl(
540: p_approval_det_id => p_qa_approval_det_id,
541: p_object_approval_id => p_qa_object_approval_id,
542: p_approver_person_id => p_qa_approver_person_id,
543: p_approver_user_id => p_qa_approver_user_id,

Line 565: ASO_PA_Apr_Pub.start_papproval_process (

561: p_date_sent => p_qa_date_sent,
562: p_date_received => p_qa_date_received
563: );
564:
565: ASO_PA_Apr_Pub.start_papproval_process (
566: p_api_version_number => p_api_version_number,
567: p_init_msg_list => p_init_msg_list,
568: p_commit => p_commit,
569: p_object_id => p_object_id,

Line 583: 'Returning from ASO_PA_Apr_Pub.start_papproval_process',

579: );
580:
581: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
582: aso_debug_pub.ADD (
583: 'Returning from ASO_PA_Apr_Pub.start_papproval_process',
584: 1,
585: 'N'
586: );
587: END IF;

Line 591: END ASO_PA_APR_PUB_W;

587: END IF;
588:
589: END start_papproval_process;
590:
591: END ASO_PA_APR_PUB_W;