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.

[Home] [Help]

APPS.OM_SETUP_VALID_PKG dependencies on OM_SETUP_VALID_ENTITIES

Line 963: Following PL/SQL block inserts rows into the om_setup_valid_entities table.

959: BEGIN
960: DECLARE
961: BEGIN
962: /*------------------------------------------------------------------------------
963: Following PL/SQL block inserts rows into the om_setup_valid_entities table.
964: ------------------------------------------------------------------------------*/
965:
966: BEGIN
967: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 967: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

963: Following PL/SQL block inserts rows into the om_setup_valid_entities table.
964: ------------------------------------------------------------------------------*/
965:
966: BEGIN
967: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
968: VALUES ('Key Flex Field Setup', 'VALIDATE_SALES_ORDER_KEYFLEX', 'N', 'N', 'N', 'Y', 1);
969: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
970: VALUES ('Key Flex Field Setup', 'VALIDATE_ITEM_CATALOGS_FLEX', 'N', 'N', 'N', 'Y', 2);
971: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 969: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

965:
966: BEGIN
967: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
968: VALUES ('Key Flex Field Setup', 'VALIDATE_SALES_ORDER_KEYFLEX', 'N', 'N', 'N', 'Y', 1);
969: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
970: VALUES ('Key Flex Field Setup', 'VALIDATE_ITEM_CATALOGS_FLEX', 'N', 'N', 'N', 'Y', 2);
971: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
972: VALUES ('Shipping Organizations', 'VALIDATE_SHIPPING_ORGS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 3);
973: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 971: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

967: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
968: VALUES ('Key Flex Field Setup', 'VALIDATE_SALES_ORDER_KEYFLEX', 'N', 'N', 'N', 'Y', 1);
969: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
970: VALUES ('Key Flex Field Setup', 'VALIDATE_ITEM_CATALOGS_FLEX', 'N', 'N', 'N', 'Y', 2);
971: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
972: VALUES ('Shipping Organizations', 'VALIDATE_SHIPPING_ORGS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 3);
973: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
974: VALUES ('Period Status', 'VALIDATE_PERIOD_STATUS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 4);
975: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 973: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

969: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
970: VALUES ('Key Flex Field Setup', 'VALIDATE_ITEM_CATALOGS_FLEX', 'N', 'N', 'N', 'Y', 2);
971: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
972: VALUES ('Shipping Organizations', 'VALIDATE_SHIPPING_ORGS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 3);
973: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
974: VALUES ('Period Status', 'VALIDATE_PERIOD_STATUS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 4);
975: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
976: VALUES ('Profile Options', 'VALIDATE_PROFILE_OPTIONS(:lvl, :val)', 'Y', 'Y', 'Y', 'Y', 5);
977: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 975: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

971: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
972: VALUES ('Shipping Organizations', 'VALIDATE_SHIPPING_ORGS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 3);
973: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
974: VALUES ('Period Status', 'VALIDATE_PERIOD_STATUS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 4);
975: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
976: VALUES ('Profile Options', 'VALIDATE_PROFILE_OPTIONS(:lvl, :val)', 'Y', 'Y', 'Y', 'Y', 5);
977: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
978: VALUES ('User Level Profile Options', 'VALIDATE_USER_PROFILE_OPTIONS(:lvl, :val)', 'Y', 'Y', 'Y', 'Y', 6);
979: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 977: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

973: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
974: VALUES ('Period Status', 'VALIDATE_PERIOD_STATUS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 4);
975: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
976: VALUES ('Profile Options', 'VALIDATE_PROFILE_OPTIONS(:lvl, :val)', 'Y', 'Y', 'Y', 'Y', 5);
977: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
978: VALUES ('User Level Profile Options', 'VALIDATE_USER_PROFILE_OPTIONS(:lvl, :val)', 'Y', 'Y', 'Y', 'Y', 6);
979: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
980: VALUES ('Item Validation Organization', 'VALIDATE_ITEM_VALID_ORG(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 7);
981: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 979: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

975: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
976: VALUES ('Profile Options', 'VALIDATE_PROFILE_OPTIONS(:lvl, :val)', 'Y', 'Y', 'Y', 'Y', 5);
977: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
978: VALUES ('User Level Profile Options', 'VALIDATE_USER_PROFILE_OPTIONS(:lvl, :val)', 'Y', 'Y', 'Y', 'Y', 6);
979: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
980: VALUES ('Item Validation Organization', 'VALIDATE_ITEM_VALID_ORG(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 7);
981: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
982: VALUES ('Document Sequences For Sales Orders', 'VALIDATE_DOC_SEQ_SALES_ORDERS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 8);
983: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 981: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

977: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
978: VALUES ('User Level Profile Options', 'VALIDATE_USER_PROFILE_OPTIONS(:lvl, :val)', 'Y', 'Y', 'Y', 'Y', 6);
979: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
980: VALUES ('Item Validation Organization', 'VALIDATE_ITEM_VALID_ORG(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 7);
981: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
982: VALUES ('Document Sequences For Sales Orders', 'VALIDATE_DOC_SEQ_SALES_ORDERS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 8);
983: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
984: VALUES ('Document Sequences for Shipping Documents', 'VALIDATE_DOC_SEQ_SHIPPING(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 9);
985: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 983: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

979: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
980: VALUES ('Item Validation Organization', 'VALIDATE_ITEM_VALID_ORG(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 7);
981: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
982: VALUES ('Document Sequences For Sales Orders', 'VALIDATE_DOC_SEQ_SALES_ORDERS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 8);
983: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
984: VALUES ('Document Sequences for Shipping Documents', 'VALIDATE_DOC_SEQ_SHIPPING(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 9);
985: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
986: VALUES ('Item Definition', 'VALIDATE_ITEM_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 10);
987: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 985: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

981: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
982: VALUES ('Document Sequences For Sales Orders', 'VALIDATE_DOC_SEQ_SALES_ORDERS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 8);
983: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
984: VALUES ('Document Sequences for Shipping Documents', 'VALIDATE_DOC_SEQ_SHIPPING(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 9);
985: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
986: VALUES ('Item Definition', 'VALIDATE_ITEM_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 10);
987: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
988: VALUES ('Price List Definition', 'VALIDATE_PRICE_LIST_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 11);
989: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 987: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

983: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
984: VALUES ('Document Sequences for Shipping Documents', 'VALIDATE_DOC_SEQ_SHIPPING(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 9);
985: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
986: VALUES ('Item Definition', 'VALIDATE_ITEM_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 10);
987: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
988: VALUES ('Price List Definition', 'VALIDATE_PRICE_LIST_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 11);
989: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
990: VALUES ('Transaction Type', 'VALIDATE_TRANSACTION_TYPES(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 12);
991: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 989: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

985: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
986: VALUES ('Item Definition', 'VALIDATE_ITEM_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 10);
987: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
988: VALUES ('Price List Definition', 'VALIDATE_PRICE_LIST_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 11);
989: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
990: VALUES ('Transaction Type', 'VALIDATE_TRANSACTION_TYPES(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 12);
991: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
992: VALUES ('Credit Checking Setup', 'VALIDATE_CREDIT_CHECKING(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 13);
993: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 991: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

987: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
988: VALUES ('Price List Definition', 'VALIDATE_PRICE_LIST_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 11);
989: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
990: VALUES ('Transaction Type', 'VALIDATE_TRANSACTION_TYPES(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 12);
991: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
992: VALUES ('Credit Checking Setup', 'VALIDATE_CREDIT_CHECKING(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 13);
993: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
994: VALUES ('Sales Credit', 'VALIDATE_SALES_CRDT_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 14);
995: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 993: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

989: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
990: VALUES ('Transaction Type', 'VALIDATE_TRANSACTION_TYPES(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 12);
991: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
992: VALUES ('Credit Checking Setup', 'VALIDATE_CREDIT_CHECKING(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 13);
993: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
994: VALUES ('Sales Credit', 'VALIDATE_SALES_CRDT_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 14);
995: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
996: VALUES ('Freight Carrier', 'VALIDATE_FREIGHT_CARRIER(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 15);
997: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 995: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

991: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
992: VALUES ('Credit Checking Setup', 'VALIDATE_CREDIT_CHECKING(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 13);
993: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
994: VALUES ('Sales Credit', 'VALIDATE_SALES_CRDT_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 14);
995: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
996: VALUES ('Freight Carrier', 'VALIDATE_FREIGHT_CARRIER(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 15);
997: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
998: VALUES ('Set of Books', 'VALIDATE_SET_OF_BOOKS_SETUP(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 16);
999: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 997: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

993: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
994: VALUES ('Sales Credit', 'VALIDATE_SALES_CRDT_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 14);
995: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
996: VALUES ('Freight Carrier', 'VALIDATE_FREIGHT_CARRIER(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 15);
997: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
998: VALUES ('Set of Books', 'VALIDATE_SET_OF_BOOKS_SETUP(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 16);
999: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
1000: VALUES ('Shipping Grants and Roles', 'VALIDATE_SHIPPING_GRANTS_ROLES(:lvl, :val)', 'Y', 'N', 'N', 'Y', 17);
1001: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

Line 999: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

995: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
996: VALUES ('Freight Carrier', 'VALIDATE_FREIGHT_CARRIER(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 15);
997: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
998: VALUES ('Set of Books', 'VALIDATE_SET_OF_BOOKS_SETUP(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 16);
999: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
1000: VALUES ('Shipping Grants and Roles', 'VALIDATE_SHIPPING_GRANTS_ROLES(:lvl, :val)', 'Y', 'N', 'N', 'Y', 17);
1001: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
1002: VALUES ('System', 'None', 'N', 'Y', 'N', 'N', 18);
1003: EXCEPTION

Line 1001: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)

997: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
998: VALUES ('Set of Books', 'VALIDATE_SET_OF_BOOKS_SETUP(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 16);
999: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
1000: VALUES ('Shipping Grants and Roles', 'VALIDATE_SHIPPING_GRANTS_ROLES(:lvl, :val)', 'Y', 'N', 'N', 'Y', 17);
1001: INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
1002: VALUES ('System', 'None', 'N', 'Y', 'N', 'N', 18);
1003: EXCEPTION
1004: WHEN OTHERS THEN
1005: begin