APPS.PO_COMPARE_REVISIONS SQL Statements

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

Line: 9

 * Delete records from the temp table, ICX_PO_REVISIONS_TEMP, where
 * all the records for differences are stored.
 *
 * ARGUMENTS
 * p_date	Purges all records that are older than this date.  The
 *		date defaults to two hours back from the current date.
 *
 * NOTES
 * You need to set-up a concurrent program in Oracle Applications to
 * call this program in a specific frequency.
 *
 * HISTORY
 * 10-SEP-97	Rami Haddad	Created
 * 20-OCT-97	Winston Lang	Added errbuf and retcode parameters.
 ********************************************************************/
PROCEDURE purge(
	errbuf OUT NOCOPY VARCHAR2,
	retcode OUT NOCOPY NUMBER,
	p_date IN VARCHAR2
	) AS
v_progress	VARCHAR2(3);

Line: 38

DELETE	icx_po_revisions_temp
WHERE creation_date < NVL( to_date(p_date, 'YYYY/MM/DD HH24:MI:SS'),SYSDATE - 1/12 );

Line: 83

SELECT	un_number
INTO	v_un_number
FROM	po_un_numbers
WHERE	un_number_id = p_un_number_id;

Line: 134

SELECT	icx_util.item_flex_seg( msi.rowid )
INTO	v_item_num
FROM
	mtl_system_items msi,
	financials_system_parameters fsp
WHERE
	p_item_id = msi.inventory_item_id (+)
AND	fsp.inventory_organization_id = NVL(
		msi.organization_id,
		fsp.inventory_organization_id );

Line: 189

SELECT	hazard_class
INTO	v_hazard_class
FROM	po_hazard_classes
WHERE	hazard_class_id = p_hazard_class_id;

Line: 238

SELECT	description
INTO	v_ap_terms
FROM	ap_terms
WHERE	term_id = p_term_id;

Line: 290

SELECT	distinct full_name
INTO	v_full_name
FROM	per_people_f
WHERE	person_id = p_agent_id
and  TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE ;

Line: 342

SELECT	DECODE(last_name, NULL, NULL, last_name || ',' || first_name)
INTO	v_full_name
FROM	po_vendor_contacts
WHERE	vendor_contact_id = p_vendor_contact_id;

Line: 391

SELECT	location_code
INTO	v_location_code
FROM	hr_locations
WHERE	location_id = p_location_id;

Line: 439

SELECT	segment1
INTO	v_po_num
FROM	po_headers
WHERE	po_header_id = p_header_id;

Line: 486

SELECT	line_num
INTO	v_line_num
FROM	po_lines
WHERE	po_line_id = p_line_id;

Line: 535

SELECT	description
INTO	v_description
FROM	po_lookup_codes
WHERE
	lookup_type = p_lookup_type
AND	lookup_code = p_lookup_code;

Line: 583

SELECT  vendor_site_code
INTO    v_site_code
FROM    po_vendor_sites_all
WHERE   vendor_site_id = p_vendor_site_id;

