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_NEGOTIATION_HELPER_PVT dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 40: FROM PON_AUCTION_ITEM_PRICES_ALL

36: --that have SUB_LINE_SEQUENCE_NUMBER > p_value
37:
38: SELECT MIN(disp_line_number)
39: INTO x_min_disp_line_num
40: FROM PON_AUCTION_ITEM_PRICES_ALL
41: WHERE AUCTION_HEADER_ID = p_auction_header_id
42: AND GROUP_TYPE IN ('LOT', 'GROUP', 'LINE')
43: AND SUB_LINE_SEQUENCE_NUMBER > p_value;
44:

Line 74: l_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;

70: p_value IN NUMBER,
71: x_max_disp_line_num OUT NOCOPY NUMBER
72: ) IS
73:
74: l_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
75: l_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
76: BEGIN
77:
78: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 75: l_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;

71: x_max_disp_line_num OUT NOCOPY NUMBER
72: ) IS
73:
74: l_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
75: l_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
76: BEGIN
77:
78: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
79: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 91: FROM PON_AUCTION_ITEM_PRICES_ALL

87: --that have SUB_LINE_SEQUENCE_NUMBER < p_value
88:
89: SELECT MAX(DISP_LINE_NUMBER)
90: INTO x_max_disp_line_num
91: FROM PON_AUCTION_ITEM_PRICES_ALL
92: WHERE AUCTION_HEADER_ID = p_auction_header_id
93: AND GROUP_TYPE IN ('LOT', 'LINE', 'GROUP')
94: AND SUB_LINE_SEQUENCE_NUMBER < p_value;
95:

Line 116: FROM PON_AUCTION_ITEM_PRICES_ALL

112: END IF;
113:
114: SELECT GROUP_TYPE, LINE_NUMBER
115: INTO l_group_type, l_line_number
116: FROM PON_AUCTION_ITEM_PRICES_ALL
117: WHERE AUCTION_HEADER_ID = p_auction_header_id
118: AND DISP_LINE_NUMBER = x_max_disp_line_num;
119:
120: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 133: FROM PON_AUCTION_ITEM_PRICES_ALL

129:
130: IF (l_group_type <> 'LINE') THEN
131: SELECT NVL (MAX(DISP_LINE_NUMBER), x_max_disp_line_num)
132: INTO x_max_disp_line_num
133: FROM PON_AUCTION_ITEM_PRICES_ALL
134: WHERE AUCTION_HEADER_ID = p_auction_header_id
135: AND PARENT_LINE_NUMBER = l_line_number;
136: END IF;
137:

Line 294: PON_AUCTION_ITEM_PRICES_ALL PAIP,

290: PAIP.LINE_NUMBER
291: INTO
292: l_line_number
293: FROM
294: PON_AUCTION_ITEM_PRICES_ALL PAIP,
295: PON_PRICE_ELEMENTS PPE
296: WHERE
297: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
298: PPE.AUCTION_HEADER_ID = p_auction_header_id AND

Line 400: pon_auction_item_prices_all items

396: x_max_internal_line_num,
397: x_max_document_line_num,
398: x_max_disp_line_num
399: FROM
400: pon_auction_item_prices_all items
401: WHERE
402: items.auction_header_id = p_auction_header_id;
403:
404: END IF;

Line 474: PON_AUCTION_ITEM_PRICES_ALL

470: COUNT(LINE_NUMBER)
471: INTO
472: x_number_of_lines
473: FROM
474: PON_AUCTION_ITEM_PRICES_ALL
475: WHERE
476: AUCTION_HEADER_ID = p_auction_header_id;
477:
478: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.g_current_runtime_level) THEN

Line 534: PON_AUCTION_ITEM_PRICES_ALL

530: LINE_NUMBER
531: INTO
532: l_line_number
533: FROM
534: PON_AUCTION_ITEM_PRICES_ALL
535: WHERE
536: AUCTION_HEADER_ID = p_auction_header_id AND
537: ROWNUM = 1;
538:

Line 609: FROM PON_AUCTION_ITEM_PRICES_ALL

