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.OKS_RULE_MIGRATE dependencies on OKS_STREAM_LEVELS_B

Line 37205: DELETE FROM OKS_STREAM_LEVELS_B

37201: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
37202:
37203: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
37204:
37205: DELETE FROM OKS_STREAM_LEVELS_B
37206: WHERE cle_id = P_CLE_ID;
37207:
37208: If p_us_yn then
37209: insert into oks_stream_levels_b b1

Line 37209: insert into oks_stream_levels_b b1

37205: DELETE FROM OKS_STREAM_LEVELS_B
37206: WHERE cle_id = P_CLE_ID;
37207:
37208: If p_us_yn then
37209: insert into oks_stream_levels_b b1
37210: (ID
37211: ,CHR_ID
37212: ,CLE_ID
37213: ,DNZ_CHR_ID

Line 37272: insert into oks_stream_levels_b b1

37268: and rgp.id = p_rgp_id
37269: and rgp.cle_id = p_cle_id;
37270: Else
37271:
37272: insert into oks_stream_levels_b b1
37273: (ID
37274: ,CHR_ID
37275: ,CLE_ID
37276: ,DNZ_CHR_ID

Line 37337: FND_FILE.PUT_LINE(FND_FILE.LOG ,'Successful on inserting rec in oks_stream_levels_b');

37333: End If;
37334:
37335: -- New code addition on Mar-16-2004 starts
37336:
37337: FND_FILE.PUT_LINE(FND_FILE.LOG ,'Successful on inserting rec in oks_stream_levels_b');
37338:
37339: OPEN L_LVL_CSR ( p_cle_id );
37340: FETCH L_LVL_CSR BULK COLLECT INTO
37341: RUL_IDI

Line 37391: DELETE FROM OKS_STREAM_LEVELS_B

37387: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
37388:
37389: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
37390:
37391: DELETE FROM OKS_STREAM_LEVELS_B
37392: WHERE chr_id = P_CHR_ID;
37393: insert into oks_stream_levels_b(
37394: ID,CHR_ID,CLE_ID,DNZ_CHR_ID,SEQUENCE_NO,UOM_CODE,START_DATE,END_DATE,
37395: LEVEL_PERIODS,UOM_PER_PERIOD,ADVANCE_PERIODS,LEVEL_AMOUNT,

Line 37393: insert into oks_stream_levels_b(

37389: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
37390:
37391: DELETE FROM OKS_STREAM_LEVELS_B
37392: WHERE chr_id = P_CHR_ID;
37393: insert into oks_stream_levels_b(
37394: ID,CHR_ID,CLE_ID,DNZ_CHR_ID,SEQUENCE_NO,UOM_CODE,START_DATE,END_DATE,
37395: LEVEL_PERIODS,UOM_PER_PERIOD,ADVANCE_PERIODS,LEVEL_AMOUNT,
37396: INVOICE_OFFSET_DAYS,INTERFACE_OFFSET_DAYS,COMMENTS,DUE_ARR_YN,
37397: AMOUNT,LINES_DETAILED_YN,OBJECT_VERSION_NUMBER,SECURITY_GROUP_ID,