Line: 606

 * insert_changes
 *
 * PURPOSE
 * Insert the comparison result into the temp table.
 *
 * ARGUMENTS
 * p_line_seq		Sequence number to identify the comparison
 *			results for a specific record.
 * p_header_id		Unique identifier for PO.
 * p_release_id		Unique identifier for PO release.
 * p_line_id		Unique identifier for PO line.
 * p_location_id	Unique identifier for PO line location.
 * p_distribution_id	Unique identifier for PO distribution.
 * p_item_id		Unique identified for line item.
 * p_po_num		PO number.
 * p_line_num		PO line number.
 * p_location_num	PO line location number.
 * p_distribution_num	PO distribution number.
 * p_level_altered	Level altered.  Possible values are:
 *
 *	Code			User-friendly name
 *	----			------------------
 *	ICX_DISTRIBUTION	Distribution
 *	ICX_HEADER		Header
 *	ICX_LINE		Line
 *	ICX_SHIPMENT		Shipment
 *
 * p_field_altered	Field altered.  Possible values are:
 *
 *	Code			User-friendly name
 *	----			------------------
 *	ICX_ACCEPTANCE_DUE_DATE	Acceptance Due Date
 *	ICX_ACCEPTANCE_REQUIRED	Acceptance Required
 *	ICX_AMOUNT		Amount
 *	ICX_AMOUNT_AGREED	Amount Agreed
 *	ICX_AMOUNT_DUE_DATE	Amount Due Date
 *	ICX_AMOUNT_LIMIT	Amount Limit
 *	ICX_BILL_TO		Bill To
 *	ICX_BUYER		Buyer
 *	ICX_CANCELLED		Cancelled
 *	ICX_CHARGE_ACCT		Charge Account
 *	ICX_CLOSED_CODE		Closed
 *	ICX_CONFIRMED		Confirm
 *	ICX_CONTRACT_NUMBER	Contract Number
 *	ICX_EFFECTIVE_DATE	Effective Date
 *	ICX_ERROR		Error
 *	ICX_EXPIRATION_DATE	Expiration Date
 *	ICX_FOB			FOB
 *	ICX_FREIGHT_TERMS	Freight Terms
 *	ICX_HAZARD_CLASS	Hazard Class
 *	ICX_ITEM		Item
 *	ICX_ITEM_DESCRIPTION	Item Description
 *	ICX_ITEM_REVISION	Item Revision
 *	ICX_LAST_ACCEPT_DATE	Last Acceptance Date
 *	ICX_LINE_NUMBER		Line Number
 *	ICX_NEED_BY_DATE	Need By Date
 *	ICX_NEW			New
 *	ICX_NOTE_TO_VENDOR	Note To Vendor
 *	ICX_PAYMENT_TERMS	Payment Terms
 *	ICX_PRICE_BREAK		Price Break
 *	ICX_PRICE_TYPE		Price Type
 *	ICX_PROMISED_DATE	Promised Date
 *	ICX_QUANTITY		Quantity
 *	ICX_QUANTITY_AGREED	Quantity Agreed
 *	ICX_RELEASE_DATE	Released Date
 *	ICX_RELEASE_NUMBER	Release Number
 *	ICX_REQUESTOR		Requestor
 *	ICX_SHIP_NUM		Shipment Number
 *	ICX_SHIP_TO		Ship To
 *	ICX_SHIP_VIA		Ship Via
 *	ICX_SOURCE_QT_HEADER	Source Quotation Header
 *	ICX_SOURCE_QT_LINE	Source Quotation Line
 *	ICX_SUPPLIER_CONTACT	Supplier Contact
 *	ICX_SUPPLIER_ITEM_NUM	Supplier Item Number
 *	ICX_TAXABLE_FLAG	Taxable
 *	ICX_UNIT_PRICE		Unit Price
 *	ICX_UN_NUMBER		UN Number
 *	ICX_UOM			UOM
 *
 * p_changes_from	Previous value of field altered.
 * p_changes_to		New value of field altered.
 *
 * NOTES
 * Stamps every line with the current system date.  Use that value
 * when purging the table, to remove 2-hours old records for example.
 *
 * Replace IDs that are NULL with -99, to do the sorting correctly.
 * When sorting in an ascending order, NULL values are at the last,
 * while, to sort these records correctly, they should be the first.
 *
 * HISTORY
 * 08-AUG-97	Nilo Paredes	Created
 * 22-SEP-97	Rami Haddad	Removed prompts look-up in AK.
 *				Replace NULL with -99 for sorting.
 ********************************************************************/
PROCEDURE insert_changes(
	p_line_seq IN NUMBER,
	p_header_id IN NUMBER,
	p_release_id IN NUMBER,
	p_line_id IN NUMBER,
	p_location_id IN NUMBER,
	p_distribution_id IN NUMBER,
	p_item_id IN NUMBER,
	p_po_num IN VARCHAR2,
	p_revision_num IN NUMBER,
	p_line_num IN NUMBER,
	p_location_num IN NUMBER,
	p_distribution_num IN NUMBER,
	p_level_altered IN VARCHAR2,
	p_field_altered IN VARCHAR2,
	p_changes_from IN VARCHAR2,
	p_changes_to IN VARCHAR2
	) AS

v_progress	VARCHAR2(3);

Line: 726

INSERT INTO
	icx_po_revisions_temp(
	line_seq,
	creation_date,
	header_id,
	release_id,
	line_id,
	location_id,
	distribution_id,
	item_id,
	po_num,
	revision_num,
	line_num,
	location_num,
	distribution_num,
	level_altered,
	field_altered,
	changes_from,
	changes_to
	)