605: END IF;
606:
607: SELECT MAX(LINE_NUMBER)
608: INTO l_max_line_number
609: FROM PON_AUCTION_ITEM_PRICES_ALL
610: WHERE AUCTION_HEADER_ID=p_auction_header_id;
611:
612: -- Get the batch size
613: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

Line 1279: entity_name = 'PON_AUCTION_ITEM_PRICES_ALL' AND

1275: DISTINCT (TO_NUMBER(pk2_value)) line_number
1276: FROM
1277: fnd_attached_documents
1278: WHERE
1279: entity_name = 'PON_AUCTION_ITEM_PRICES_ALL' AND
1280: pk1_value = to_char(p_auction_header_id) AND
1281: pk2_value IS NOT NULL;
1282:
1283: --Cursor to find out lines that have backing requisitions

Line 1288: pon_auction_item_prices_all

1284: CURSOR lines_with_backing_requisition (t_auction_header_id NUMBER) IS
1285: SELECT
1286: line_number, org_id
1287: FROM
1288: pon_auction_item_prices_all
1289: WHERE
1290: auction_header_id = t_auction_header_id AND
1291: requisition_number IS NOT NULL;
1292:

Line 1376: FROM pon_auction_item_prices_all

1372: paha.doctype_id = pad.doctype_id;
1373:
1374: SELECT NVL (MAX (line_number), 0)
1375: INTO l_max_line_number
1376: FROM pon_auction_item_prices_all
1377: where auction_header_id = p_auction_header_id;
1378:
1379: -- Get the batch size
1380: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

Line 1439: x_entity_name =>'PON_AUCTION_ITEM_PRICES_ALL',

1435: --Delete Attachments
1436: FOR attachment_line IN lines_with_attachements LOOP
1437:
1438: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
1439: x_entity_name =>'PON_AUCTION_ITEM_PRICES_ALL',
1440: x_pk1_value => p_auction_header_id,
1441: x_pk2_value => attachment_line.line_number,
1442: x_pk3_value => NULL,
1443: x_pk4_value => NULL,

Line 1686: pon_auction_item_prices_all

1682: END IF;
1683: /* End Supplier Management: Mapping */
1684: -- Delete the entries for lines
1685: DELETE FROM
1686: pon_auction_item_prices_all
1687: WHERE
1688: auction_header_id = p_auction_header_id AND
1689: line_number >= l_batch_start AND
1690: line_number <= l_batch_end;

Line 1851: l_exhibit_number PON_AUCTION_ITEM_PRICES_ALL.EXHIBIT_NUMBER%TYPE;

1847: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
1848:
1849: -- Federal Fields Project
1850: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1851: l_exhibit_number PON_AUCTION_ITEM_PRICES_ALL.EXHIBIT_NUMBER%TYPE;
1852: l_exhibits NUMBER;
1853: -- Cursor to find out lines that have attachments
1854: -- within a lot/group
1855: CURSOR lines_with_attachements IS

Line 1860: pon_auction_item_prices_all paip

1856: SELECT
1857: DISTINCT (TO_NUMBER(fad.pk2_value)) line_number
1858: FROM
1859: fnd_attached_documents fad,
1860: pon_auction_item_prices_all paip
1861: WHERE
1862: fad.entity_name = 'PON_AUCTION_ITEM_PRICES_ALL' AND
1863: fad.pk1_value = TO_CHAR(p_auction_header_id) AND
1864: paip.auction_header_id = p_auction_header_id AND

Line 1862: fad.entity_name = 'PON_AUCTION_ITEM_PRICES_ALL' AND

1858: FROM
1859: fnd_attached_documents fad,
1860: pon_auction_item_prices_all paip
1861: WHERE
1862: fad.entity_name = 'PON_AUCTION_ITEM_PRICES_ALL' AND
1863: fad.pk1_value = TO_CHAR(p_auction_header_id) AND
1864: paip.auction_header_id = p_auction_header_id AND
1865: fad.pk2_value = paip.line_number AND
1866: (paip.line_number = p_line_number OR paip.parent_line_number = p_line_number);

Line 1874: pon_auction_item_prices_all

