APPS.OE_PC_CONSTRAINTS_ADMIN_PUB dependencies on OE_PC_CONSTRAINTS

Line 1: PACKAGE BODY Oe_PC_Constraints_Admin_Pub as

1: PACKAGE BODY Oe_PC_Constraints_Admin_Pub as
2: /* $Header: OEXPPCAB.pls 120.1 2010/11/22 09:02:59 skurella ship $ */
3:
4: -- global variables
5: G_PKG_NAME constant varchar2(30) := 'Oe_PC_Constraints_Admin_Pub';

Line 5: G_PKG_NAME constant varchar2(30) := 'Oe_PC_Constraints_Admin_Pub';

1: PACKAGE BODY Oe_PC_Constraints_Admin_Pub as
2: /* $Header: OEXPPCAB.pls 120.1 2010/11/22 09:02:59 skurella ship $ */
3:
4: -- global variables
5: G_PKG_NAME constant varchar2(30) := 'Oe_PC_Constraints_Admin_Pub';
6:
7: -------------------------------------------------------------------
8: PROCEDURE Generate_Constraint_API
9: (

Line 469: utl_file.put_line(l_bodyFileHandle , ' FROM oe_pc_constraints c,');

465: utl_file.put_line(l_bodyFileHandle , ' SELECT DISTINCT');
466: utl_file.put_line(l_bodyFileHandle , ' c.constraint_id, c.entity_id');
467: utl_file.put_line(l_bodyFileHandle , ' ,c.on_operation_action');
468: --utl_file.put_line(l_bodyFileHandle , ' ,c.message_name');
469: utl_file.put_line(l_bodyFileHandle , ' FROM oe_pc_constraints c,');
470: utl_file.put_line(l_bodyFileHandle , ' oe_pc_assignments a');
471: utl_file.put_line(l_bodyFileHandle , ' WHERE (a.responsibility_id = p_responsibility_id OR a.responsibility_id IS NULL)');
472: -- utl_file.put_line(l_bodyFileHandle , ' AND sysdate BETWEEN nvl(a.start_date_active, sysdate) AND nvl(a.end_date_active, sysdate)');
473: utl_file.put_line(l_bodyFileHandle , ' AND a.constraint_id = c.constraint_id');

Line 501: utl_file.put_line(l_bodyFileHandle , ' FROM oe_pc_constraints c,');

497: utl_file.put_line(l_bodyFileHandle , ' SELECT DISTINCT');
498: utl_file.put_line(l_bodyFileHandle , ' c.constraint_id, c.entity_id');
499: utl_file.put_line(l_bodyFileHandle , ' ,c.on_operation_action');
500: --utl_file.put_line(l_bodyFileHandle , ' ,c.message_name');
501: utl_file.put_line(l_bodyFileHandle , ' FROM oe_pc_constraints c,');
502: utl_file.put_line(l_bodyFileHandle , ' oe_pc_assignments a');
503: utl_file.put_line(l_bodyFileHandle , ' WHERE (a.responsibility_id = p_responsibility_id OR a.responsibility_id IS NULL)');
504: utl_file.put_line(l_bodyFileHandle , ' AND a.application_id = p_application_id OR a.application_id IS NULL'); --bug3631547
505: -- utl_file.put_line(l_bodyFileHandle , ' AND sysdate BETWEEN nvl(a.start_date_active, sysdate) AND nvl(a.end_date_active, sysdate)');

Line 590: OE_Debug_PUB.ADD('Oe_PC_Constraints_Admin_Pub.Generate_Constraint_API: EXCEPTION');

586: EXCEPTION
587:
588: when others then
589: IF l_debug_level > 0 THEN
590: OE_Debug_PUB.ADD('Oe_PC_Constraints_Admin_Pub.Generate_Constraint_API: EXCEPTION');
591: END IF;
592: END Generate_Constraint_API;
593: ----------------------------------------------------------------------
594:

Line 821: FROM oe_pc_constraints c

817: THEN
818:
819: SELECT c.constrained_operation, c.column_name
820: INTO l_operation, l_column_name
821: FROM oe_pc_constraints c
822: WHERE c.constraint_id = p_constraint_id;
823:
824: IF l_column_name IS NOT NULL THEN
825: -- Bug 2721841, attribute_label_long is the translated

Line 909: END Oe_PC_Constraints_Admin_Pub;

905: END IF;
906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
907: END Add_Constraint_Message;
908:
909: END Oe_PC_Constraints_Admin_Pub;