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.

APPS.EAM_PARAMETERS_PUB SQL Statements

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

Line: 58


	INSERT into temp_isetup_api(msg,sr_no)
	VALUES (info,g_sr_no);

Line: 72


        SELECT count(*) INTO l_count
	FROM   WIP_EAM_PARAMETERS
	WHERE  organization_id = p_organization_id;

Line: 98


        SELECT count(*) INTO l_count
	FROM   mfg_lookups
	WHERE  lookup_type = P_LOOKUP_TYPE
	AND  lookup_code = P_LOOKUP_CODE;

Line: 122


        SELECT count(*) INTO l_count
	FROM   cst_eam_cost_elements
	WHERE  eam_cost_element_id = P_DEF_EAM_COST_ELEMENT_ID;

Line: 144


        SELECT count(*) INTO l_count
        from wip_accounting_classes
        where class_code = P_DEFAULT_EAM_CLASS
        and class_type = 6
        and organization_id = P_ORGANIZATION_ID;

Line: 170


	select chart_of_accounts_id into l_chart_of_accounts_id
	from gl_code_combinations
	where code_combination_id = P_MAINTENANCE_OFFSET_ACCOUNT;

Line: 174


	select count(*) into l_count
	from hr_organization_information hoi,
	gl_sets_of_books gsob
	where hoi.org_information_context = 'Accounting Information'
	and hoi.org_information1 = (gsob.set_of_books_id)
	and gsob.chart_of_accounts_id = l_chart_of_accounts_id
	and hoi.organization_id = P_ORGANIZATION_ID;

Line: 213


      select count(*) into l_count
      from mtl_parameters where
      organization_id = p_organization_id
      and NVL(eam_enabled_flag,'N') = 'Y';

Line: 260


        SELECT COUNT(*) INTO l_count
	FROM WIP_EAM_PARAMETERS
	WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 278


PROCEDURE insert_parameters
( 	p_api_version           	IN	NUMBER				,
  	p_init_msg_list			IN	VARCHAR2 := FND_API.G_FALSE	,
	p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE	,
	p_validation_level		IN  	NUMBER	 := FND_API.G_VALID_LEVEL_FULL	,

	x_return_status			OUT NOCOPY VARCHAR2		  	,
	x_msg_count			OUT NOCOPY NUMBER			,
	x_msg_data			OUT NOCOPY VARCHAR2			,

	P_ORGANIZATION_ID		IN	NUMBER		,
	P_WORK_REQUEST_AUTO_APPROVE	IN	VARCHAR2	default 'N',
	P_DEF_MAINT_COST_CATEGORY	IN	NUMBER		,
	P_DEF_EAM_COST_ELEMENT_ID	IN	NUMBER		,
	P_WORK_REQ_EXTENDED_LOG_FLAG	IN	VARCHAR2	default 'Y',
	P_DEFAULT_EAM_CLASS		IN	VARCHAR2  	,
	P_EASY_WORK_ORDER_PREFIX	IN	VARCHAR2	default null,
	P_WORK_ORDER_PREFIX		IN	VARCHAR2	default null,
	P_SERIAL_NUMBER_ENABLED		IN	VARCHAR2	default 'Y',
	P_AUTO_FIRM_FLAG		IN	VARCHAR2	default 'Y',
	P_MAINTENANCE_OFFSET_ACCOUNT	IN	NUMBER		default null,
	P_MATERIAL_ISSUE_BY_MO		IN	VARCHAR2	default 'Y',
	P_DEFAULT_DEPARTMENT_ID		IN	NUMBER		default null,
	P_INVOICE_BILLABLE_ITEMS_ONLY	IN	VARCHAR2	default 'N',
	P_OVERRIDE_BILL_AMOUNT		IN	VARCHAR2	default null,
	P_BILLING_BASIS			IN	NUMBER		default null,
	P_BILLING_METHOD		IN	NUMBER		default null,
	P_DYNAMIC_BILLING_ACTIVITY	IN	VARCHAR2	default null,
        P_DEFAULT_ASSET_FLAG     	IN	VARCHAR2	default 'Y' ,
	P_PM_IGNORE_MISSED_WO		IN 	VARCHAR2 	default 'N',
	p_issue_zero_cost_flag		IN 	varchar2	default 'Y',
	p_WORK_REQUEST_ASSET_NUM_REQD   IN	varchar2 	default 'Y',
	P_EAM_WO_WORKFLOW_ENABLED	IN	VARCHAR2	default null,
	P_AUTO_FIRM_ON_CREATE		IN	VARCHAR2	default null
)
IS
	l_api_name			CONSTANT VARCHAR2(30)	:= 'insert_parameters';

Line: 323


    SAVEPOINT	INSERT_PARAMETERS;