1870: CURSOR lines_with_backing_requisition IS
1871: SELECT
1872: line_number, org_id
1873: FROM
1874: pon_auction_item_prices_all
1875: WHERE
1876: auction_header_id = p_auction_header_id AND
1877: (line_number = p_line_number OR parent_line_number = p_line_number) AND
1878: requisition_number IS NOT NULL;

Line 1887: pon_auction_item_prices_all paip

1883: SELECT
1884: DISTINCT (TO_NUMBER(fad.pk2_value)) line_number
1885: FROM
1886: fnd_attached_documents fad,
1887: pon_auction_item_prices_all paip
1888: WHERE
1889: fad.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS' AND
1890: fad.pk1_value = TO_CHAR(p_auction_header_id) AND
1891: paip.auction_header_id = p_auction_header_id AND

Line 1999: pon_auction_item_prices_all

1995: line_number
1996: INTO
1997: l_line_number
1998: FROM
1999: pon_auction_item_prices_all
2000: WHERE
2001: auction_header_id = p_auction_header_id and
2002: line_number = p_line_number;
2003:

Line 2166: FROM pon_auction_item_prices_all

2162: /* End Supplier Management: Mapping */
2163:
2164: SELECT exhibit_number
2165: INTO l_exhibit_number
2166: FROM pon_auction_item_prices_all
2167: WHERE auction_header_id = p_auction_header_id AND
2168: line_number = p_line_number;
2169:
2170: DELETE FROM

Line 2171: pon_auction_item_prices_all

2167: WHERE auction_header_id = p_auction_header_id AND
2168: line_number = p_line_number;
2169:
2170: DELETE FROM
2171: pon_auction_item_prices_all
2172: WHERE
2173: auction_header_id = p_auction_header_id AND
2174: line_number = p_line_number;
2175:

Line 2230: x_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

2226:
2227: END IF;
2228:
2229: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
2230: x_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2231: x_pk1_value => p_auction_header_id,
2232: x_pk2_value => p_line_number);
2233:
2234: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2283: pon_auction_item_prices_all

2279: IF (p_group_type IN ('LOT_LINE', 'GROUP_LINE') AND
2280: l_amendment_number > 0 AND
2281: p_sub_line_sequence_number <= l_header_max_document_line_num) THEN
2282: UPDATE
2283: pon_auction_item_prices_all
2284: SET
2285: modified_flag = 'Y',
2286: modified_date = sysdate,
2287: last_amendment_update = l_amendment_number

Line 2298: PON_AUCTION_ITEM_PRICES_ALL

2294: IF (p_group_type IN ('LOT_LINE', 'GROUP_LINE') AND
2295: l_auction_round_number > 1 AND
2296: p_sub_line_sequence_number <= l_header_max_document_line_num) THEN
2297: UPDATE
2298: PON_AUCTION_ITEM_PRICES_ALL
2299: SET
2300: MODIFIED_FLAG = 'Y',
2301: MODIFIED_DATE = SYSDATE
2302: WHERE

Line 2318: pon_auction_item_prices_all

2314: count(line_number)
2315: INTO
2316: x_number_of_lines_deleted
2317: FROM
2318: pon_auction_item_prices_all
2319: WHERE
2320: auction_header_id = p_auction_header_id AND
2321: (line_number = p_line_number OR parent_line_number = p_line_number);
2322:

Line 2354: pon_auction_item_prices_all paip

