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_RULE_REPROCESS

Line 22221: Update oks_rule_reprocess

22217: IF ISQLCODE in ( 1,-1) THEN
22218: x_return_status:='S';
22219: Else
22220: x_return_status:='E';
22221: Update oks_rule_reprocess
22222: set errormsg= Emsg
22223: where rowid=prow_id;
22224: End If;
22225:

Line 22228: Update oks_rule_reprocess

22224: End If;
22225:
22226: WHEN VAL_EXCEPTION THEN
22227: x_return_status:='E';
22228: Update oks_rule_reprocess
22229: set errormsg=L_ERROR_MSG
22230: where rowid=prow_id;
22231: WHEN LOCK_EXCEPTION THEN
22232: X_RETURN_STATUS := 'E';

Line 22234: Update oks_rule_reprocess

22230: where rowid=prow_id;
22231: WHEN LOCK_EXCEPTION THEN
22232: X_RETURN_STATUS := 'E';
22233: L_ERROR_MSG := Emsg;
22234: Update oks_rule_reprocess
22235: set errormsg=L_ERROR_MSG
22236: where rowid=prow_id;
22237: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for LOCK '||p_id||'with Error Message '||L_ERROR_MSG);
22238: WHEN OTHERS THEN

Line 22241: Update oks_rule_reprocess

22237: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for LOCK '||p_id||'with Error Message '||L_ERROR_MSG);
22238: WHEN OTHERS THEN
22239: X_RETURN_STATUS := 'E';
22240: L_ERROR_MSG := Emsg;
22241: Update oks_rule_reprocess
22242: set errormsg=L_ERROR_MSG
22243: where rowid=prow_id;
22244: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for'||p_id||'with Error Message '||L_ERROR_MSG);
22245:

Line 24428: Update oks_rule_reprocess

24424: IF ISQLCODE in ( 1,-1) THEN
24425: x_return_status:='S';
24426: Else
24427: x_return_status:='E';
24428: Update oks_rule_reprocess
24429: set errormsg= L_ERROR_MSG
24430: where rowid=prow_id;
24431: End If;
24432: WHEN VAL_EXCEPTION THEN

Line 24435: Update oks_rule_reprocess

24431: End If;
24432: WHEN VAL_EXCEPTION THEN
24433: L_ERROR_MSG := emsg;
24434: x_return_status:='E';
24435: Update oks_rule_reprocess
24436: set errormsg=L_ERROR_MSG
24437: where rowid=prow_id;
24438: WHEN LOCK_EXCEPTION THEN
24439: L_ERROR_MSG := emsg;

Line 24441: Update oks_rule_reprocess

24437: where rowid=prow_id;
24438: WHEN LOCK_EXCEPTION THEN
24439: L_ERROR_MSG := emsg;
24440: X_RETURN_STATUS := 'E';
24441: Update oks_rule_reprocess
24442: set errormsg=L_ERROR_MSG
24443: where rowid=prow_id;
24444: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for LOCK '||p_id||'with Error Message '||L_ERROR_MSG);
24445: WHEN OTHERS THEN

Line 24448: Update oks_rule_reprocess

24444: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for LOCK '||p_id||'with Error Message '||L_ERROR_MSG);
24445: WHEN OTHERS THEN
24446: X_RETURN_STATUS := 'E';
24447: L_ERROR_MSG := emsg;
24448: Update oks_rule_reprocess
24449: set errormsg=L_ERROR_MSG
24450: where rowid=prow_id;
24451: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for'||p_id||'with Error Message '||L_ERROR_MSG);
24452:

Line 25190: --as OKS_RULE_REPROCESS might have many records with no data issue

