APPS.OM_SETUP_VALID_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 164

		SELECT FPO.PROFILE_OPTION_ID
		INTO prof_opt_id
		FROM FND_PROFILE_OPTIONS FPO, FND_PROFILE_OPTIONS_TL FPOT
		WHERE FPO.PROFILE_OPTION_NAME = FPOT.PROFILE_OPTION_NAME
		AND FPOT.LANGUAGE=USERENV('LANG')
		AND FPOT.PROFILE_OPTION_NAME LIKE prof_opt_name;

Line: 181

		SELECT FPOT.USER_PROFILE_OPTION_NAME
		INTO user_prof_opt_name
		FROM FND_PROFILE_OPTIONS_TL FPOT
		WHERE FPOT.LANGUAGE=USERENV('LANG')
		AND FPOT.PROFILE_OPTION_NAME LIKE prof_opt_name;

Line: 202

			SELECT PROFILE_OPTION_VALUE
			INTO prof_opt_val
			FROM FND_PROFILE_OPTION_VALUES
			WHERE PROFILE_OPTION_ID = prof_opt_id
			AND LEVEL_ID = lvl_id
			AND ROWNUM < 2;

Line: 209

			SELECT PROFILE_OPTION_VALUE
			INTO prof_opt_val
			FROM FND_PROFILE_OPTION_VALUES
			WHERE PROFILE_OPTION_ID = prof_opt_id
			AND LEVEL_ID = lvl_id
			AND LEVEL_VALUE = lvl_value
			AND ROWNUM < 2;

Line: 231

			SELECT USER_ID, RESPONSIBILITY_ID
			FROM FND_USER_RESP_GROUPS;

Line: 260

			SELECT RESPONSIBILITY_ID
			FROM FND_RESPONSIBILITY;

Line: 287

			SELECT USER_ID
			FROM FND_USER;

Line: 316

		SELECT USER_NAME
		INTO username
		FROM FND_USER
		WHERE USER_ID = userid;

Line: 331

		SELECT NAME
		INTO ouname
		FROM HR_ALL_ORGANIZATION_UNITS_TL
		WHERE ORGANIZATION_ID = ouid
		AND LANGUAGE = USERENV('LANG');

Line: 348

		SELECT NAME
		INTO ttypename
		FROM OE_TRANSACTION_TYPES_TL
		WHERE TRANSACTION_TYPE_ID = ttypeid
		AND LANGUAGE=USERENV('LANG');

Line: 365

			SELECT RESPONSIBILITY_NAME
			INTO resp_name
			FROM FND_RESPONSIBILITY_TL
			WHERE RESPONSIBILITY_ID = resp_id
			AND LANGUAGE=USERENV('LANG');

Line: 383

			SELECT APPLICATION_NAME
			INTO appl_name
			FROM FND_APPLICATION_TL
			WHERE APPLICATION_ID = appl_id
			AND LANGUAGE=USERENV('LANG');

Line: 404

			SELECT  ORGANIZATION_ID
			FROM    WSH_SHIPPING_PARAMETERS
			WHERE   ORGANIZATION_ID IN (
			SELECT 	HOU.ORGANIZATION_ID ORGANIZATION_ID
			FROM 	HR_ORGANIZATION_UNITS HOU,
				HR_ORGANIZATION_INFORMATION HOI,
				FND_PRODUCT_GROUPS FPG
			WHERE 	HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID
			AND     DECODE ( FPG.MULTI_ORG_FLAG, 'Y',
				DECODE (HOI.ORG_INFORMATION_CONTEXT, 'Accounting Information',
						TO_NUMBER(HOI.ORG_INFORMATION3), TO_NUMBER(NULL)
						), TO_NUMBER(NULL)
					) = ou
			);

Line: 495

		SELECT MENU_ID, RESPONSIBILITY_ID
		FROM FND_RESPONSIBILITY;

Line: 514

			SELECT to_number(menus(i))
			INTO menu_id
			FROM DUAL;

Line: 546

			SELECT menu_id
			FROM FND_MENU_ENTRIES
			WHERE SUB_MENU_ID = submenu_id;

Line: 670

		INSERT INTO OM_SETUP_VALID_REP
		( ENTITY, P_LEVEL, P_VALUE, ERROR_TYPE,
		  MESG_NAME, TYPE, USER_NAME, OPERATING_UNIT,
		  ORGANIZATION, SET_OF_BOOKS_AR, SET_OF_BOOKS,
		  SET_OF_BOOKS_PF, PROFILE_OPTION, TRANSACT_TYPE,
		  DOC_CATEGORY, PAYMENT_TERM
		)
		VALUES
		( ENTITY, P_F_LEVEL, P_F_VALUE, ERROR_TYPE,
		  MESG_NAME, TYPE, USER_NAME, OPERATING_UNIT,
		  ORGANIZATION_ID, SET_OF_BOOKS_AR, SET_OF_BOOKS,
		  SET_OF_BOOKS_PF, PROFILE_OPTION, TRANSACT_TYPE,
		  DOC_CATEGORY, PAYMENT_TERM
		);

Line: 727

		SELECT RESPONSIBILITY_ID
		INTO resp_id
		FROM FND_USER_RESP_GROUPS
		WHERE USER_ID = user_id
		AND RESPONSIBILITY_APPLICATION_ID = 660
		AND ROWNUM < 2;

Line: 746

		SELECT COUNT(ORG_ID)
		INTO orgcount
		FROM OE_SYS_PARAMETERS_ALL
		WHERE ORG_ID = oper_unit;

Line: 807

		SELECT APPLICATION_ID
		FROM FND_RESPONSIBILITY
		WHERE RESPONSIBILITY_ID=resp_id;

Line: 921

		SELECT USER_ID
		FROM FND_USER_RESP_GROUPS
		WHERE RESPONSIBILITY_ID=resp_id;

