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.PON_CLO_RENUMBER_PKG dependencies on PON_CLO_RENUMBER_PKG

Line 1: PACKAGE BODY pon_clo_renumber_pkg AS

1: PACKAGE BODY pon_clo_renumber_pkg AS
2: /* $Header: PONCLORNB.pls 120.27.12020000.2 2013/02/09 08:50:06 hvutukur ship $ */
3:
4: -----------------------------------------------------------------
5: FUNCTION sort_table(LineArray PO_TBL_VARCHAR100)

Line 468: next_clin := pon_clo_renumber_pkg.next_clin_num(tbl);

464: || ' order by line_num_display';
465: END IF;
466: EXECUTE IMMEDIATE line_num_tbl_qry BULK COLLECT INTO tbl;
467:
468: next_clin := pon_clo_renumber_pkg.next_clin_num(tbl);
469: RETURN next_clin;
470: END;
471:
472: FUNCTION ELIN_TO_DECIMAL(linNum VARCHAR2) RETURN NUMBER

Line 539: (SELECT pon_clo_renumber_pkg.ELIN_TO_DECIMAL(SubStr(line_num_display,exhibit_len+1,4-exhibit_len)) elin_decimal

535:
536: SELECT Nvl(Max(ROWNUM),0)+1
537: INTO lineNumber
538: FROM
539: (SELECT pon_clo_renumber_pkg.ELIN_TO_DECIMAL(SubStr(line_num_display,exhibit_len+1,4-exhibit_len)) elin_decimal
540: FROM
541: pon_auction_item_prices_all where auction_header_id = p_Document_ID
542: and exhibit_number = p_exhibit_number AND line_num_display IS NOT null order by elin_decimal)
543: WHERE ELIN_DECIMAL=rownum;

Line 592: line_num_tbl_qry := 'SELECT Nvl(Max(ROWNUM),0)+1 FROM (SELECT pon_clo_renumber_pkg.ELIN_TO_DECIMAL(SubStr(line_num_display,'

588: exhibit_len:=Length(p_exhibit_number);
589:
590: setProductContext(p_product_code,lines_tbl_name,doc_id_col,lineid_col,exhibit_col);
591:
592: line_num_tbl_qry := 'SELECT Nvl(Max(ROWNUM),0)+1 FROM (SELECT pon_clo_renumber_pkg.ELIN_TO_DECIMAL(SubStr(line_num_display,'
593: || exhibit_len||'+1,4-'||exhibit_len||')) elin_decimal FROM '
594: || lines_tbl_name
595: || ' where ' || doc_id_col || ' = ' || p_Document_ID
596: || ' and '||exhibit_col||' ='''||p_exhibit_number||''''

Line 664: next_clin := pon_clo_renumber_pkg.next_clin_num(union_table);

660: EXECUTE IMMEDIATE line_num_tbl_qry BULK COLLECT INTO tbl;
661:
662: union_table := tbl multiset UNION new_lines;
663:
664: next_clin := pon_clo_renumber_pkg.next_clin_num(union_table);
665: RETURN next_clin;
666: END;
667:
668:

Line 973: l_pkg_name CONSTANT VARCHAR2(30) := 'PON_CLO_RENUMBER_PKG';

969: slins po_tbl_varchar100 := po_tbl_varchar100();
970: newslin VARCHAR2(6);
971:
972: l_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
973: l_pkg_name CONSTANT VARCHAR2(30) := 'PON_CLO_RENUMBER_PKG';
974: l_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.' || l_pkg_name || '.';
975: l_module CONSTANT VARCHAR2(32) := 'GetNextSlinNumber';
976: l_message VARCHAR2(1000);
977:

Line 1010: newslin := pon_clo_renumber_pkg.INCREMENT_PRICED_SLIN_NUMBER(newslin);

1006:
1007: IF(newslin <> slins(i)) THEN
1008: --Dbms_Output.put_line(' got hole ' || newslin);
1009: /*IF(InStr(newslin,'I')<>0 OR InStr(newslin,'O') <> 0) THEN
1010: newslin := pon_clo_renumber_pkg.INCREMENT_PRICED_SLIN_NUMBER(newslin);
1011: CONTINUE;
1012: END IF;*/
1013: RETURN newslin;
1014: END IF;

Line 1016: newslin := pon_clo_renumber_pkg.INCREMENT_INFO_SLIN_NUMBER(newslin);

1012: END IF;*/
1013: RETURN newslin;
1014: END IF;
1015:
1016: newslin := pon_clo_renumber_pkg.INCREMENT_INFO_SLIN_NUMBER(newslin);
1017: END LOOP;
1018:
1019: RETURN newslin;
1020: -- l_nextNum := pon_clo_renumber_pkg.testIncrementInfoSlinNum(l_infoSlinNum);

Line 1020: -- l_nextNum := pon_clo_renumber_pkg.testIncrementInfoSlinNum(l_infoSlinNum);

1016: newslin := pon_clo_renumber_pkg.INCREMENT_INFO_SLIN_NUMBER(newslin);
1017: END LOOP;
1018:
1019: RETURN newslin;
1020: -- l_nextNum := pon_clo_renumber_pkg.testIncrementInfoSlinNum(l_infoSlinNum);
1021: -- Dbms_Output.put_line(l_nextNum);
1022:
1023: EXCEPTION
1024: WHEN OTHERS THEN

Line 1058: newslin := pon_clo_renumber_pkg.INCREMENT_PRICED_SLIN_NUMBER(newslin);

1054:
1055: IF(newslin <> slins(i)) THEN
1056: --Dbms_Output.put_line(' got hole ' || newslin);
1057: /*IF(InStr(newslin,'I')<>0 OR InStr(newslin,'O') <> 0) THEN
1058: newslin := pon_clo_renumber_pkg.INCREMENT_PRICED_SLIN_NUMBER(newslin);
1059: CONTINUE;
1060: END IF;*/
1061: RETURN newslin;
1062: END IF;

Line 1064: newslin := pon_clo_renumber_pkg.INCREMENT_PRICED_SLIN_NUMBER(newslin);

1060: END IF;*/
1061: RETURN newslin;
1062: END IF;
1063:
1064: newslin := pon_clo_renumber_pkg.INCREMENT_PRICED_SLIN_NUMBER(newslin);
1065: END LOOP;
1066:
1067: RETURN newslin;
1068: -- l_nextNum := pon_clo_renumber_pkg.testIncrementInfoSlinNum(l_infoSlinNum);

Line 1068: -- l_nextNum := pon_clo_renumber_pkg.testIncrementInfoSlinNum(l_infoSlinNum);

1064: newslin := pon_clo_renumber_pkg.INCREMENT_PRICED_SLIN_NUMBER(newslin);
1065: END LOOP;
1066:
1067: RETURN newslin;
1068: -- l_nextNum := pon_clo_renumber_pkg.testIncrementInfoSlinNum(l_infoSlinNum);
1069: -- Dbms_Output.put_line(l_nextNum);
1070:
1071: EXCEPTION
1072: WHEN OTHERS THEN

Line 1323: module => 'pon.plsql.pon_clo_renumber_pkg',

1319: LINE_NUM_DISPLAY = p_clinnumber;
1320:
1321: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1322: FND_LOG.string(log_level => FND_LOG.level_statement,
1323: module => 'pon.plsql.pon_clo_renumber_pkg',
1324: message => substr('l_group_line_id : '||l_group_line_id, 0, 4000));
1325: END IF;
1326:
1327:

Line 1343: module => 'pon.plsql.pon_clo_renumber_pkg',

1339: LOOP
1340: FETCH all_slins INTO slnLineId, slnInfoFlg;
1341: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1342: FND_LOG.string(log_level => FND_LOG.level_statement,
1343: module => 'pon.plsql.pon_clo_renumber_pkg',
1344: message => substr('slnLineId : '||slnLineId, 0, 4000));
1345: FND_LOG.string(log_level => FND_LOG.level_statement,
1346: module => 'pon.plsql.pon_clo_renumber_pkg',
1347: message => substr('slnInfoFlg : '||slnInfoFlg, 0, 4000));

Line 1346: module => 'pon.plsql.pon_clo_renumber_pkg',

1342: FND_LOG.string(log_level => FND_LOG.level_statement,
1343: module => 'pon.plsql.pon_clo_renumber_pkg',
1344: message => substr('slnLineId : '||slnLineId, 0, 4000));
1345: FND_LOG.string(log_level => FND_LOG.level_statement,
1346: module => 'pon.plsql.pon_clo_renumber_pkg',
1347: message => substr('slnInfoFlg : '||slnInfoFlg, 0, 4000));
1348: END IF;
1349:
1350: IF all_slins%NOTFOUND THEN

Line 1368: module => 'pon.plsql.pon_clo_renumber_pkg',

1364: END;
1365: lastPricedSlin := INCREMENT_PRICED_SLIN_NUMBER(lastPricedSlin);
1366: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1367: FND_LOG.string(log_level => FND_LOG.level_statement,
1368: module => 'pon.plsql.pon_clo_renumber_pkg',
1369: message => substr('lastPricedSlin : '||lastPricedSlin, 0, 4000));
1370: END IF;
1371: ELSE
1372: l_updt_query := ' UPDATE PO_LINES_INTERFACE

Line 1384: module => 'pon.plsql.pon_clo_renumber_pkg',

1380: END;
1381: lastInfoSlin := INCREMENT_INFO_SLIN_NUMBER(lastInfoSlin);
1382: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1383: FND_LOG.string(log_level => FND_LOG.level_statement,
1384: module => 'pon.plsql.pon_clo_renumber_pkg',
1385: message => substr('lastInfoSlin : '||lastInfoSlin, 0, 4000));
1386: END IF;
1387: END IF;
1388: END LOOP;

Line 1434: next_clin := pon_clo_renumber_pkg.next_clin_num(tbl);

1430: /*FOR i IN 1..tbl.Count LOOP
1431: debug_clin_number(tbl(i));
1432: END LOOP; */
1433:
1434: next_clin := pon_clo_renumber_pkg.next_clin_num(tbl);
1435: RETURN next_clin;
1436:
1437: END NEXT_CLIN_NUM_WRAPPER3;
1438:

Line 1440: END PON_CLO_RENUMBER_PKG;

1436:
1437: END NEXT_CLIN_NUM_WRAPPER3;
1438:
1439:
1440: END PON_CLO_RENUMBER_PKG;