2350: (
2351: SELECT
2352: paip.line_number
2353: FROM
2354: pon_auction_item_prices_all paip
2355: WHERE
2356: paip.parent_line_number = p_line_number AND
2357: paip.auction_header_id = p_auction_header_id AND
2358: paip.line_number = pas.line_number

Line 2377: pon_auction_item_prices_all paip

2373: (
2374: SELECT
2375: paip.line_number
2376: FROM
2377: pon_auction_item_prices_all paip
2378: WHERE
2379: paip.parent_line_number = p_line_number AND
2380: paip.auction_header_id = p_auction_header_id AND
2381: paip.line_number = paa.line_number

Line 2411: pon_auction_item_prices_all paip

2407: (
2408: SELECT
2409: paip.line_number
2410: FROM
2411: pon_auction_item_prices_all paip
2412: WHERE
2413: paip.parent_line_number = p_line_number AND
2414: paip.auction_header_id = p_auction_header_id AND
2415: paip.line_number = ppsv.line_number

Line 2432: pon_auction_item_prices_all paip

2428: (
2429: SELECT
2430: paip.line_number
2431: FROM
2432: pon_auction_item_prices_all paip
2433: WHERE
2434: paip.parent_line_number = p_line_number AND
2435: paip.auction_header_id = p_auction_header_id AND
2436: paip.line_number = ppe.line_number

Line 2482: pon_auction_item_prices_all paip

2478: (
2479: SELECT
2480: paip.line_number
2481: FROM
2482: pon_auction_item_prices_all paip
2483: WHERE
2484: paip.parent_line_number = p_line_number AND
2485: paip.auction_header_id = p_auction_header_id AND
2486: paip.line_number = paps.line_number

Line 2527: pon_auction_item_prices_all paip

2523: (
2524: SELECT
2525: paip.line_number
2526: FROM
2527: pon_auction_item_prices_all paip
2528: WHERE
2529: paip.parent_line_number = p_line_number AND
2530: paip.auction_header_id = p_auction_header_id AND
2531: paip.line_number = pasa.line_number

Line 2567: pon_auction_item_prices_all paip

2563: (
2564: SELECT
2565: paip.line_number
2566: FROM
2567: pon_auction_item_prices_all paip
2568: WHERE
2569: paip.parent_line_number = p_line_number AND
2570: paip.auction_header_id = p_auction_header_id AND
2571: paip.line_number = ppd.line_number

Line 2599: pon_auction_item_prices_all paip

2595: (
2596: SELECT
2597: paip.line_number
2598: FROM
2599: pon_auction_item_prices_all paip
2600: WHERE
2601: paip.parent_line_number = p_line_number AND
2602: paip.auction_header_id = p_auction_header_id AND
2603: paip.line_number = pple.line_number

Line 2618: x_entity_name =>'PON_AUCTION_ITEM_PRICES_ALL',

2614: --Delete Attachments
2615: FOR attachment_line IN lines_with_attachements LOOP
2616:
2617: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
2618: x_entity_name =>'PON_AUCTION_ITEM_PRICES_ALL',
2619: x_pk1_value => p_auction_header_id,
2620: x_pk2_value => attachment_line.line_number,
2621: x_pk3_value => NULL,
2622: x_pk4_value => NULL,

Line 2685: FROM pon_auction_item_prices_all

2681: DELETE FROM pon_auction_attr_mapping_b
2682: WHERE auction_header_id = p_auction_header_id
2683: AND (line_number = p_line_number OR
2684: ( line_number IN ( SELECT line_number
2685: FROM pon_auction_item_prices_all
2686: WHERE auction_header_id = p_auction_header_id
2687: AND parent_line_number = p_line_number) ) )
2688: AND mapping_type IN ('ITEM_LINE', 'CAT_LINE');
2689: END IF;

Line 2693: pon_auction_item_prices_all

2689: END IF;
2690: /* End Supplier Management: Mapping */
2691: -- Finally delete the lines
2692: DELETE FROM
2693: pon_auction_item_prices_all
2694: WHERE
2695: auction_header_id = p_auction_header_id AND
2696: (line_number = p_line_number OR parent_line_number = p_line_number);
2697:

Line 2870: PON_AUCTION_ITEM_PRICES_ALL

2866: LINE_NUMBER
2867: BULK COLLECT INTO
2868: l_line_number
2869: FROM
2870: PON_AUCTION_ITEM_PRICES_ALL
2871: WHERE
2872: AUCTION_HEADER_ID = p_auction_header_id AND
2873: GROUP_TYPE IN ('LOT', 'GROUP', 'LINE') AND
2874: SUB_LINE_SEQUENCE_NUMBER > l_max_document_line_num AND

Line 2908: PON_AUCTION_ITEM_PRICES_ALL

2904: NVL (MAX (SUB_LINE_SEQUENCE_NUMBER), 0)
2905: INTO
2906: l_max_sub_line_sequence_number
2907: FROM
2908: PON_AUCTION_ITEM_PRICES_ALL
2909: WHERE
2910: AUCTION_HEADER_ID = p_auction_header_id AND
2911: DISP_LINE_NUMBER < p_min_disp_line_number_parent AND
2912: GROUP_TYPE IN ('LINE','LOT', 'GROUP');

Line 2953: PON_AUCTION_ITEM_PRICES_ALL

2949:
2950: --UPDATE THE LINES, LOTS AND GROUPS WITH THE NEW VALUES
2951: FORALL x in 1..l_line_number.COUNT
2952: UPDATE
2953: PON_AUCTION_ITEM_PRICES_ALL
2954: SET
2955: SUB_LINE_SEQUENCE_NUMBER = l_sub_line_seq_number (x),
2956: DOCUMENT_DISP_LINE_NUMBER = l_sub_line_seq_number (x),
2957: LAST_UPDATE_DATE = SYSDATE,

Line 2986: PON_AUCTION_ITEM_PRICES_ALL CHILDREN,

2982: l_parent_max_sub_line_seq_num,
2983: l_parent_line_number,
2984: l_parent_doc_disp_line_number
2985: FROM
2986: PON_AUCTION_ITEM_PRICES_ALL CHILDREN,
2987: PON_AUCTION_ITEM_PRICES_ALL PARENT
2988: WHERE
2989: CHILDREN.AUCTION_HEADER_ID = p_auction_header_id AND
2990: PARENT.AUCTION_HEADER_ID = p_auction_header_id AND

Line 2987: PON_AUCTION_ITEM_PRICES_ALL PARENT

2983: l_parent_line_number,
2984: l_parent_doc_disp_line_number
2985: FROM
2986: PON_AUCTION_ITEM_PRICES_ALL CHILDREN,
2987: PON_AUCTION_ITEM_PRICES_ALL PARENT
2988: WHERE
2989: CHILDREN.AUCTION_HEADER_ID = p_auction_header_id AND
2990: PARENT.AUCTION_HEADER_ID = p_auction_header_id AND
2991: PARENT.LINE_NUMBER = CHILDREN.PARENT_LINE_NUMBER AND

Line 3029: PON_AUCTION_ITEM_PRICES_ALL

3025: NVL (MAX (SUB_LINE_SEQUENCE_NUMBER), 0)
3026: INTO
3027: l_current_max_sub_line_seq
3028: FROM
3029: PON_AUCTION_ITEM_PRICES_ALL
3030: WHERE
3031: AUCTION_HEADER_ID = p_auction_header_id AND
3032: PARENT_LINE_NUMBER = p_min_child_parent_line_num AND
3033: DISP_LINE_NUMBER < p_min_disp_line_number_child;

Line 3099: UPDATE PON_AUCTION_ITEM_PRICES_ALL

3095: END LOOP;
3096:
3097: --UPDATE THE LOT_LINES AND GROUP_LINES WITH THE NEW VALUES
3098: FORALL x in 1..l_line_number.COUNT
3099: UPDATE PON_AUCTION_ITEM_PRICES_ALL
3100: SET
3101: SUB_LINE_SEQUENCE_NUMBER = l_sub_line_seq_number (x),
3102: DOCUMENT_DISP_LINE_NUMBER = l_document_disp_line_number (x),
3103: LAST_UPDATE_DATE = SYSDATE,

Line 3136: PON_AUCTION_ITEM_PRICES_ALL

3132: LINE_NUMBER
3133: BULK COLLECT INTO
3134: l_line_number
3135: FROM
3136: PON_AUCTION_ITEM_PRICES_ALL
3137: WHERE
3138: AUCTION_HEADER_ID = p_auction_header_id AND
3139: DISP_LINE_NUMBER > l_min_disp_line_number
3140: ORDER BY

Line 3163: pon_auction_item_prices_all

3159: MAX(sub_line_sequence_number)
3160: INTO
3161: l_temp_char
3162: FROM
3163: pon_auction_item_prices_all
3164: WHERE
3165: auction_header_id = p_auction_header_id and
3166: group_type IN ('LOT', 'LINE', 'GROUP');
3167:

Line 3207: UPDATE PON_AUCTION_ITEM_PRICES_ALL

3203: END IF;
3204:
3205: --BULK UPDATE TO SET THE NEW DISP_LINE_NUMBER
3206: FORALL x IN 1..l_line_number.COUNT
3207: UPDATE PON_AUCTION_ITEM_PRICES_ALL
3208: SET DISP_LINE_NUMBER = l_new_disp_line_number (x)
3209: WHERE LINE_NUMBER = l_line_number(x)
3210: AND AUCTION_HEADER_ID = p_auction_header_id;
3211:

Line 3219: pon_auction_item_prices_all

3215: MAX(sub_line_sequence_number)
3216: INTO
3217: x_last_line_number
3218: FROM
3219: pon_auction_item_prices_all
3220: WHERE
3221: auction_header_id = p_auction_header_id and
3222: group_type IN ('LOT', 'LINE', 'GROUP');
3223:

Line 3286: FROM PON_AUCTION_ITEM_PRICES_ALL

3282: --that have SUB_LINE_SEQUENCE_NUMBER > p_value
3283:
3284: SELECT MIN(disp_line_number)
3285: INTO x_curr_min_disp_line_num
3286: FROM PON_AUCTION_ITEM_PRICES_ALL
3287: WHERE AUCTION_HEADER_ID = p_curr_auction_header_id
3288: AND GROUP_TYPE IN ('LOT', 'GROUP', 'LINE')
3289: AND SUB_LINE_SEQUENCE_NUMBER > p_value;
3290:

Line 3293: FROM PON_AUCTION_ITEM_PRICES_ALL

3289: AND SUB_LINE_SEQUENCE_NUMBER > p_value;
3290:
3291: SELECT MIN(disp_line_number)
3292: INTO x_prev_min_disp_line_num
3293: FROM PON_AUCTION_ITEM_PRICES_ALL
3294: WHERE AUCTION_HEADER_ID = p_prev_auction_header_id
3295: AND GROUP_TYPE IN ('LOT', 'GROUP', 'LINE')
3296: AND SUB_LINE_SEQUENCE_NUMBER > p_value;
3297:

Line 3334: l_curr_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;

3330: x_curr_max_disp_line_num OUT NOCOPY NUMBER,
3331: x_prev_max_disp_line_num OUT NOCOPY NUMBER
3332: ) IS
3333:
3334: l_curr_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3335: l_curr_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3336: l_prev_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3337: l_prev_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3338:

Line 3335: l_curr_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;

3331: x_prev_max_disp_line_num OUT NOCOPY NUMBER
3332: ) IS
3333:
3334: l_curr_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3335: l_curr_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3336: l_prev_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3337: l_prev_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3338:
3339: BEGIN

Line 3336: l_prev_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;

3332: ) IS
3333:
3334: l_curr_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3335: l_curr_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3336: l_prev_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3337: l_prev_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3338:
3339: BEGIN
3340:

Line 3337: l_prev_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;

3333:
3334: l_curr_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3335: l_curr_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3336: l_prev_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3337: l_prev_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3338:
3339: BEGIN
3340:
3341: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 3355: FROM PON_AUCTION_ITEM_PRICES_ALL

3351: --that have SUB_LINE_SEQUENCE_NUMBER < p_value
3352:
3353: SELECT MAX(DISP_LINE_NUMBER)
3354: INTO x_curr_max_disp_line_num
3355: FROM PON_AUCTION_ITEM_PRICES_ALL
3356: WHERE AUCTION_HEADER_ID = p_curr_auction_header_id
3357: AND GROUP_TYPE IN ('LOT', 'LINE', 'GROUP')
3358: AND SUB_LINE_SEQUENCE_NUMBER < p_value;
3359:

Line 3362: FROM PON_AUCTION_ITEM_PRICES_ALL

3358: AND SUB_LINE_SEQUENCE_NUMBER < p_value;
3359:
3360: SELECT MAX(DISP_LINE_NUMBER)
3361: INTO x_prev_max_disp_line_num
3362: FROM PON_AUCTION_ITEM_PRICES_ALL
3363: WHERE AUCTION_HEADER_ID = p_prev_auction_header_id
3364: AND GROUP_TYPE IN ('LOT', 'LINE', 'GROUP')
3365: AND SUB_LINE_SEQUENCE_NUMBER < p_value;
3366:

Line 3387: FROM PON_AUCTION_ITEM_PRICES_ALL

3383: END IF;
3384:
3385: SELECT GROUP_TYPE, LINE_NUMBER
3386: INTO l_curr_group_type, l_curr_line_number
3387: FROM PON_AUCTION_ITEM_PRICES_ALL
3388: WHERE AUCTION_HEADER_ID = p_curr_auction_header_id
3389: AND DISP_LINE_NUMBER = x_curr_max_disp_line_num;
3390:
3391: SELECT GROUP_TYPE, LINE_NUMBER

Line 3393: FROM PON_AUCTION_ITEM_PRICES_ALL

3389: AND DISP_LINE_NUMBER = x_curr_max_disp_line_num;
3390:
3391: SELECT GROUP_TYPE, LINE_NUMBER
3392: INTO l_prev_group_type, l_prev_line_number
3393: FROM PON_AUCTION_ITEM_PRICES_ALL
3394: WHERE AUCTION_HEADER_ID = p_prev_auction_header_id
3395: AND DISP_LINE_NUMBER = x_prev_max_disp_line_num;
3396:
3397: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 3413: FROM PON_AUCTION_ITEM_PRICES_ALL

3409:
3410: IF (l_curr_group_type <> 'LINE') THEN
3411: SELECT NVL (MAX(DISP_LINE_NUMBER), x_curr_max_disp_line_num)
3412: INTO x_curr_max_disp_line_num
3413: FROM PON_AUCTION_ITEM_PRICES_ALL
3414: WHERE AUCTION_HEADER_ID = p_curr_auction_header_id
3415: AND PARENT_LINE_NUMBER = l_curr_line_number;
3416: END IF;
3417:

Line 3421: FROM PON_AUCTION_ITEM_PRICES_ALL

3417:
3418: IF (l_prev_group_type <> 'LINE') THEN
3419: SELECT NVL (MAX(DISP_LINE_NUMBER), x_prev_max_disp_line_num)
3420: INTO x_prev_max_disp_line_num
3421: FROM PON_AUCTION_ITEM_PRICES_ALL
3422: WHERE AUCTION_HEADER_ID = p_prev_auction_header_id
3423: AND PARENT_LINE_NUMBER = l_prev_line_number;
3424: END IF;
3425:

Line 3612: FROM pon_auction_item_prices_all WHERE auction_header_id = p_auction_header_id;

3608: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
3609:
3610: SELECT max(disp_line_number)
3611: INTO l_max_line_number
3612: FROM pon_auction_item_prices_all WHERE auction_header_id = p_auction_header_id;
3613:
3614: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3615: FND_LOG.string(log_level => FND_LOG.level_statement,
3616: module => g_module_prefix || 'UPDATE_STAG_LINES_CLOSE_DATES',

Line 3634: from pon_auction_item_prices_all

3630: END IF;
3631:
3632: select nvl (max(close_bidding_date), p_first_line_close_date)
3633: into x_last_line_close_date
3634: from pon_auction_item_prices_all
3635: where auction_header_id = p_auction_header_id;
3636:
3637: return;
3638: END IF; --}

Line 3645: from pon_auction_item_prices_all

3641: l_stag_interval := p_staggered_closing_interval/1440;
3642:
3643: select nvl (max(close_bidding_date), (p_first_line_close_date - l_stag_interval))
3644: into l_curr_close_date
3645: from pon_auction_item_prices_all
3646: where auction_header_id = p_auction_header_id
3647: and disp_line_number < p_start_disp_line_number;
3648:
3649: --we offset the current close date back by the staggered interval

Line 3695: from pon_auction_item_prices_all

3691:
3692: select line_number, close_bidding_date, group_type
3693: bulk collect into
3694: l_line_number, l_close_date, l_group_type
3695: from pon_auction_item_prices_all
3696: WHERE auction_header_id = p_auction_header_id
3697: AND disp_line_number >= l_batch_start
3698: AND disp_line_number <= l_batch_end
3699: order by disp_line_number;

Line 3724: ||'; now bulk updating the PON_AUCTION_ITEM_PRICES_ALL'

3720: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3721: FND_LOG.string(log_level => FND_LOG.level_statement,
3722: module => g_module_prefix || 'UPDATE_STAG_LINES_CLOSE_DATES',
3723: message => 'Last close date for this batch is x_last_line_close_date : ' || to_char (x_last_line_close_date, 'dd-mon-yyyy hh24:mi:ss')
3724: ||'; now bulk updating the PON_AUCTION_ITEM_PRICES_ALL'
3725: );
3726: END IF;
3727:
3728: FORALL x IN 1..l_line_number.COUNT

Line 3729: UPDATE PON_AUCTION_ITEM_PRICES_ALL

3725: );
3726: END IF;
3727:
3728: FORALL x IN 1..l_line_number.COUNT
3729: UPDATE PON_AUCTION_ITEM_PRICES_ALL
3730: set close_bidding_date = l_close_date(x)
3731: WHERE auction_header_id = p_auction_header_id
3732: AND line_number = l_line_number(x);
3733:

Line 3810: FROM pon_auction_item_prices_all

3806: END IF;
3807:
3808:
3809: SELECT Count(1) into l_lines_lots_groups_count
3810: FROM pon_auction_item_prices_all
3811: WHERE group_type IN ('LINE', 'LOT', 'GROUP')
3812: AND auction_header_id = p_auction_header_id;
3813:
3814: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN

Line 4062: FROM PON_AUCTION_ITEM_PRICES_ALL

4058: -- retrieve the maximum line number present for the auction
4059: --
4060: SELECT MAX(LINE_NUMBER)
4061: INTO l_max_line_number
4062: FROM PON_AUCTION_ITEM_PRICES_ALL
4063: WHERE AUCTION_HEADER_ID=p_auction_header_id;
4064:
4065: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
4066: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 4152: message => 'Price tier indicator has chnaged from ' || l_prev_price_tiers_indicator ||' ; updating the pon_auction_item_prices_all, setting price_break_type to NONE and price_break_neg_flag to Y');

4148:
4149: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
4150: FND_LOG.string(log_level => FND_LOG.level_statement,
4151: module => g_module_prefix || l_module_name,
4152: message => 'Price tier indicator has chnaged from ' || l_prev_price_tiers_indicator ||' ; updating the pon_auction_item_prices_all, setting price_break_type to NONE and price_break_neg_flag to Y');
4153: END IF;
4154:
4155: UPDATE pon_auction_item_prices_all
4156: SET price_break_type = 'NONE',

Line 4155: UPDATE pon_auction_item_prices_all

4151: module => g_module_prefix || l_module_name,
4152: message => 'Price tier indicator has chnaged from ' || l_prev_price_tiers_indicator ||' ; updating the pon_auction_item_prices_all, setting price_break_type to NONE and price_break_neg_flag to Y');
4153: END IF;
4154:
4155: UPDATE pon_auction_item_prices_all
4156: SET price_break_type = 'NONE',
4157: price_break_neg_flag = 'Y'
4158: WHERE auction_header_id = p_auction_header_id
4159: AND line_number >= l_batch_start

Line 4226: UPDATE pon_auction_item_prices_all

4222: --Only those lines which were present in previous round or previous
4223: --amendment we need to set the modified_flag.
4224: --
4225:
4226: UPDATE pon_auction_item_prices_all
4227: SET has_quantity_tiers = 'N',
4228: has_shipments_flag = 'N',
4229: modified_flag = decode(least(line_number,l_parent_auc_max_line_number),
4230: line_number,'Y', modified_flag),

Line 4246: UPDATE pon_auction_item_prices_all

4242: module => g_module_prefix || l_module_name,
4243: message => 'Negotiation is a not new round or an amendment. Updating has_quantity_tiers flag');
4244: END IF;
4245:
4246: UPDATE pon_auction_item_prices_all
4247: SET has_quantity_tiers = 'N',
4248: has_shipments_flag = 'N'
4249: WHERE
4250: auction_header_id = p_auction_header_id AND