Line: 963

	Following PL/SQL block inserts rows into the om_setup_valid_entities table.
	------------------------------------------------------------------------------*/

  	      BEGIN
    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Key Flex Field Setup', 'VALIDATE_SALES_ORDER_KEYFLEX', 'N', 'N', 'N', 'Y', 1);

Line: 969

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Key Flex Field Setup', 'VALIDATE_ITEM_CATALOGS_FLEX', 'N', 'N', 'N', 'Y', 2);

Line: 971

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Shipping Organizations', 'VALIDATE_SHIPPING_ORGS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 3);

Line: 973

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Period Status', 'VALIDATE_PERIOD_STATUS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 4);

Line: 975

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Profile Options', 'VALIDATE_PROFILE_OPTIONS(:lvl, :val)', 'Y', 'Y', 'Y', 'Y', 5);

Line: 977

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('User Level Profile Options', 'VALIDATE_USER_PROFILE_OPTIONS(:lvl, :val)', 'Y', 'Y', 'Y', 'Y', 6);

Line: 979

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Item Validation Organization', 'VALIDATE_ITEM_VALID_ORG(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 7);

Line: 981

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Document Sequences For Sales Orders', 'VALIDATE_DOC_SEQ_SALES_ORDERS(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 8);

Line: 983

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Document Sequences for Shipping Documents', 'VALIDATE_DOC_SEQ_SHIPPING(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 9);

Line: 985

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Item Definition', 'VALIDATE_ITEM_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 10);

Line: 987

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Price List Definition', 'VALIDATE_PRICE_LIST_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 11);

Line: 989

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Transaction Type', 'VALIDATE_TRANSACTION_TYPES(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 12);

Line: 991

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Credit Checking Setup', 'VALIDATE_CREDIT_CHECKING(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 13);

Line: 993

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Sales Credit', 'VALIDATE_SALES_CRDT_DEFINITION(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 14);

Line: 995

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Freight Carrier', 'VALIDATE_FREIGHT_CARRIER(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 15);

Line: 997

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Set of Books', 'VALIDATE_SET_OF_BOOKS_SETUP(:lvl, :val)', 'N', 'Y', 'Y', 'Y', 16);

Line: 999

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('Shipping Grants and Roles', 'VALIDATE_SHIPPING_GRANTS_ROLES(:lvl, :val)', 'Y', 'N', 'N', 'Y', 17);

Line: 1001

    	         INSERT INTO OM_SETUP_VALID_ENTITIES(ENTITY_NAME, PROCEDURE_NAME, USER_FLAG, RESPONSIBILITY_FLAG, OPERATING_UNIT_FLAG, INSTANCE_FLAG, SEQUENCE_NUM)
    	         VALUES ('System', 'None', 'N', 'Y', 'N', 'N', 18);

Line: 1010

	Following PL/SQL block inserts rows into the om_setup_valid_errm table.
	------------------------------------------------------------------------------*/
	      BEGIN
    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_PROF_OPT', 'The following profile options have not been defined at any level.');

Line: 1016

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_USER_PROF_OPT', 'The following profile options should not have a value for any user that has access to an Order Management responsibility.');

Line: 1019

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_USR_PRF_OPT', 'The following profile options should not have a value for any user that has access to an Order Management responsibility.');

Line: 1021

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_SOB', 'Set of books do not match between AR system option and GL Set of Books name profile option.');

Line: 1023

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_MASTER_ORG', 'Item Validation Organizations do not match between OM Parameters and QP: Item Validation Organization profile option.');

Line: 1025

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_SO_FLEX', 'Sales Order Key Flex Field is not included required 3 segments or not enabled or not allowed dynamic insert.');

Line: 1027

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_ITMCAT_FLEX', 'Item Catalogs Key Flex Field is not enabled or not frozen.');

Line: 1029

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_NOTFOUND_DOC_SEQ ', 'There are no document sequences defined for Oracle Order Management.');

Line: 1031

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_NOTFOUND_DOC_CAT', 'A document category with the same name as the transaction type does not exist.');

Line: 1033

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_DOC_SEQ', 'There is not a document sequence assignment in the set of book corresponding to each operating unit with OM parameters defined for Oracle Order Management.');

Line: 1035

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INACTIVE_DOC_SEQ', 'The following document category should be actively assigned, in the set of books corresponding to the operating unit of the transaction type, to an active sequence.');

Line: 1037

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_CC_NOTFOUND', 'No credit check rules exist.');

Line: 1040

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_CC_INVALID_TRAN_TYPE', 'Credit check rules are not enabled in the following transaction type.');

Line: 1043

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_CC_INVALID_TRAN_TYP', 'Credit check rules are not enabled in the following transaction type.');

Line: 1045

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_CC_INVALID_PAY_TERM', 'There is no payment term that is enabled for credit checking.');

Line: 1047

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_CC_INVALID_CUST', 'There is no customer or the customer site that is enabled for credit checking.');

Line: 1049

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_CC_PRE_CALC_EXPO', 'The Credit Checking Initialize process is not scheduled and there is at least one credit check rule using pre-calculated Exposure.');

Line: 1051

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_ITEM', 'No item exists in the following inventory organizations with OE Transactable, Customer Ordered, Customer Order Enabled, Returnable, Internal Ordered, Internal Orders Enabled, OE Transactable enabled');

Line: 1053

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_PRC_LST', 'No active price list exists with items assigned to it.');

Line: 1055

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_SLS_CRDT', 'No sales credit type exists for both quota and non-quota types.');

Line: 1057

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_SHIP_ORG', 'Shipping parameters have not been defined in any inventory organizations in the following shipping operating units.');

Line: 1059

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_DFLT_SUBINV', 'A default staging subinventory has not been defined in the following shipping inventory organizations.');

