APPS.FUN_TRX_PVT_W SQL Statements

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

Line: 693

    , p_insert  VARCHAR2
    , p7_a0 in out nocopy  NUMBER
    , p7_a1 in out nocopy  VARCHAR2
    , p7_a2 in out nocopy  NUMBER
    , p7_a3 in out nocopy  NUMBER
    , p7_a4 in out nocopy  NUMBER
    , p7_a5 in out nocopy  NUMBER
    , p7_a6 in out nocopy  VARCHAR2
    , p7_a7 in out nocopy  VARCHAR2
    , p7_a8 in out nocopy  VARCHAR2
    , p7_a9 in out nocopy  VARCHAR2
    , p7_a10 in out nocopy  NUMBER
    , p7_a11 in out nocopy  VARCHAR2
    , p7_a12 in out nocopy  DATE
    , p7_a13 in out nocopy  DATE
    , p7_a14 in out nocopy  VARCHAR2
    , p7_a15 in out nocopy  NUMBER
    , p7_a16 in out nocopy  VARCHAR2
    , p8_a0 in out nocopy JTF_NUMBER_TABLE
    , p8_a1 in out nocopy JTF_NUMBER_TABLE
    , p8_a2 in out nocopy JTF_NUMBER_TABLE
    , p8_a3 in out nocopy JTF_NUMBER_TABLE
    , p8_a4 in out nocopy JTF_NUMBER_TABLE
    , p8_a5 in out nocopy JTF_NUMBER_TABLE
    , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_100
    , p8_a7 in out nocopy JTF_NUMBER_TABLE
    , p8_a8 in out nocopy JTF_NUMBER_TABLE
    , p8_a9 in out nocopy JTF_NUMBER_TABLE
    , p8_a10 in out nocopy JTF_NUMBER_TABLE
    , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
    , p8_a12 in out nocopy JTF_VARCHAR2_TABLE_100
    , p8_a13 in out nocopy JTF_NUMBER_TABLE
    , p8_a14 in out nocopy JTF_DATE_TABLE
    , p8_a15 in out nocopy JTF_NUMBER_TABLE
    , p8_a16 in out nocopy JTF_NUMBER_TABLE
    , p8_a17 in out nocopy JTF_NUMBER_TABLE
    , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_100
    , p8_a19 in out nocopy JTF_VARCHAR2_TABLE_100
    , p8_a20 in out nocopy JTF_VARCHAR2_TABLE_100
    , p8_a21 in out nocopy JTF_VARCHAR2_TABLE_100
    , p9_a0 in out nocopy JTF_NUMBER_TABLE
    , p9_a1 in out nocopy JTF_NUMBER_TABLE
    , p9_a2 in out nocopy JTF_NUMBER_TABLE
    , p9_a3 in out nocopy JTF_NUMBER_TABLE
    , p9_a4 in out nocopy JTF_NUMBER_TABLE
    , p9_a5 in out nocopy JTF_NUMBER_TABLE
    , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
    , p10_a0 in out nocopy JTF_NUMBER_TABLE
    , p10_a1 in out nocopy JTF_NUMBER_TABLE
    , p10_a2 in out nocopy JTF_NUMBER_TABLE
    , p10_a3 in out nocopy JTF_NUMBER_TABLE
    , p10_a4 in out nocopy JTF_NUMBER_TABLE
    , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
    , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
    , p10_a7 in out nocopy JTF_NUMBER_TABLE
    , p10_a8 in out nocopy JTF_NUMBER_TABLE
    , p10_a9 in out nocopy JTF_NUMBER_TABLE
    , p10_a10 in out nocopy JTF_NUMBER_TABLE
    , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
  )

  as
    ddp_batch_rec fun_trx_pvt.batch_rec_type;

Line: 842

      p_insert,
      ddp_batch_rec,
      ddp_trx_tbl,
      ddp_init_dist_tbl,
      ddp_dist_lines_tbl);

Line: 1876

        	 ame_api2.updateApprovalStatus(
                        applicationIdIn     => 435,
                        transactionTypeIn   => 'FUN_IC_RECI_TRX',
                        transactionIdIn     => ddp_dist_lines_tbl(1).trx_id,
                        approverIn          => l_approver_record);

Line: 1889

                     ame_api2.updateApprovalStatus(
                        applicationIdIn     => 435,
                        transactionTypeIn   => 'FUN_IC_RECI_TRX',
                        transactionIdIn     => ddp_dist_lines_tbl(1).trx_id,
                        approverIn          => l_approver_record);

Line: 1896

                      SELECT DISTINCT ITEM_KEY INTO l_event_key
                      from WF_ITEM_ACTIVITY_STATUSES WIAS
                      where WIAS.ITEM_TYPE = 'FUNRMAIN'
		      AND ACTIVITY_STATUS  = 'ACTIVE'
                      AND ITEM_KEY LIKE  ddp_batch_rec.batch_id || '_' || ddp_dist_lines_tbl(1).trx_id || '%';

Line: 2147

              	   SELECT ( DIST_ID )
                   INTO l_ccid(i)
                   FROM fun_dist_lines
		   where TRX_ID = ddp_dist_lines_tbl(i).trx_id
                   AND ROWNUM=1
                   and PARTY_TYPE_FLAG='R'
		   and DIST_TYPE_FLAG='L'
                   and (AMOUNT_CR=ddp_dist_lines_tbl(i).amount_cr
                        OR AMOUNT_DR=ddp_dist_lines_tbl(i).amount_dr )
                    AND 'N' = fun_trx_pvt_w.isOldDistId(dist_id);