APPS.AHL_MC_APPROVALS_PVT SQL Statements

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

Line: 7

	SELECT 	mc_header_id, name
	FROM 	ahl_mc_headers_b
	WHERE 	mc_header_id = p_mc_header_id and
	  	object_version_number = nvl(p_object_version_number, object_version_number);

Line: 1546

PROCEDURE UPDATE_STATUS
(
	 itemtype    IN       VARCHAR2
	,itemkey     IN       VARCHAR2
	,actid       IN       NUMBER
	,funcmode    IN       VARCHAR2
	,resultout   OUT    NOCOPY  VARCHAR2
)
IS

	l_error_msg                	VARCHAR2(4000);

Line: 1573

			'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS.begin',
			'At the start of PLSQL procedure'
		);

Line: 1587

			,aname    => 'UPDATE_GEN_STATUS'
		);

Line: 1609

				'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
				'UPDATE_GEN_STATUS='||l_next_status||' -- OBJECT_VER='||l_object_version_number|| ' -- OBJECT_ID='||l_object_id
			);

Line: 1628

					'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
					false
				);

Line: 1636

		UPDATE ahl_mc_headers_b
		SET 	config_status_code = l_next_status,
			object_version_number = l_object_version_number + 1,
			last_update_date = sysdate,
			last_updated_by = to_number(fnd_global.login_id),
			last_update_login = to_number(fnd_global.login_id)
		WHERE mc_header_id = l_object_id;

Line: 1649

				'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
				'Successfully completed the MC with mc_header_id='||l_object_id
			);

Line: 1681

			'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS.end',
			'At the end of PLSQL procedure'
		);

Line: 1715

			'UPDATE_STATUS',
			itemtype,
			itemkey,
			actid,
			funcmode,
			l_error_msg
		);

Line: 1727

			'UPDATE_STATUS',
			itemtype,
			itemkey,
			actid,
			funcmode,
			l_error_msg
		);

Line: 1736

END UPDATE_STATUS;

Line: 1801

				'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
				'ORG_STATUS_ID='||l_next_status||' -- OBJECT_VER='||l_object_version_number|| ' -- OBJECT_ID='||l_object_id
			);

Line: 1828

		UPDATE ahl_mc_headers_b
		SET 	config_status_code = l_next_status,
			object_version_number = l_object_version_number + 1,
			last_update_date = sysdate,
			last_updated_by = to_number(fnd_global.login_id),
			last_update_login = to_number(fnd_global.login_id)
		WHERE mc_header_id = l_object_id;

Line: 1841

				'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
				'Successfully reverted status of the MC with mc_header_id='||l_object_id
			);