Line: 1061

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_SUBINV_ORGN', 'Subinventories are not defined in the following shipping inventory organizations.');

Line: 1063

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_SHIP_OMORG', 'Shipping parameters have not been defined in the following inventory organizations.');

Line: 1065

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_PICK_RULES', 'No picking rule exists in the following shipping inventory organizations.');

Line: 1067

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_NO_OPEN_PERIOD', 'No open period exists in the following inventory organizations.');

Line: 1069

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_CURR_PERIOD', 'The current period is not opened in the following inventory organizations.');

Line: 1071

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_FC_INACTIVE_ALL', 'No active carrier exists.');

Line: 1073

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_FC_INACTIVE_ORG', 'No active carrier exists in any inventory organizations under the following Operating Unit.');

Line: 1075

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_FC_RELATIONS', 'No carrier / ship method relationships exist in any inventory organizations under the following Operating Unit.');

Line: 1077

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_SHIP_DOC_SEQ', 'There are no document sequences defined for Oracle Shipping.');

Line: 1079

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_SHIP_DOC_BOL', 'There are no document categories defined for BOL.');

Line: 1081

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_SHIP_DOC_PKSLP', 'There are no document sequence categories defined for Pack Slip.');

Line: 1083

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_SHIP_DOC_SEQ_ASSGN', 'There is not a document sequence assignment in the set of book corresponding to each operating unit with OM parameters defined for both BOL and Pack Slip.');

Line: 1085

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_NOTFOUND_ROLES', 'No shipping role are defined. ');

Line: 1087

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_NOTFOUND_ROLES_USER', 'No shipping role is assigned to this user. ');

Line: 1090

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_NOTFOUND_ROLES_USERS', 'No shipping role is assigned to any existing user. ');

Line: 1093

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_NOTFOUND_ROLE_USERS', 'No shipping role is assigned to any existing user. ');

Line: 1095

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_TRAN_TYPE_1', 'No transaction type is defined in the following operating units.');

Line: 1097

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_TRAN_TYPE_2', 'No Order workflow assignment exists for any the following transaction types in the following operating units.');

Line: 1099

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_TRAN_TYPE_3', 'No line workflow exists for any the following transaction types in the following operating units.');

Line: 1101

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_TRAN_TYPE_4', 'No credit checking for booking or shipping either Ordering, Packing, Picking or Shipping for any the following transaction types exists in the following operating units.');

Line: 1103

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_TRAN_TYPE_5', 'Schduling level is not set for the following transaction types in the following operating units.');

Line: 1105

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_TRAN_TYPE_6', 'COGS account is not set for the following transaction types in the following operating units.');

Line: 1107

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_TRAN_TYPE_7', 'Invoice source and Non-Delivery invoice source are not set for the following transaction types in the following operating units.');

Line: 1109

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_TRAN_TYPE_8', 'Receivables Transaction Type is not set in the following operating units.');

Line: 1111

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_TRAN_TYPE_9', 'No default order line type exists for the following transaction types in the following operating units.');

Line: 1114

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_TRAN_TYPE_10', 'No default return line type exists for the following transaction types in the following operating units.');

Line: 1117

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_TRAN_TYPE10', 'No default return line type exists for the following transaction types in the following operating units.');

Line: 1119

    	         INSERT INTO OM_SETUP_VALID_ERRM(MESG_NAME, DESCRIPTION)
    	         VALUES('ONT_SETVAL_INVALID_INPUT', 'The selected responsibility cannot be validated for OM Setup as it cannot access the Sales Orders, Shipping Transactions and Price Lists forms.');

Line: 1129

	Following PL/SQL block inserts rows into the OM_SETUP_VALID_PROF_OPT table.
	------------------------------------------------------------------------------*/
	      BEGIN
    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('AR_USE_INV_ACCT_FOR_CM_FLAG', 'INST', 660 );

Line: 1134

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('CZ_UIMGR_URL', 'INST', 660 );

Line: 1136

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_ADMINISTER_PUBLIC_QUERIES', 'INST', 660 );

Line: 1138

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_CREDIT_TRANSACTION_TYPE_ID', 'INST', 660 );

Line: 1140

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('WSH_CR_SREP_FOR_FREIGHT', 'INST', 660 );

Line: 1142

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_CUST_ITEM_SHOW_MATCHES', 'INST', 660 );

Line: 1144

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_EST_AUTH_VALID_DAYS', 'INST', 660 );

Line: 1146

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_INCLUDED_ITEM_FREEZE_METHOD', 'INST', 660 );

Line: 1148

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('WSH_INVOICE_NUMBERING_METHOD', 'INST', 660 );

Line: 1150

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_INVOICE_SOURCE', 'INST', 660 );

Line: 1152

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_INVOICE_TRANSACTION_TYPE_ID', 'INST', 660 );

Line: 1154

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_ID_FLEX_CODE', 'INST', 660 );

Line: 1156

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_NON_DELIVERY_INVOICE_SOURCE', 'INST', 660 );

Line: 1158

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OM_OVER_RETURN_TOLERANCE', 'INST', 660 );

Line: 1160

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_OVERSHIP_INVOICE_BASIS', 'INST', 660 );

Line: 1162

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OM_OVER_SHIPMENT_TOLERANCE', 'INST', 660 );

Line: 1164

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_RETURN_ITEM_MISMATCH_ACTION', 'INST', 660 );

Line: 1166

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_RETURN_FULFILLED_LINE_ACTION', 'INST', 660 );

Line: 1168

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_DISCOUNT_DETAILS_ON_INVOICE', 'INST', 660 );

Line: 1170

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_SOURCE_CODE', 'INST', 660 );

Line: 1172

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OM_UNDER_RETURN_TOLERANCE', 'INST', 660 );