VALUES
	(
	p_line_seq,
	SYSDATE,
	p_header_id,
	p_release_id,
	p_line_id,
	p_location_id,
	p_distribution_id,
	p_item_id,
	p_po_num,
	p_revision_num,
	p_line_num,
	p_location_num,
	p_distribution_num,
	p_level_altered,
	p_field_altered,
	p_changes_from,
	p_changes_to
	);

Line: 772

		'PO_COMPARE_REVISIONS.INSERT_CHANGES',
		v_progress,
		sqlcode );

Line: 777

END insert_changes;

Line: 786

 * Insert a line in the ICX_PO_REVISIONS_TEMP table indicating that
 * there are no differences between the compared records.
 *
 * ARGUMENTS
 * p_line_seq		Sequence number to identify the comparison
 *			results for a specific record.
 *
 * NOTES
 * Refer to bug#549414 for more details.
 *
 * This is used specifically to handle AK functionality.  AK is
 * expecting a row in table with the PK.  The initial table in this
 * case is actually a procedure, so AK fails.  The procedure checks.
 * If there are no differences, insert a dummy row in the table that
 * say something like 'No differences.'
 *
 * HISTORY
 * 31-OCT-97	Rami Haddad	Created
 ********************************************************************/
PROCEDURE verify_no_differences( p_line_seq IN NUMBER ) AS

records_exist	number;

Line: 814

SELECT	COUNT(*)
INTO	records_exist
FROM	icx_po_revisions_temp
WHERE	line_seq = p_line_seq;

Line: 820

	insert_changes(
		p_line_seq,
		-99,
		NULL,
		NULL,
		NULL,
		NULL,
		NULL,
		NULL,
		0,	-- -99
		NULL,
		NULL,
		NULL,
		'ICX_HEADER',
		--fnd_message.get_String('PO', 'POS_NO_DIFFERENCE'),
                'ICX_NO_DIFFERENCE',
		NULL,
		NULL
		);

Line: 905

 * Constant variables to pass for insert_changes
 */
c_level_altered		icx_po_revisions_temp.level_altered%TYPE
			:= 'ICX_HEADER';

Line: 947

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_ERROR'),
                'ICX_ERROR',
		NULL,
		NULL
		);

Line: 988

		insert_changes(
			p_sequence,
			c_po_header_id,
			c_release_id,
			c_line_id,
			c_location_id,
			c_distribution_id,
			c_item_id,
			c_po_num,
			c_revision_num,
			c_line_num,
			c_location_num,
			c_distribution_num,
			c_level_altered,
			--fnd_message.get_string('PO', 'POS_CANCELLED'),
                        'ICX_CANCELLED',
			NULL,
			NULL
			);

Line: 1018

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_BUYER'),
                'ICX_BUYER',
		get_buyer( p_po_from.agent_id ),
		get_buyer( p_po_to.agent_id )
		);

Line: 1044

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_SUPPLIER_CONTACT'),
                'ICX_SUPPLIER_CONTACT',
		get_vendor_contact( p_po_from.vendor_contact_id ),
		get_vendor_contact( p_po_to.vendor_contact_id )
		);

Line: 1070

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_CONFIRMED'),
                'ICX_CONFIRMED',
		p_po_from.confirming_order_flag,
		p_po_to.confirming_order_flag
		);

Line: 1096

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_SHIP_TO'),
                'ICX_SHIP_TO',
		get_location( p_po_from.ship_to_location_id ),
		get_location( p_po_to.ship_to_location_id )
		);

Line: 1122

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_BILL_TO'),
                'ICX_BILL_TO',
		get_location( p_po_from.bill_to_location_id ),
		get_location( p_po_to.bill_to_location_id )
		);

Line: 1147

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_PAYMENT_TERMS'),
                'ICX_PAYMENT_TERMS',
		get_ap_terms( p_po_from.terms_id ),
		get_ap_terms( p_po_to.terms_id )
		);

Line: 1179

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_AMOUNT'),
                'ICX_AMOUNT',
		v_amount_from,
		v_amount_to
		);

Line: 1205

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_SHIP_VIA'),
                'ICX_SHIP_VIA',
		p_po_from.ship_via_lookup_code,
		p_po_to.ship_via_lookup_code
		);

Line: 1231

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_FOB'),
                'ICX_FOB',
		get_po_lookup( 'FOB', p_po_from.fob_lookup_code ),
		get_po_lookup( 'FOB', p_po_to.fob_lookup_code )
		);