Line: 437


        INSERT INTO WIP_EAM_PARAMETERS
        (
		ORGANIZATION_ID	,
		WORK_REQUEST_AUTO_APPROVE	,
		DEF_MAINT_COST_CATEGORY	,
		DEF_EAM_COST_ELEMENT_ID	,
		WORK_REQ_EXTENDED_LOG_FLAG	,
		DEFAULT_EAM_CLASS	,
		EASY_WORK_ORDER_PREFIX	,
		WORK_ORDER_PREFIX	,
		SERIAL_NUMBER_ENABLED	,
		AUTO_FIRM_FLAG	,
		MAINTENANCE_OFFSET_ACCOUNT	,
		--WIP_EAM_REQUEST_TYPE	,
		MATERIAL_ISSUE_BY_MO	,
		DEFAULT_DEPARTMENT_ID	,
		INVOICE_BILLABLE_ITEMS_ONLY	,
		OVERRIDE_BILL_AMOUNT	,
		BILLING_BASIS	,
		BILLING_METHOD	,
		DYNAMIC_BILLING_ACTIVITY	,
		DEFAULT_ASSET_FLAG	,
		PM_IGNORE_MISSED_WO,
		issue_zero_cost_flag,
		WORK_REQUEST_ASSET_NUM_REQD,

		CREATED_BY           ,
		CREATION_DATE       ,
		LAST_UPDATE_LOGIN  ,
		LAST_UPDATE_DATE  ,
		LAST_UPDATED_BY,
		EAM_WO_WORKFLOW_ENABLED,
		AUTO_FIRM_ON_CREATE
	)
	VALUES
	(
		P_ORGANIZATION_ID	,
		P_WORK_REQUEST_AUTO_APPROVE	,
		P_DEF_MAINT_COST_CATEGORY	,
		P_DEF_EAM_COST_ELEMENT_ID	,
		P_WORK_REQ_EXTENDED_LOG_FLAG	,
		P_DEFAULT_EAM_CLASS	,
		P_EASY_WORK_ORDER_PREFIX	,
		P_WORK_ORDER_PREFIX	,
		P_SERIAL_NUMBER_ENABLED	,
		P_AUTO_FIRM_FLAG	,
		P_MAINTENANCE_OFFSET_ACCOUNT	,
		--P_WIP_EAM_REQUEST_TYPE	,
		P_MATERIAL_ISSUE_BY_MO	,
		P_DEFAULT_DEPARTMENT_ID	,
		P_INVOICE_BILLABLE_ITEMS_ONLY	,
		P_OVERRIDE_BILL_AMOUNT	,
		P_BILLING_BASIS	,
		P_BILLING_METHOD	,
		P_DYNAMIC_BILLING_ACTIVITY	,
		P_DEFAULT_ASSET_FLAG           ,
		P_PM_IGNORE_MISSED_WO,
		p_issue_zero_cost_flag,
		p_WORK_REQUEST_ASSET_NUM_REQD,
		fnd_global.user_id,
		sysdate,
		fnd_global.login_id,
		sysdate    ,
		fnd_global.user_id,
		P_EAM_WO_WORKFLOW_ENABLED,
		P_AUTO_FIRM_ON_CREATE
	);

Line: 517


		ROLLBACK TO INSERT_PARAMETERS;

Line: 524


		ROLLBACK TO INSERT_PARAMETERS;

Line: 531


		ROLLBACK TO INSERT_PARAMETERS;

Line: 545


END insert_parameters;

Line: 548