Line: 1174

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OM_UNDER_SHIPMENT_TOLERANCE', 'INST', 660 );

Line: 1176

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_BLIND_DISCOUNT', 'INST', 660 );

Line: 1178

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_ORGANIZATION_ID', 'INST', 660 );

Line: 1180

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_NEGATIVE_PRICING', 'INST', 660 );

Line: 1182

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_SOURCE_SYSTEM_CODE', 'INST', 660 );

Line: 1184

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_UNIT_PRICE_PRECISION_TYPE', 'INST', 660 );

Line: 1186

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_VERIFY_GSA', 'INST', 660 );

Line: 1188

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('UNIQUE:SEQ_NUMBERS', 'INST', 660 );

Line: 1190

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('AR_ALLOW_TAX_UPDATE', 'INST', 660 );

Line: 1192

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('AR_ALLOW_TAX_CODE_OVERRIDE', 'INST', 660 );

Line: 1194

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('AR_TAX_USE_VENDOR', 'INST', 660 );

Line: 1196

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('AR_USE_INV_ACCT_FOR_CM_FLAG', 'USER', 660 );

Line: 1198

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('CZ_UIMGR_URL', 'USER', 660 );

Line: 1200

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('BOM:ITEM_SEQUENCE_INCREMENT', 'USER', 660 );

Line: 1202

    	         --INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         --VALUES('BOM:DEFAULT_BOM_LEVELS', 'USER', 660 );

Line: 1204

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_ADMINISTER_PUBLIC_QUERIES', 'USER', 660 );

Line: 1206

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_APPLY_AUTOMATIC_ATCHMT', 'USER', 660 );

Line: 1208

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_AUTOSCHEDULE', 'USER', 660 );

Line: 1210

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_CREDIT_CARD_PRIVILEGES', 'USER', 660 );

Line: 1212

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_CREDIT_TRANSACTION_TYPE_ID', 'USER', 660 );

Line: 1214

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_CUSTOMER_RELATIONSHIPS', 'USER', 660 );

Line: 1216

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_EST_AUTH_VALID_DAYS', 'USER', 660 );

Line: 1218

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_GSA_VIOLATION_ACTION', 'USER', 660 );

Line: 1220

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_INCLUDED_ITEM_FREEZE_METHOD', 'USER', 660 );

Line: 1222

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('WSH_INVOICE_NUMBERING_METHOD', 'USER', 660 );

Line: 1224

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_INVOICE_SOURCE', 'USER', 660 );

Line: 1226

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_INVOICE_TRANSACTION_TYPE_ID', 'USER', 660 );

Line: 1228

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_ID_FLEX_CODE', 'USER', 660 );

Line: 1230

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_NON_DELIVERY_INVOICE_SOURCE', 'USER', 660 );

Line: 1232

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OM_OVER_RETURN_TOLERANCE', 'USER', 660 );

Line: 1234

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OM_OVER_SHIPMENT_TOLERANCE', 'USER', 660 );

Line: 1236

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_OVERSHIP_INVOICE_BASIS', 'USER', 660 );

Line: 1238

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_RECEIPT_METHOD_ID', 'USER', 660 );

Line: 1240

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_RESERVATION_TIME_FENCE', 'USER', 660 );

Line: 1242

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_RETURN_ITEM_MISMATCH_ACTION', 'USER', 660 );

Line: 1244

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_RETURN_FULFILLED_LINE_ACTION', 'USER', 660 );

Line: 1246

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_RISK_FAC_THRESHOLD', 'USER', 660 );

Line: 1248

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_SCHEDULE_LINE_ON_HOLD', 'USER', 660 );

Line: 1250

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_DISCOUNT_DETAILS_ON_INVOICE', 'USER', 660 );

Line: 1252

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ONT_SOURCE_CODE', 'USER', 660 );

Line: 1254

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OM_UNDER_RETURN_TOLERANCE', 'USER', 660 );

Line: 1256

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OM_UNDER_SHIPMENT_TOLERANCE', 'USER', 660 );

Line: 1258

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_ACCRUAL_UOM_CLASS', 'USER', 660 );

Line: 1260

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_BLIND_DISCOUNT', 'USER', 660 );

Line: 1262

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_ORGANIZATION_ID', 'USER', 660 );

Line: 1264

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_LINE_VOLUME_UOM_CODE', 'USER', 660 );

Line: 1266

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_LINE_WEIGHT_UOM_CODE', 'USER', 660 );

Line: 1268

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_NEGATIVE_PRICING', 'USER', 660 );

Line: 1270

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_SOURCE_SYSTEM_CODE', 'USER', 660 );

Line: 1272

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_UNIT_PRICE_PRECISION_TYPE', 'USER', 660 );

Line: 1274

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('QP_VERIFY_GSA', 'USER', 660 );

Line: 1276

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('UNIQUE:SEQ_NUMBERS', 'USER', 660 );

Line: 1278

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('AR_ALLOW_TAX_UPDATE', 'USER', 660 );

Line: 1280

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('AR_ALLOW_MANUAL_TAX_LINES', 'USER', 660 );

Line: 1282

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('AR_ALLOW_TAX_CODE_OVERRIDE', 'USER', 660 );

Line: 1284

   	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('AR_TAX_USE_VENDOR', 'USER', 660 );

Line: 1286

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('SO_INVOICE_FREIGHT_AS_LINE', 'USER', 660 );

Line: 1288

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('OE_INVENTORY_ITEM_FOR_FREIGHT', 'USER', 660 );

Line: 1290

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('AR_CALCULATE_TAX_ON_CM', 'USER', 660 );

Line: 1292

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('WSH_CR_SREP_FOR_FREIGHT', 'USER', 660 );

Line: 1294

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('ORG_ID', 'USER', 660 );