Line: 1257

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_FREIGHT_TERMS'),
                'ICX_FREIGHT_TERMS',
		get_po_lookup(
			'FREIGHT TERMS',
			p_po_from.freight_terms_lookup_code ),
		get_po_lookup(
			'FREIGHT TERMS',
			p_po_to.freight_terms_lookup_code )
		);

Line: 1287

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_NOTE_TO_VENDOR'),
                'ICX_NOTE_TO_VENDOR',
		p_po_from.note_to_vendor,
		p_po_to.note_to_vendor
		);

Line: 1313

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_ACCEPTANCE_REQUIRED'),
                'ICX_ACCEPTANCE_REQUIRED',
		p_po_from.acceptance_required_flag,
		p_po_to.acceptance_required_flag
		);

Line: 1341

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
                'ICX_ACCEPTANCE_DUE_DATE',
		       to_char(p_po_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
		       to_char(p_po_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
		       );

Line: 1367

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_AMOUNT_LIMIT'),
                'ICX_AMOUNT_LIMIT',
		p_po_from.amount_limit,
		p_po_to.amount_limit
		);

Line: 1395

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_EFFECTIVE_DATE'),
                'ICX_EFFECTIVE_DATE',
          to_char(p_po_from.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
           to_char(p_po_to.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
		);

Line: 1423

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
 		 'ICX_EXPIRATION_DATE',
		 to_char(p_po_from.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
           to_char(p_po_to.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
		);

Line: 1449

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_AMOUNT_AGREED'),
		 'ICX_AMOUNT_AGREED',
		p_po_from.blanket_total_amount,
		p_po_to.blanket_total_amount
		);

Line: 1474

        insert_changes(
                p_sequence,
                c_po_header_id,
                c_release_id,
                c_line_id,
                c_location_id,
                c_distribution_id,
                c_item_id,
                c_po_num,
                c_revision_num,
                c_line_num,
                c_location_num,
                c_distribution_num,
                c_level_altered,
                'ICX_VENDOR_SITE',
                get_vendor_site(p_po_from.vendor_site_id),
                get_vendor_site(p_po_to.vendor_site_id)
                );

Line: 1547

 * Constant variables to pass for insert_changes
 */
c_level_altered		icx_po_revisions_temp.level_altered%TYPE
			:= 'ICX_HEADER';

Line: 1582

SELECT	segment1
INTO	v_po_num
FROM	po_headers_archive
WHERE
	po_header_id = p_release_to.po_header_id
AND	latest_external_flag = 'Y';

Line: 1601

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_NEW'),
		 'ICX_NEW',
		NULL,
		NULL
		);

Line: 1650

		insert_changes(
			p_sequence,
			c_po_header_id,
			c_release_id,
			c_line_id,
			c_location_id,
			c_distribution_id,
			c_item_id,
			c_po_num,
			c_revision_num,
			c_line_num,
			c_location_num,
			c_distribution_num,
			c_level_altered,
			--fnd_message.get_string('PO', 'POS_CANCELLED'),
			'ICX_CANCELLED',
			NULL,
			NULL
			);

Line: 1677

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_BUYER'),
		 'ICX_BUYER',
		get_buyer( p_release_from.agent_id ),
		get_buyer( p_release_to.agent_id )
		);

Line: 1705

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
		'ICX_ACCEPTANCE_DUE_DATE',
		 to_char(p_release_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
           to_char(p_release_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
		);

Line: 1731

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_ACCEPTANCE_REQUIRED'),
		 'ICX_ACCEPTANCE_REQUIRED',
		p_release_from.acceptance_required_flag,
		p_release_to.acceptance_required_flag
		);

Line: 1757

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_revision_num,
		c_po_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_RELEASE_NUMBER'),
		 'ICX_RELEASE_NUMBER',
		p_release_from.release_num,
		p_release_to.release_num
		);

Line: 1785

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_RELEASE_DATE'),
		 'ICX_RELEASE_DATE',
		to_char(p_release_from.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
           to_char(p_release_to.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
		);

Line: 1876

 * Constant variables to pass for insert_changes
 */
c_level_altered		icx_po_revisions_temp.level_altered%TYPE
			:= 'ICX_LINE';

Line: 1918

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_NEW'),
		'ICX_NEW',
		NULL,
		NULL
		);

Line: 1970

		insert_changes(
			p_sequence,
			c_po_header_id,
			c_release_id,
			c_line_id,
			c_location_id,
			c_distribution_id,
			c_item_id,
			c_po_num,
			c_revision_num,
			c_line_num,
			c_location_num,
			c_distribution_num,
			c_level_altered,
			--fnd_message.get_string('PO', 'POS_CANCELLED'),
			 'ICX_CANCELLED',
			NULL,
			NULL
			);