PROCEDURE update_parameters
( 	p_api_version           	IN	NUMBER				,
  	p_init_msg_list			IN	VARCHAR2 := FND_API.G_FALSE	,
	p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE	,
	p_validation_level		IN  	NUMBER	 := FND_API.G_VALID_LEVEL_FULL	,

	x_return_status			OUT NOCOPY VARCHAR2		  	,
	x_msg_count			OUT NOCOPY NUMBER				,
	x_msg_data			OUT NOCOPY VARCHAR2			,
	P_ORGANIZATION_ID		IN	NUMBER		,
	P_WORK_REQUEST_AUTO_APPROVE	IN	VARCHAR2	default 'N',
	P_DEF_MAINT_COST_CATEGORY	IN	NUMBER		,
	P_DEF_EAM_COST_ELEMENT_ID	IN	NUMBER		,
	P_WORK_REQ_EXTENDED_LOG_FLAG	IN	VARCHAR2	default 'Y',
	P_DEFAULT_EAM_CLASS		IN	VARCHAR2  	,
	P_EASY_WORK_ORDER_PREFIX	IN	VARCHAR2	default null,
	P_WORK_ORDER_PREFIX		IN	VARCHAR2	default null,
	P_SERIAL_NUMBER_ENABLED		IN	VARCHAR2	default 'Y',
	P_AUTO_FIRM_FLAG		IN	VARCHAR2	default 'Y',
	P_MAINTENANCE_OFFSET_ACCOUNT	IN	NUMBER		default null,
	P_MATERIAL_ISSUE_BY_MO		IN	VARCHAR2	default 'Y',
	P_DEFAULT_DEPARTMENT_ID		IN	NUMBER		default null,
	P_INVOICE_BILLABLE_ITEMS_ONLY	IN	VARCHAR2	default 'N',
	P_OVERRIDE_BILL_AMOUNT		IN	VARCHAR2	default null,
	P_BILLING_BASIS			IN	NUMBER		default null,
	P_BILLING_METHOD		IN	NUMBER		default null,
	P_DYNAMIC_BILLING_ACTIVITY	IN	VARCHAR2	default null,
        P_DEFAULT_ASSET_FLAG     	IN	VARCHAR2	default 'Y' ,
	P_PM_IGNORE_MISSED_WO		IN 	VARCHAR2 	default 'N',
	p_issue_zero_cost_flag		IN 	varchar2	default 'Y',
	p_WORK_REQUEST_ASSET_NUM_REQD	IN	varchar2	default 'Y',
	P_EAM_WO_WORKFLOW_ENABLED	IN	VARCHAR2	default null,
	P_AUTO_FIRM_ON_CREATE		IN	VARCHAR2	default null
)
IS
	l_api_name			CONSTANT VARCHAR2(30)	:= 'Update_parameters';

Line: 592


    SAVEPOINT	UPDATE_PARAMETERS;

Line: 685


        UPDATE WIP_EAM_PARAMETERS
        SET
--		ORGANIZATION_ID		=	P_ORGANIZATION_ID	,
		WORK_REQUEST_AUTO_APPROVE	=	P_WORK_REQUEST_AUTO_APPROVE	,
		DEF_MAINT_COST_CATEGORY	=	P_DEF_MAINT_COST_CATEGORY	,
		DEF_EAM_COST_ELEMENT_ID	=	P_DEF_EAM_COST_ELEMENT_ID	,
		WORK_REQ_EXTENDED_LOG_FLAG      =	P_WORK_REQ_EXTENDED_LOG_FLAG	,
		DEFAULT_EAM_CLASS	=	P_DEFAULT_EAM_CLASS	,
		EASY_WORK_ORDER_PREFIX	=	P_EASY_WORK_ORDER_PREFIX	,
		WORK_ORDER_PREFIX	=	P_WORK_ORDER_PREFIX	,
		SERIAL_NUMBER_ENABLED	=	P_SERIAL_NUMBER_ENABLED	,
		AUTO_FIRM_FLAG		=	P_AUTO_FIRM_FLAG	,
		MAINTENANCE_OFFSET_ACCOUNT	=	P_MAINTENANCE_OFFSET_ACCOUNT	,
		--WIP_EAM_REQUEST_TYPE	=	P_WIP_EAM_REQUEST_TYPE	,
		MATERIAL_ISSUE_BY_MO	=	P_MATERIAL_ISSUE_BY_MO	,
		DEFAULT_DEPARTMENT_ID	=	P_DEFAULT_DEPARTMENT_ID	,
		INVOICE_BILLABLE_ITEMS_ONLY	=	P_INVOICE_BILLABLE_ITEMS_ONLY	,
		OVERRIDE_BILL_AMOUNT	=	P_OVERRIDE_BILL_AMOUNT	,
		BILLING_BASIS		=	P_BILLING_BASIS	,
		BILLING_METHOD		=	P_BILLING_METHOD	,
		DYNAMIC_BILLING_ACTIVITY=	P_DYNAMIC_BILLING_ACTIVITY	,
		DEFAULT_ASSET_FLAG    	= 	P_DEFAULT_ASSET_FLAG	,
		PM_IGNORE_MISSED_WO 	= 	p_pm_ignore_missed_wo,
		issue_zero_cost_flag	=	p_issue_zero_cost_flag,
		WORK_REQUEST_ASSET_NUM_REQD =	p_WORK_REQUEST_ASSET_NUM_REQD,

		LAST_UPDATE_LOGIN	=	fnd_global.login_id	,
		LAST_UPDATE_DATE	=	sysdate	,
		LAST_UPDATED_BY		=	fnd_global.user_id,
		EAM_WO_WORKFLOW_ENABLED	=	P_EAM_WO_WORKFLOW_ENABLED,
		AUTO_FIRM_ON_CREATE	=	P_AUTO_FIRM_ON_CREATE

	WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 731


		ROLLBACK TO UPDATE_PARAMETERS;

Line: 738


		ROLLBACK TO UPDATE_PARAMETERS;

Line: 745


		ROLLBACK TO UPDATE_PARAMETERS;

Line: 759


END update_parameters;