Line: 1296

    	         INSERT INTO OM_SETUP_VALID_PROF_OPT(PROFILE_OPTION_NAME, VAL_LEVEL, APPLICATION_ID)
    	         VALUES('GL_SET_OF_BKS_NAME', 'USER', 660 );

Line: 1336

             select application_id, function_id
             from fnd_form_functions
             where form_id = c_form_id;

Line: 1360

          select form_id
          into l_form_id
          from fnd_form
          where form_name = l_form_name;

Line: 1368

          select application_id
          into l_application_id
          from fnd_application
	  where application_short_name = l_application;

Line: 1411

		SELECT menu_id
		FROM FND_MENU_ENTRIES
		WHERE FUNCTION_ID = func_id;

Line: 1454

			SELECT PROFILE_OPTION_NAME
			FROM OM_SETUP_VALID_PROF_OPT
			WHERE VAL_LEVEL = 'INST'
			AND APPLICATION_ID = 660;

Line: 1552

			SELECT PROFILE_OPTION_NAME
			FROM OM_SETUP_VALID_PROF_OPT
			WHERE VAL_LEVEL = 'USER'
			AND APPLICATION_ID = 660;

Line: 1644

				SELECT gsob.NAME
				INTO sobar
				FROM AR_SYSTEM_PARAMETERS_ALL aspa, GL_SETS_OF_BOOKS gsob
				WHERE aspa.ORG_ID = oulist(i)
				AND gsob.SET_OF_BOOKS_ID = aspa.SET_OF_BOOKS_ID;

Line: 1652

                                 SELECT gsob.NAME
                                 INTO sobar
                                 FROM GL_SETS_OF_BOOKS gsob
                                 WHERE gsob.SET_OF_BOOKS_ID = l_sob_id;

Line: 1663

				SELECT gsob.NAME
				INTO sobhr
				FROM HR_OPERATING_UNITS hou, GL_SETS_OF_BOOKS gsob
				WHERE hou.ORGANIZATION_ID = oulist(i)
				AND gsob.SET_OF_BOOKS_ID = hou.SET_OF_BOOKS_ID;

Line: 1685

						SELECT COUNT(APPLICATION_ID)
						INTO appcount
						FROM FND_RESPONSIBILITY
						WHERE RESPONSIBILITY_ID = RESP_LIST(j)
						AND APPLICATION_ID = APPS_LIST(k);

Line: 1745

				SELECT MASTER_ORGANIZATION_ID
				INTO mstrorg
				FROM OE_SYSTEM_PARAMETERS_ALL
				WHERE ORG_ID = oulist(j);

Line: 1812

			SELECT 	DYNAMIC_INSERTS_ALLOWED_FLAG,
				FFST.ENABLED_FLAG
			FROM 	FND_ID_FLEX_STRUCTURES_VL FFST,
				FND_ID_FLEX_SEGMENTS_VL      FFSG,
				FND_FLEX_VALUE_SETS          FVS
			WHERE 	FFST.APPLICATION_ID     = 401
			AND 	FFST.ID_FLEX_CODE         = 'MKTS'
			AND 	FFST.APPLICATION_ID       = FFSG.APPLICATION_ID
			AND 	FFST.ID_FLEX_CODE         = FFSG.ID_FLEX_CODE
			AND 	FFST.ID_FLEX_NUM          = FFSG.ID_FLEX_NUM
			AND 	FVS.FLEX_VALUE_SET_ID(+)  = FFSG.FLEX_VALUE_SET_ID;

Line: 1826

			SELECT 	SEGMENT_NUM,
				SEGMENT_NAME,
				FFST.ENABLED_FLAG
			FROM 	FND_ID_FLEX_STRUCTURES_VL FFST,
				FND_ID_FLEX_SEGMENTS_VL      FFSG,
				FND_FLEX_VALUE_SETS          FVS
			WHERE 	FFST.APPLICATION_ID     = 401
			AND 	FFST.ID_FLEX_CODE         = 'MKTS'
			AND 	FFST.APPLICATION_ID       = FFSG.APPLICATION_ID
			AND 	FFST.ID_FLEX_CODE         = FFSG.ID_FLEX_CODE
			AND 	FFST.ID_FLEX_NUM          = FFSG.ID_FLEX_NUM
			AND 	FVS.FLEX_VALUE_SET_ID(+)  = FFSG.FLEX_VALUE_SET_ID;

Line: 1853

			dyninsa := flex.DYNAMIC_INSERTS_ALLOWED_FLAG;

Line: 1895

			SELECT 	FREEZE_FLEX_DEFINITION_FLAG,
				SEGMENT_NUM,
				SEGMENT_NAME,
				FFSG.ENABLED_FLAG
			FROM 	FND_ID_FLEX_STRUCTURES_VL FFST,
				FND_ID_FLEX_SEGMENTS_VL      FFSG,
				FND_FLEX_VALUE_SETS          FVS
			WHERE 	FFST.APPLICATION_ID     = 401
			AND 	FFST.ID_FLEX_CODE         = 'MICG'
			AND 	FFST.APPLICATION_ID       = FFSG.APPLICATION_ID
			AND 	FFST.ID_FLEX_CODE         = FFSG.ID_FLEX_CODE
			AND 	FFST.ID_FLEX_NUM          = FFSG.ID_FLEX_NUM
			AND 	FVS.FLEX_VALUE_SET_ID(+)  = FFSG.FLEX_VALUE_SET_ID;

Line: 1974

			SELECT T.TRANSACTION_TYPE_ID, T.ORG_ID
			FROM OE_TRANSACTION_TYPES_ALL T
			WHERE NOT T.TRANSACTION_TYPE_ID IN ( SELECT UNIQUE ORDER_TYPE_ID
						       FROM OE_WORKFLOW_ASSIGNMENTS
						       WHERE LINE_TYPE_ID IS NULL );

