APPS.IGI_SIA SQL Statements

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

Line: 5

PROCEDURE insert_sec_hold
	( p_InvoiceId NUMBER
	, p_LastUpdatedBy NUMBER
	) IS
v_org_id number(15,0);

Line: 15

   select org_id
   into v_org_id
   from ap_invoices
   where invoice_id = p_InvoiceId;

Line: 25

	INSERT INTO AP_HOLDS
		( INVOICE_ID
		, HOLD_LOOKUP_CODE
		, LAST_UPDATE_DATE
		, LAST_UPDATED_BY
		, HELD_BY
		, HOLD_DATE
		, HOLD_REASON
		, CREATION_DATE
		, CREATED_BY
                , HOLD_ID   /* added for bug # 5905278 R12 Uptake of SIA */
		, ORG_ID   /* added for bug # 5905278 R12 Uptake of SIA */
                )
	SELECT
		p_InvoiceId
		, 'AWAIT_SEC_APP'
		, sysdate
		, p_LastUpdatedBy
		, p_LastUpdatedBy
		, sysdate
                , p_return_message
		, sysdate
		, p_LastUpdatedBy
                , AP_HOLDS_S.nextval   /* added for bug # 5905278 R12 Uptake of SIA */
                , v_org_id       /* added for bug # 5905278 R12 Uptake of SIA */
	FROM sys.dual
	WHERE NOT EXISTS ( SELECT 1
			   FROM ap_holds_all
			   WHERE invoice_id = p_InvoiceId
			   AND hold_lookup_code in ( 'AWAIT_SEC_APP',
                                                     'AWAIT_PAY_APP')
                           AND release_lookup_code is NULL
			 );

Line: 65

	, p_LastUpdatedBy 	NUMBER
	) IS
--
BEGIN

	UPDATE AP_HOLDS
	SET	  RELEASE_LOOKUP_CODE = 'MOD_RELEASE'
		, RELEASE_REASON = 	'Invoice Modified'
		, LAST_UPDATE_DATE =	sysdate
		, LAST_UPDATED_BY =	p_LastUpdatedBy
		WHERE 	invoice_id = p_InvoiceId
		AND	hold_lookup_code IN
			('AWAIT_SEC_APP', 'AWAIT_PAY_APP')
		AND	release_lookup_code is null;

Line: 91

	l_UpdatedByTable(l_TableRow)	:=	p_upd_by;

Line: 109

  Select 1
  From   AP_INVOICE_DISTRIBUTIONS_ALL
  Where  Invoice_id = p_inv_id
  AND    NVL(match_status_flag,'N') <> 'A';

Line: 115

  Select hold_lookup_code
  From   AP_HOLDS
  Where  invoice_id = p_inv_id
  And    hold_lookup_code = p_hold
  And    release_lookup_code is null;

Line: 122

  Select sum(nvl(amount,0))
  From   AP_INVOICE_DISTRIBUTIONS_ALL
  Where  Invoice_id = p_inv_id;

Line: 127

  Select hold_lookup_code
  From   AP_HOLDS
  Where  invoice_id = p_inv_id
  And    hold_lookup_code = 'AWAIT_PAY_APP';

Line: 133

  Select COUNT(1)
  From   AP_INVOICE_DISTRIBUTIONS_ALL
  Where  Invoice_id = p_inv_id
  and reversal_flag = 'Y';

Line: 144

  Select COUNT(1)
  From   AP_HOLDS
  Where  invoice_id = p_inv_id
  And    hold_lookup_code <> 'AWAIT_SEC_APP'
  And    Release_Lookup_code is Null;

Line: 225

            insert_sec_hold(p_inv_id,p_upd_by);

Line: 229

                insert_sec_hold(p_inv_id,p_upd_by);

Line: 251

           insert_sec_hold(p_inv_id,p_upd_by);

Line: 270

  Select hold_lookup_code
  From   AP_HOLDS
  Where  invoice_id = p_inv_id
  And    hold_lookup_code = 'AWAIT_PAY_APP';

Line: 276

  Select hold_lookup_code
  From   AP_HOLDS
  Where  invoice_id = p_inv_id
  And    hold_lookup_code = 'AWAIT_SEC_APP'
  AND    release_lookup_code = 'SEC_APP';

Line: 292

        insert_sec_hold(p_inv_id,p_upd_by);

Line: 299

        insert_sec_hold(p_inv_id,p_upd_by);

Line: 321

				, l_UpdatedByTable(l_Var)
				);

Line: 347

				, l_UpdatedByTable(l_Var)
				);