[Home] [Help]
1: PACKAGE BODY aso_apr_pub AS
2: /* $Header: asopaprb.pls 120.1 2005/06/29 12:36:23 appldev ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_APR_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asopaprb.pls';
1: PACKAGE BODY aso_apr_pub AS
2: /* $Header: asopaprb.pls 120.1 2005/06/29 12:36:23 appldev ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_APR_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asopaprb.pls';
6:
7:
8: PROCEDURE get_all_approvers (
29: SAVEPOINT GET_ALL_APPROVERS_PUB;
30:
31: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
32: aso_debug_pub.ADD (
33: 'BEGIN get_all_approvers in ASO_APR_PUB package ',
34: 1,
35: 'N'
36: );
37: END IF;
180: );
181:
182: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
183: aso_debug_pub.ADD (
184: 'END get_all_approvers in ASO_APR_PUB package ',
185: 1,
186: 'N'
187: );
188: END IF;
247:
248:
249: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
250: aso_debug_pub.ADD (
251: 'BEGIN start_approval_process in ASO_APR_PUB package ',
252: 1,
253: 'N'
254: );
255: END IF;
408: );
409:
410: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
411: aso_debug_pub.ADD (
412: 'END start_approval_process in ASO_APR_PUB package ',
413: 1,
414: 'N'
415: );
416: END IF;
468: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
469:
470: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
471: aso_debug_pub.ADD (
472: 'BEGIN cancel_approval_process in ASO_APR_PUB package ',
473: 1,
474: 'N'
475: );
476: END IF;
489: x_msg_data
490: );
491: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
492: aso_debug_pub.ADD (
493: 'END cancel_approval_process in ASO_APR_PUB package ',
494: 1,
495: 'N'
496: );
497: END IF;
515: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
516:
517: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
518: aso_debug_pub.ADD (
519: 'BEGIN skip_approver in ASO_APR_PUB package ',
520: 1,
521: 'N'
522: );
523: END IF;
535: x_msg_data
536: );
537: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
538: aso_debug_pub.ADD (
539: 'END skip_approver in ASO_APR_PUB package ',
540: 1,
541: 'N'
542: );
543: END IF;
547: p_api_version_number IN NUMBER,
548: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
549: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
550: p_object_approval_id IN NUMBER,
551: x_rules_list OUT NOCOPY /* file.sql.39 change */ aso_apr_pub.rules_list_tbl_type,
552: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
553: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
554: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
555:
559: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
560:
561: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
562: aso_debug_pub.ADD (
563: 'BEGIN get_rule_details in ASO_APR_PUB package ',
564: 1,
565: 'N'
566: );
567: END IF;
577: x_msg_data);
578:
579: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
580: aso_debug_pub.ADD (
581: 'END get_rule_details in ASO_APR_PUB package ',
582: 1,
583: 'N'
584: );
585: END IF;
603: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
604:
605: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
606: aso_debug_pub.ADD (
607: 'BEGIN start_approval_workflow in ASO_APR_PUB package ',
608: 1,
609: 'N'
610: );
611: END IF;
622: x_msg_data);
623:
624: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
625: aso_debug_pub.ADD (
626: 'END start_approval_workflow in ASO_APR_PUB package ',
627: 1,
628: 'N'
629: );
630: END IF;
632:
633: END start_approval_workflow;
634:
635:
636: END aso_apr_pub;