Line: 1981

			SELECT T.TRANSACTION_TYPE_ID, T.ORG_ID
			FROM OE_TRANSACTION_TYPES_ALL T
			WHERE NOT T.TRANSACTION_TYPE_ID IN ( SELECT UNIQUE ORDER_TYPE_ID
				  		       FROM OE_WORKFLOW_ASSIGNMENTS
				  		       WHERE LINE_TYPE_ID IS NOT NULL );

Line: 1988

			SELECT TRANSACTION_TYPE_ID, ORG_ID
			FROM OE_TRANSACTION_TYPES_ALL
			WHERE TRANSACTION_TYPE_CODE = 'ORDER'
			AND ORDER_CATEGORY_CODE <> 'RETURN'
			AND DEFAULT_OUTBOUND_LINE_TYPE_ID IS NULL;

Line: 1996

			SELECT TRANSACTION_TYPE_ID, ORG_ID
			FROM OE_TRANSACTION_TYPES_ALL
			WHERE TRANSACTION_TYPE_CODE = 'ORDER'
			AND DEFAULT_INBOUND_LINE_TYPE_ID IS NULL
			AND ORDER_CATEGORY_CODE <> 'ORDER';

Line: 2003

			SELECT TRANSACTION_TYPE_ID, ORG_ID
			FROM OE_TRANSACTION_TYPES_ALL
			WHERE ENTRY_CREDIT_CHECK_RULE_ID IS NULL
			AND SHIPPING_CREDIT_CHECK_RULE_ID IS NULL;

Line: 2009

			SELECT TRANSACTION_TYPE_ID, ORG_ID
			FROM OE_TRANSACTION_TYPES_ALL
			WHERE SCHEDULING_LEVEL_CODE IS NULL;

Line: 2014

			SELECT TRANSACTION_TYPE_ID, ORG_ID
			FROM OE_TRANSACTION_TYPES_ALL
			WHERE COST_OF_GOODS_SOLD_ACCOUNT IS NULL;

Line: 2019

			SELECT TRANSACTION_TYPE_ID, ORG_ID
			FROM OE_TRANSACTION_TYPES_ALL
			WHERE NON_DELIVERY_INVOICE_SOURCE_ID IS NULL
			AND INVOICE_SOURCE_ID IS NULL;

Line: 2025

			SELECT UNIQUE ORG_ID
			FROM OE_TRANSACTION_TYPES_ALL
			WHERE CUST_TRX_TYPE_ID IS NULL;

Line: 2047

			SELECT COUNT(TRANSACTION_TYPE_ID)
			INTO cnt1
			FROM OE_TRANSACTION_TYPES_ALL
			WHERE ORG_ID = oulist(i);

Line: 2212

			SELECT tl.NAME, b.ORG_ID
			FROM OE_TRANSACTION_TYPES_TL tl, OE_TRANSACTION_TYPES_ALL b
			WHERE tl.TRANSACTION_TYPE_ID = b.TRANSACTION_TYPE_ID
			AND tl.LANGUAGE=USERENV('LANG')
			ORDER BY b.ORG_ID;

Line: 2219

			SELECT tta.ORG_ID, fdsc.CODE, fdsc.NAME
			FROM FND_DOC_SEQUENCE_CATEGORIES fdsc
			     , OE_TRANSACTION_TYPES_ALL tta
			     , OE_TRANSACTION_TYPES_TL  ttl
			WHERE ttl.NAME = fdsc.NAME
			AND tta.TRANSACTION_TYPE_ID = ttl.TRANSACTION_TYPE_ID
			AND ttl.LANGUAGE=USERENV('LANG')
			ORDER BY tta.ORG_ID;

Line: 2229

		SELECT COUNT(DOC_SEQUENCE_ID)
		INTO docseqcnt
		FROM FND_DOCUMENT_SEQUENCES
		WHERE APPLICATION_ID = 660;

Line: 2260

					SELECT COUNT(NAME)
					INTO dscatcnt
					FROM FND_DOC_SEQUENCE_CATEGORIES
					WHERE NAME = ttype.NAME
					AND TABLE_NAME = 'OE_TRANSACTION_TYPES_ALL';

Line: 2283

						SELECT UNIQUE SET_OF_BOOKS_ID
						INTO sobhr
						FROM HR_OPERATING_UNITS
						WHERE ORGANIZATION_ID = doccat.ORG_ID;

Line: 2293

						SELECT COUNT(DOC_SEQUENCE_ASSIGNMENT_ID)
						INTO actcount
						FROM FND_DOC_SEQUENCE_ASSIGNMENTS
						WHERE CATEGORY_CODE = doccat.CODE
						AND START_DATE <= SYSDATE
						AND SYSDATE <= NVL ( END_DATE, SYSDATE)
						AND SET_OF_BOOKS_ID = sobhr;

Line: 2316

					SELECT UNIQUE SET_OF_BOOKS_ID
					INTO sobhr
					FROM HR_OPERATING_UNITS
					WHERE ORGANIZATION_ID = doccat.ORG_ID;

Line: 2326

					SELECT COUNT(SET_OF_BOOKS_ID)
					into sobcount
					FROM FND_DOC_SEQUENCE_ASSIGNMENTS
					WHERE SET_OF_BOOKS_ID = sobhr;

Line: 2361

			SELECT tl.NAME, b.ORG_ID
			FROM OE_TRANSACTION_TYPES_ALL b
			     , OE_TRANSACTION_TYPES_TL tl
			WHERE ENTRY_CREDIT_CHECK_RULE_ID IS NULL
			AND SHIPPING_CREDIT_CHECK_RULE_ID IS NULL
			AND PICKING_CREDIT_CHECK_RULE_ID IS NULL
			AND PACKING_CREDIT_CHECK_RULE_ID IS NULL
			AND tl.LANGUAGE = USERENV('LANG')
			AND tl.TRANSACTION_TYPE_ID = b.TRANSACTION_TYPE_ID;