25186:
25187:
25188: if(CHR_ID is not null) then
25189: --Attempting to insert records first
25190: --as OKS_RULE_REPROCESS might have many records with no data issue
25191:
25192: BEGIN
25193: INSERT INTO oks_k_headers_bh(
25194: ID

Line 26330: Update oks_rule_reprocess

26326: IF ISQLCODE in (1,-1) THEN
26327: x_return_status:='S';
26328: Else
26329: x_return_status:='E';
26330: Update oks_rule_reprocess
26331: set errormsg= Emsg
26332: where rowid=prow_id;
26333: End If;
26334: WHEN VAL_EXCEPTION THEN

Line 26336: Update oks_rule_reprocess

26332: where rowid=prow_id;
26333: End If;
26334: WHEN VAL_EXCEPTION THEN
26335: x_return_status:='E';
26336: Update oks_rule_reprocess
26337: set errormsg=L_ERROR_MSG
26338: where rowid=prow_id;
26339: WHEN OTHERS THEN
26340: X_RETURN_STATUS := 'E';

Line 26342: Update oks_rule_reprocess

26338: where rowid=prow_id;
26339: WHEN OTHERS THEN
26340: X_RETURN_STATUS := 'E';
26341: L_ERROR_MSG := SQLERRM;
26342: Update oks_rule_reprocess
26343: set errormsg=L_ERROR_MSG
26344: where rowid=prow_id;
26345: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for'||p_id||'with Error Message '||L_ERROR_MSG);
26346:

Line 26457: Update oks_rule_reprocess

26453: When LOCK_EXCEPTIOn then
26454: X_RETURN_STATUS := 'E';
26455: L_ERROR_MSG := SQLERRM;
26456: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
26457: Update oks_rule_reprocess
26458: set errormsg=L_ERROR_MSG
26459: where rowid=prow_id;
26460: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for LOCK OKSSYNHL '||p_id||'with Error Message '||L_ERROR_MSG);
26461: WHEN OTHERS THEN

Line 26465: Update oks_rule_reprocess

26461: WHEN OTHERS THEN
26462: X_RETURN_STATUS := 'E';
26463: L_ERROR_MSG := SQLERRM;
26464: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
26465: Update oks_rule_reprocess
26466: set errormsg=L_ERROR_MSG
26467: where rowid=prow_id;
26468: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for LOCK OKSSYNHL '||p_id||'with Error Message '||L_ERROR_MSG);
26469:

Line 26529: Update oks_rule_reprocess

26525: When others then
26526: X_RETURN_STATUS := 'E';
26527: L_ERROR_MSG := SQLERRM;
26528: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
26529: Update oks_rule_reprocess
26530: set errormsg=L_ERROR_MSG
26531: where rowid=prow_id;
26532: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for Reprocess of OKSLEVEL '||p_id||'with Error Message '||L_ERROR_MSG);
26533:

Line 27243: --as OKS_RULE_REPROCESS might have many records with no data issue

27239: iEflag := 0;
27240:
27241: if(CLE_ID is not null) THEN
27242: --Attempting to insert records first
27243: --as OKS_RULE_REPROCESS might have many records with no data issue
27244:
27245: BEGIN
27246: INSERT INTO OKS_K_LINES_BH
27247: ( ID

Line 28402: Update oks_rule_reprocess

28398: IF ISQLCODE in (1,-1) THEN
28399: x_return_status:='S';
28400: Else
28401: x_return_status:='E';
28402: Update oks_rule_reprocess
28403: set errormsg= Emsg
28404: where rowid=prow_id;
28405: End If;
28406: WHEN VAL_EXCEPTION THEN

Line 28408: Update oks_rule_reprocess

28404: where rowid=prow_id;
28405: End If;
28406: WHEN VAL_EXCEPTION THEN
28407: x_return_status:='E';
28408: Update oks_rule_reprocess
28409: set errormsg=L_ERROR_MSG
28410: where rowid=prow_id;
28411: WHEN OTHERS THEN
28412: X_RETURN_STATUS := 'E';

Line 28414: Update oks_rule_reprocess

28410: where rowid=prow_id;
28411: WHEN OTHERS THEN
28412: X_RETURN_STATUS := 'E';
28413: L_ERROR_MSG := SQLERRM;
28414: Update oks_rule_reprocess
28415: set errormsg=L_ERROR_MSG
28416: where rowid=prow_id;
28417: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for'||p_id||'with Error Message '||L_ERROR_MSG);
28418:

Line 28447: from oks_rule_reprocess

28443: Select rowid,
28444: id,
28445: major_version,
28446: misc
28447: from oks_rule_reprocess
28448: where id between P_ID_LOW and P_ID_HI;
28449:
28450: L_ROWID RowId_tbl_Type;
28451: L_RGP_ID L_NUM_TBL;

Line 28546: FROM OKS_RULE_REPROCESS OKS

28542: IF L_DELETE_ROWID.COUNT > 500 THEN
28543: BEGIN
28544: FORALL X IN L_DELETE_ROWID.FIRST..L_DELETE_ROWID.LAST
28545: DELETE /*+ PARALLEL(OKS) */
28546: FROM OKS_RULE_REPROCESS OKS
28547: WHERE ROWID = L_DELETE_ROWID(X);
28548:
28549:
28550: j := 0;

Line 28572: FROM OKS_RULE_REPROCESS OKS

28568: IF L_DELETE_ROWID.COUNT > 0 THEN
28569: BEGIN
28570: FORALL X IN L_DELETE_ROWID.FIRST..L_DELETE_ROWID.LAST
28571: DELETE /*+ PARALLEL(OKS) */
28572: FROM OKS_RULE_REPROCESS OKS
28573: WHERE ROWID = L_DELETE_ROWID(X);
28574:
28575:
28576: j := 0;

Line 38761: FROM OKS_RULE_REPROCESS RGP;

38757: MAX(RGP.ID) MAXID,
38758: AVG(RGP.ID) AVGID,
38759: STDDEV(RGP.ID) STDID,
38760: COUNT(*) TOTAL
38761: FROM OKS_RULE_REPROCESS RGP;
38762:
38763: --- Code to prep the data in OKS_RULE_UPGRADE --
38764: L_LINE_ID L_NUM_TBL ;
38765: L_DNZ_CHR_ID L_NUM_TBL ;

Line 38786: SELECT /+ INDEX_FFS( l OKS_RULE_REPROCESS_NU1) /

38782: AND OKCH.ID = UPG.DNZ_CHR_ID
38783: GROUP BY UPG.RGP_ID, UPG.DNZ_CHR_ID, CUST_PO_NUMBER, CUST_PO_NUMBER_REQ_YN, PRICE_LIST_ID ;
38784:
38785: CURSOR L_REPROCESS_CNT_CSR IS
38786: SELECT /*+ INDEX_FFS( l OKS_RULE_REPROCESS_NU1) */
38787: COUNT(*)
38788: FROM OKS_RULE_REPROCESS l;
38789:
38790: CURSOR L_UPGRADE_CNT_CSR IS

Line 38788: FROM OKS_RULE_REPROCESS l;

38784:
38785: CURSOR L_REPROCESS_CNT_CSR IS
38786: SELECT /*+ INDEX_FFS( l OKS_RULE_REPROCESS_NU1) */
38787: COUNT(*)
38788: FROM OKS_RULE_REPROCESS l;
38789:
38790: CURSOR L_UPGRADE_CNT_CSR IS
38791: SELECT /*+ INDEX_FFS( l OKS_RULE_UPGRADE_NU1) */
38792: COUNT(*)

Line 38842: --- Added the following code to analyze the OKS_RULE_REPROCESS table ---

38838:
38839: ----------------------------------------------------------------------------------------------------
38840:
38841: ----------------------------------------------------------------------------------------------------
38842: --- Added the following code to analyze the OKS_RULE_REPROCESS table ---
38843: ----------------------------------------------------------------------------------------------------
38844: FND_STATS.Gather_Table_Stats(OWNNAME =>'OKS',
38845: TABNAME =>'OKS_RULE_REPROCESS',
38846: PERCENT => 20,

Line 38845: TABNAME =>'OKS_RULE_REPROCESS',

38841: ----------------------------------------------------------------------------------------------------
38842: --- Added the following code to analyze the OKS_RULE_REPROCESS table ---
38843: ----------------------------------------------------------------------------------------------------
38844: FND_STATS.Gather_Table_Stats(OWNNAME =>'OKS',
38845: TABNAME =>'OKS_RULE_REPROCESS',
38846: PERCENT => 20,
38847: RETCODE => l_return_code,
38848: ERRBUF => l_error_buffer);
38849:

Line 39071: L_STMT := 'SELECT MIN(ID),MAX(ID)FROM (SELECT /+ PARALLEL(L) / ID,FLOOR(SUM(COUNT(*)) OVER (ORDER BY ID ROWS UNBOUNDED PRECEDING)/:1) BUCKET FROM OKS_RULE_REPROCESS L GROUP BY ID )GROUP BY BUCKET';

39067: IF(P_BUCKET_VALUE = 0) THEN
39068: P_BUCKET_VALUE := 1;
39069: END IF;
39070:
39071: L_STMT := 'SELECT MIN(ID),MAX(ID)FROM (SELECT /*+ PARALLEL(L) */ ID,FLOOR(SUM(COUNT(*)) OVER (ORDER BY ID ROWS UNBOUNDED PRECEDING)/:1) BUCKET FROM OKS_RULE_REPROCESS L GROUP BY ID )GROUP BY BUCKET';
39072: I:=0;
39073:
39074: OPEN L_REPROC_CSR FOR L_STMT USING P_BUCKET_VALUE ;
39075: LOOP