DBA Data[Home] [Help]

APPS.ASO_APR_APPROVALS_PKG dependencies on DUAL

Line 57: FROM sys.DUAL;

53: p_requester_group_id NUMBER
54: ) IS
55: CURSOR c2 IS
56: SELECT aso_apr_obj_header_s.NEXTVAL
57: FROM sys.DUAL;
58: BEGIN
59: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
60: aso_debug_pub.ADD (
61: 'Begin Header_Insert_Row procedure ',

Line 828: FROM sys.DUAL;

824: p_approver_cat varchar2 default null--rassharm
825: ) IS
826: CURSOR c2 IS
827: SELECT aso_apr_obj_det_s.NEXTVAL
828: FROM sys.DUAL;
829: BEGIN
830: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
831: aso_debug_pub.ADD (
832: 'Begin Detail_Insert_Row procedure ',

Line 1637: FROM sys.DUAL;

1633: p_object_version_number NUMBER
1634: ) IS
1635: CURSOR c2 IS
1636: SELECT aso_apr_rule_s.NEXTVAL
1637: FROM sys.DUAL;
1638: BEGIN
1639: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1640: aso_debug_pub.ADD (
1641: 'Begin Rule_Insert_Row procedure ',