Line: 2374

		SELECT COUNT(CREDIT_CHECK_RULE_ID)
		INTO ccrcnt
		FROM OE_CREDIT_CHECK_RULES;

Line: 2398

		SELECT COUNT(TERM_ID)
		INTO ptcount
		FROM RA_TERMS_B
		WHERE CREDIT_CHECK_FLAG = 'Y';

Line: 2407

				SELECT gl.name
				INTO sob
				FROM GL_SETS_OF_BOOKS gl
				     , HR_OPERATING_UNITS hou
				WHERE hou.organization_id = oulist(i)
				AND gl.set_of_books_id = hou.set_of_books_id;

Line: 2433

			SELECT COUNT(CUST_ACCOUNT_PROFILE_ID)
			INTO custcnt
			FROM HZ_CUSTOMER_PROFILES
			WHERE CREDIT_CHECKING = 'Y';

Line: 2444

			SELECT COUNT(CREDIT_CHECK_RULE_ID)
			INTO ccexcnt
			FROM OE_CREDIT_CHECK_RULES
			WHERE QUICK_CR_CHECK_FLAG = 'Y';

Line: 2448

			SELECT COUNT(fcr.REQUEST_ID)
			INTO creqcnt
			FROM FND_CONCURRENT_REQUESTS fcr, FND_CONCURRENT_PROGRAMS_TL fcp
			WHERE fcr.CONCURRENT_PROGRAM_ID=fcp.concurrent_program_id
			AND (( fcr.PHASE_CODE='P' AND fcr.STATUS_CODE='Q'
			OR  fcr.PHASE_CODE='P' AND fcr.STATUS_CODE='R' )
			OR  ( fcr.PHASE_CODE='R' AND fcr.STATUS_CODE='R' ))
			AND fcp.USER_CONCURRENT_PROGRAM_NAME like 'Initialize Credit Summaries Table'
			AND fcp.LANGUAGE = USERENV('LANG');

Line: 2483

			SELECT STATUS
			INTO arstatus
			FROM FND_PRODUCT_INSTALLATIONS
			WHERE APPLICATION_ID = 222;

Line: 2511

				SELECT MASTER_ORGANIZATION_ID
				INTO mstrorg
				FROM OE_SYSTEM_PARAMETERS_ALL
				WHERE ORG_ID = oulist(i);

Line: 2525

					SELECT COUNT(INVENTORY_ITEM_ID)
					INTO itmcnt
					FROM MTL_SYSTEM_ITEMS_B
					WHERE ORGANIZATION_ID = mstrorg
					AND MTL_TRANSACTIONS_ENABLED_FLAG = 'Y'
					AND CUSTOMER_ORDER_FLAG = 'Y'
					AND CUSTOMER_ORDER_ENABLED_FLAG = 'Y'
					AND RETURNABLE_FLAG = 'Y'
					AND INTERNAL_ORDER_FLAG = 'Y'
					AND INTERNAL_ORDER_ENABLED_FLAG = 'Y'
					AND SHIPPABLE_ITEM_FLAG = 'Y'
					AND INVOICEABLE_ITEM_FLAG = 'Y'
					AND RESERVABLE_TYPE = 1
					AND INVOICE_ENABLED_FLAG = 'Y';

Line: 2540

					SELECT COUNT(INVENTORY_ITEM_ID)
					INTO itmcnt
					FROM MTL_SYSTEM_ITEMS_B
					WHERE ORGANIZATION_ID = mstrorg
					AND MTL_TRANSACTIONS_ENABLED_FLAG = 'Y'
					AND CUSTOMER_ORDER_FLAG = 'Y'
					AND CUSTOMER_ORDER_ENABLED_FLAG = 'Y'
					AND RETURNABLE_FLAG = 'Y'
					AND INTERNAL_ORDER_FLAG = 'Y'
					AND INTERNAL_ORDER_ENABLED_FLAG = 'Y'
					AND SHIPPABLE_ITEM_FLAG = 'Y'
					AND RESERVABLE_TYPE = 1
					AND INVOICEABLE_ITEM_FLAG = 'Y';

Line: 2573

		SELECT COUNT(QLLV.LIST_HEADER_ID)
		INTO prclstct
		FROM QP_LIST_LINES_V QLLV, QP_LIST_HEADERS_B QLHB
		WHERE QLLV.LIST_HEADER_ID = QLHB.LIST_HEADER_ID
		/* Commented as it is not required.
		AND SYSDATE >= NVL(QLHB.START_DATE_ACTIVE, TO_DATE('01-JAN-1000','DD-MON-YYYY'))
		AND SYSDATE <  NVL(QLHB.END_DATE_ACTIVE, TO_DATE('31-DEC-2999'))
		*/
		AND QLLV.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE1'
		AND QLHB.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID
					    FROM QP_LIST_HEADERS_B);

Line: 2603

		SELECT COUNT(QUOTA_FLAG)
		INTO qcnt
		FROM OE_SALES_CREDIT_TYPES
		WHERE QUOTA_FLAG = 'Y';

Line: 2607

		SELECT COUNT(QUOTA_FLAG)
		INTO nqcnt
		FROM OE_SALES_CREDIT_TYPES
		WHERE QUOTA_FLAG IS NULL
		OR QUOTA_FLAG = 'N';

Line: 2666

				SELECT COUNT(ORGANIZATION_ID)
				INTO opencnt
				FROM ORG_ACCT_PERIODS_V
				WHERE ORGANIZATION_ID = shiporgs(j)
				AND STATUS = 'Open';