Line: 2003

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_UNIT_PRICE'),
		 'ICX_UNIT_PRICE',
		p_line_from.unit_price,
		p_line_to.unit_price
		);

Line: 2029

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_LINE_NUMBER'),
		 'ICX_LINE_NUMBER',
		p_line_from.line_num,
		p_line_to.line_num
		);

Line: 2055

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_ITEM'),
		 'ICX_ITEM',
		get_item_number( p_line_from.item_id ),
		get_item_number( p_line_to.item_id )
		);

Line: 2081

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_ITEM_REVISION'),
		 'ICX_ITEM_REVISION',
		p_line_from.item_revision,
		p_line_to.item_revision
		);

Line: 2107

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_ITEM_DESCRIPTION'),
		 'ICX_ITEM_DESCRIPTION',
		p_line_from.item_description,
		p_line_to.item_description
		);

Line: 2133

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_QUANTITY'),
		 'ICX_QUANTITY',
		p_line_from.quantity,
		p_line_to.quantity
		);

Line: 2159

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_UOM'),
		 'ICX_UOM',
		p_line_from.unit_meas_lookup_code,
		p_line_to.unit_meas_lookup_code
		);

Line: 2185

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_SOURCE_QT_HEADER'),
		 'ICX_SOURCE_QT_HEADER',
		get_source_quotation_header(
			p_line_from.from_header_id ),
		get_source_quotation_header(
			p_line_to.from_header_id )

		);

Line: 2214

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_SOURCE_QT_LINE'),
		 'ICX_SOURCE_QT_LINE',
		get_source_quotation_line(
			p_line_from.from_line_id ),
		get_source_quotation_line(
			p_line_to.from_line_id )

		);

Line: 2243

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_HAZARD_CLASS'),
		 'ICX_HAZARD_CLASS',
		get_hazard_class( p_line_from.hazard_class_id ),
		get_hazard_class( p_line_to.hazard_class_id )
		);

Line: 2269

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_CONTRACT_NUMBER'),
		 'ICX_CONTRACT_NUMBER',
		p_line_from.contract_num,
		p_line_to.contract_num
		);

Line: 2295

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_SUPPLIER_ITEM_NUM'),
		 'ICX_SUPPLIER_ITEM_NUM',
		p_line_from.vendor_product_num,
		p_line_to.vendor_product_num
		);

Line: 2321

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_NOTE_TO_VENDOR'),
		 'ICX_NOTE_TO_VENDOR',
		p_line_from.note_to_vendor,
		p_line_to.note_to_vendor
		);

Line: 2347

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_UN_NUMBER'),
		 'ICX_UN_NUMBER',
		get_un_number( p_line_from.un_number_id ),
		get_un_number( p_line_to.un_number_id )
		);

Line: 2373

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_PRICE_TYPE'),
		 'ICX_PRICE_TYPE',
		get_po_lookup(
			'PRICE TYPE',
			p_line_from.price_type_lookup_code ),
		get_po_lookup(
			'PRICE TYPE',
			 p_line_to.price_type_lookup_code )
		);

Line: 2413

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_QUANTITY_AGREED'),
		 'ICX_QUANTITY_AGREED',
		p_line_from.quantity_committed,
		p_line_to.quantity_committed
		);

Line: 2448

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_AMOUNT_AGREED'),
		 'ICX_AMOUNT_AGREED',
		p_line_from.committed_amount,
		p_line_to.committed_amount
		);

Line: 2472

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_CLOSED_CODE'),
		 'ICX_CLOSED_CODE',
		get_po_lookup( 'DOCUMENT STATE',
			p_line_from.committed_amount ),
		get_po_lookup( 'DOCUMENT STATE',
			p_line_to.committed_amount )
		);