Line: 2671

				SELECT COUNT(ORGANIZATION_ID)
				INTO currcnt
				FROM ORG_ACCT_PERIODS_V
				WHERE ORGANIZATION_ID = shiporgs(j)
				AND SYSDATE >= START_DATE
				AND SYSDATE <  END_DATE
				AND STATUS = 'Open';

Line: 2735

			SELECT COUNT(FREIGHT_CODE_COMBINATION_ID)
			INTO shsecnt
			FROM MTL_INTERCOMPANY_PARAMETERS
			WHERE SHIP_ORGANIZATION_ID = oulist(i)
			OR SELL_ORGANIZATION_ID = oulist(i);

Line: 2741

				SELECT COUNT(FREIGHT_CODE_COMBINATION_ID)
				INTO shipcnt
				FROM MTL_INTERCOMPANY_PARAMETERS
				WHERE SHIP_ORGANIZATION_ID = oulist(i);

Line: 2749

					SELECT COUNT(ORGANIZATION_ID)
					INTO shorgscnt
					FROM WSH_SHIPPING_PARAMETERS
					WHERE ORGANIZATION_ID = shiporgs(j);

Line: 2766

					SELECT COUNT(ORGANIZATION_ID)
					INTO shorgscnt
					FROM WSH_SHIPPING_PARAMETERS
					WHERE ORGANIZATION_ID = shiporgs(j);

Line: 2782

					SELECT DEFAULT_STAGE_SUBINVENTORY
					INTO dftstgsub
					FROM WSH_SHIPPING_PARAMETERS
					WHERE ORGANIZATION_ID = shiporgs(j);

Line: 2803

				SELECT COUNT(SECONDARY_INVENTORY_NAME)
				INTO secinvcnt
				FROM MTL_SECONDARY_INVENTORIES_FK_V
				WHERE ORGANIZATION_ID = shiporgs(j);

Line: 2818

				SELECT COUNT(ORGANIZATION_ID)
				INTO pickcnt
				FROM WSH_SHIPPING_PARAMETERS
				WHERE ORGANIZATION_ID = shiporgs(j)
				AND PICK_SEQUENCE_RULE_ID IS NOT NULL
				AND PICK_GROUPING_RULE_ID IS NOT NULL;

Line: 2857

        SELECT 'x'
        INTO   dummy_v
        FROM   org_freight_vl
        WHERE  rownum = 1;

Line: 2870

		SELECT COUNT(FREIGHT_CODE)
		INTO activect
		FROM ORG_FREIGHT_VL;

Line: 2905

				SELECT COUNT(ORG_CARRIER_SERVICE_ID)
				INTO actorgct
				FROM WSH_ORG_CARRIER_SERVICES_V
				WHERE ENABLED_FLAG = 'Y'
				AND ORGANIZATION_ID = shiporgs(j);

Line: 2910

				SELECT COUNT(FREIGHT_CODE)
				INTO cashmect
				FROM WSH_CARRIER_SHIP_METHODS_V
				WHERE ENABLED_FLAG = 'Y'
				AND ORGANIZATION_ID = shiporgs(j);

Line: 2954

		SELECT COUNT(DOC_SEQUENCE_ID)
		INTO doccount
		FROM FND_DOCUMENT_SEQUENCES
		WHERE APPLICATION_ID = 665;

Line: 2964

		SELECT COUNT(wdsc.DOC_SEQUENCE_CATEGORY_ID)
		INTO   bolcount
		FROM  WSH_DOC_SEQUENCE_CATEGORIES wdsc
		     ,FND_DOC_SEQUENCE_CATEGORIES fdsc
		WHERE wdsc.CATEGORY_CODE = fdsc.CODE
		AND fdsc.NAME = 'BOL';

Line: 2976

		SELECT COUNT(wdsc.DOC_SEQUENCE_CATEGORY_ID)
		INTO   pkslpcnt
		FROM  WSH_DOC_SEQUENCE_CATEGORIES wdsc
		     ,FND_DOC_SEQUENCE_CATEGORIES fdsc
		WHERE wdsc.CATEGORY_CODE = fdsc.CODE
		AND fdsc.NAME = 'BOL';

Line: 3007

			SELECT COUNT(*)
			INTO omcnt
			FROM OE_SYS_PARAMETERS_ALL
			WHERE ORG_ID = oulist(i);

Line: 3013

					SELECT SET_OF_BOOKS_ID
					INTO sob
					FROM HR_OPERATING_UNITS
					WHERE ORGANIZATION_ID = oulist(i);

Line: 3021

				SELECT COUNT(fdsa.DOC_SEQUENCE_ASSIGNMENT_ID)
				INTO bolacnt
				FROM  FND_DOC_SEQUENCE_ASSIGNMENTS fdsa
				     ,FND_DOC_SEQUENCE_CATEGORIES fdsc
				WHERE SET_OF_BOOKS_ID = sob
				AND CATEGORY_CODE = fdsc.CODE
				AND fdsc.NAME = 'BOL';

Line: 3028

				SELECT COUNT(fdsa.DOC_SEQUENCE_ASSIGNMENT_ID)
				INTO pkslpacnt
				FROM  FND_DOC_SEQUENCE_ASSIGNMENTS fdsa
				     ,FND_DOC_SEQUENCE_CATEGORIES fdsc
				WHERE SET_OF_BOOKS_ID = sob
				AND CATEGORY_CODE = fdsc.CODE
				AND fdsc.NAME = 'PKSLP';

Line: 3061

		SELECT COUNT(ROLE_ID)
		INTO rolecnt
		FROM WSH_ROLES;

Line: 3073

				SELECT ROLE_ID
				INTO roleid
				FROM WSH_GRANTS
				WHERE USER_ID = USER_LIST(i)
				AND ROWNUM < 2;