Line: 2500

        insert_changes(
                p_sequence,
                c_po_header_id,
                c_release_id,
                c_line_id,
                c_location_id,
                c_distribution_id,
                c_item_id,
                c_po_num,
                c_revision_num,
                c_line_num,
                c_location_num,
                c_distribution_num,
                c_level_altered,
                --fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
                'ICX_EXPIRATION_DATE',
                 to_char(p_line_from.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
           to_char(p_line_to.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
                );

Line: 2577

/* Constant variables to pass for insert_changes */
c_level_altered		icx_po_revisions_temp.level_altered%TYPE
			:= 'ICX_SHIPMENT';

Line: 2615

select line_num, item_id
into c_line_num, c_item_id
from po_lines_all
where po_line_id =  p_loc_to.po_line_id;

Line: 2624

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_NEW'),
		 'ICX_NEW',
		NULL,
		NULL
		);

Line: 2670

		insert_changes(
			p_sequence,
			c_po_header_id,
			c_release_id,
			c_line_id,
			c_location_id,
			c_distribution_id,
			c_item_id,
			c_po_num,
			c_revision_num,
			c_line_num,
			c_location_num,
			c_distribution_num,
			c_level_altered,
			--fnd_message.get_string('PO', 'POS_CANCELLED'),
			 'ICX_CANCELLED',
			NULL,
			NULL
			);

Line: 2703

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_SHIP_NUM'),
		 'ICX_SHIP_NUM',
		p_loc_from.shipment_num,
		p_loc_to.shipment_num
		);

Line: 2729

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_SHIP_TO'),
		 'ICX_SHIP_TO',
		get_location( p_loc_from.ship_to_location_id ),
		get_location( p_loc_to.ship_to_location_id )
		);

Line: 2755

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_QUANTITY'),
		 'ICX_QUANTITY',
		p_loc_from.quantity,
		p_loc_to.quantity
		);

Line: 2783

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_PROMISED_DATE'),
		 'ICX_PROMISED_DATE',
		       to_char(p_loc_from.promised_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
		       to_char(p_loc_to.promised_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))

		);

Line: 2812

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_NEED_BY_DATE'),
		 'ICX_NEED_BY_DATE',
      to_char(p_loc_from.need_by_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
		to_char(p_loc_to.need_by_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
		);

Line: 2840

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		p_loc_from.revision_num || '-' || p_loc_to.revision_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_LAST_ACCEPT_DATE'),
		 'ICX_LAST_ACCEPT_DATE',
		       to_char(p_loc_from.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
		       to_char(p_loc_to.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
		);

Line: 2866

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_TAXABLE_FLAG'),
		 'ICX_TAXABLE_FLAG',
		get_po_lookup(
			'YES/NO',
			p_loc_from.taxable_flag ),
		get_po_lookup(
			'YES/NO',
			p_loc_to.taxable_flag )
		);

Line: 2897

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_PRICE_BREAK'),
		 'ICX_PRICE_BREAK',
		p_loc_from.price_override,
		p_loc_to.price_override
		);

Line: 2971

 * Constant variables to pass for insert_changes
 */
c_level_altered		icx_po_revisions_temp.level_altered%TYPE
			:= 'ICX_DISTRIBUTION';

Line: 3014

select line_num
into c_line_num
from po_lines_all
where po_line_id =  p_dist_to.po_line_id;

Line: 3021

select shipment_num
into c_location_num
from po_line_locations_all
where line_location_id =  p_dist_to.line_location_id;

Line: 3031

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_NEW'),
		 'ICX_NEW',
		NULL,
		NULL
		);

Line: 3075

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_QUANTITY'),
		 'ICX_QUANTITY',
		p_dist_from.quantity_ordered,
		p_dist_to.quantity_ordered
		);

Line: 3101

	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_REQUESTOR'),
		 'ICX_REQUESTOR',
		p_dist_from.deliver_to_person_id,
		p_dist_to.deliver_to_person_id
		);

Line: 3127

   inserting the associated charge account instead of the
   ccid by using the function get_charge_account.
*/

IF NVL( p_dist_from.code_combination_id, -99 ) <>
	NVL( p_dist_to.code_combination_id, -99 ) THEN
	insert_changes(
		p_sequence,
		c_po_header_id,
		c_release_id,
		c_line_id,
		c_location_id,
		c_distribution_id,
		c_item_id,
		c_po_num,
		c_revision_num,
		c_line_num,
		c_location_num,
		c_distribution_num,
		c_level_altered,
		--fnd_message.get_String('PO', 'POS_CHARGE_ACCT'),
		 'ICX_CHARGE_ACCT',
		get_charge_account(p_dist_from.code_combination_id),
		get_charge_account(p_dist_to.code_combination_id)
		);

Line: 3197

SELECT  concatenated_segments
INTO    v_charge_account
FROM    gl_code_combinations_kfv
WHERE   code_combination_id = p_code_combination_id;