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 1371: FROM pon_auction_item_prices_all

1367: paha.doctype_id = pad.doctype_id;
1368:
1369: SELECT NVL (MAX (line_number), 0)
1370: INTO l_max_line_number
1371: FROM pon_auction_item_prices_all
1372: where auction_header_id = p_auction_header_id;
1373:
1374: -- Get the batch size
1375: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

Line 1419: x_entity_name =>'PON_AUCTION_ITEM_PRICES_ALL',

1415: --Delete Attachments
1416: FOR attachment_line IN lines_with_attachements LOOP
1417:
1418: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
1419: x_entity_name =>'PON_AUCTION_ITEM_PRICES_ALL',
1420: x_pk1_value => p_auction_header_id,
1421: x_pk2_value => attachment_line.line_number,
1422: x_pk3_value => NULL,
1423: x_pk4_value => NULL,

Line 1641: pon_auction_item_prices_all

1637: END IF;
1638:
1639: -- Delete the entries for lines
1640: DELETE FROM
1641: pon_auction_item_prices_all
1642: WHERE
1643: auction_header_id = p_auction_header_id AND
1644: line_number >= l_batch_start AND
1645: line_number <= l_batch_end;

Line 1795: pon_auction_item_prices_all paip

1791: SELECT
1792: DISTINCT (TO_NUMBER(fad.pk2_value)) line_number
1793: FROM
1794: fnd_attached_documents fad,
1795: pon_auction_item_prices_all paip
1796: WHERE
1797: fad.entity_name = 'PON_AUCTION_ITEM_PRICES_ALL' AND
1798: fad.pk1_value = TO_CHAR(p_auction_header_id) AND
1799: paip.auction_header_id = p_auction_header_id AND

Line 1797: fad.entity_name = 'PON_AUCTION_ITEM_PRICES_ALL' AND

1793: FROM
1794: fnd_attached_documents fad,
1795: pon_auction_item_prices_all paip
1796: WHERE
1797: fad.entity_name = 'PON_AUCTION_ITEM_PRICES_ALL' AND
1798: fad.pk1_value = TO_CHAR(p_auction_header_id) AND
1799: paip.auction_header_id = p_auction_header_id AND
1800: fad.pk2_value = paip.line_number AND
1801: (paip.line_number = p_line_number OR paip.parent_line_number = p_line_number);

Line 1809: pon_auction_item_prices_all

1805: CURSOR lines_with_backing_requisition IS
1806: SELECT
1807: line_number, org_id
1808: FROM
1809: pon_auction_item_prices_all
1810: WHERE
1811: auction_header_id = p_auction_header_id AND
1812: (line_number = p_line_number OR parent_line_number = p_line_number) AND
1813: requisition_number IS NOT NULL;

Line 1822: pon_auction_item_prices_all paip

1818: SELECT
1819: DISTINCT (TO_NUMBER(fad.pk2_value)) line_number
1820: FROM
1821: fnd_attached_documents fad,
1822: pon_auction_item_prices_all paip
1823: WHERE
1824: fad.entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS' AND
1825: fad.pk1_value = TO_CHAR(p_auction_header_id) AND
1826: paip.auction_header_id = p_auction_header_id AND

Line 1932: pon_auction_item_prices_all

1928: line_number
1929: INTO
1930: l_line_number
1931: FROM
1932: pon_auction_item_prices_all
1933: WHERE
1934: auction_header_id = p_auction_header_id and
1935: line_number = p_line_number;
1936:

Line 2074: pon_auction_item_prices_all

2070: message => 'Deleted the entry in PON_PARTY_LINE_EXCLUSIONS');
2071: END IF;
2072:
2073: DELETE FROM
2074: pon_auction_item_prices_all
2075: WHERE
2076: auction_header_id = p_auction_header_id AND
2077: line_number = p_line_number;
2078:

Line 2115: x_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

2111:
2112: END IF;
2113:
2114: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
2115: x_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2116: x_pk1_value => p_auction_header_id,
2117: x_pk2_value => p_line_number);
2118:
2119: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2151: pon_auction_item_prices_all

2147: IF (p_group_type IN ('LOT_LINE', 'GROUP_LINE') AND
2148: l_amendment_number > 0 AND
2149: p_sub_line_sequence_number <= l_header_max_document_line_num) THEN
2150: UPDATE
2151: pon_auction_item_prices_all
2152: SET
2153: modified_flag = 'Y',
2154: modified_date = sysdate,
2155: last_amendment_update = l_amendment_number

Line 2166: PON_AUCTION_ITEM_PRICES_ALL

2162: IF (p_group_type IN ('LOT_LINE', 'GROUP_LINE') AND
2163: l_auction_round_number > 1 AND
2164: p_sub_line_sequence_number <= l_header_max_document_line_num) THEN
2165: UPDATE
2166: PON_AUCTION_ITEM_PRICES_ALL
2167: SET
2168: MODIFIED_FLAG = 'Y',
2169: MODIFIED_DATE = SYSDATE
2170: WHERE

Line 2186: pon_auction_item_prices_all

2182: count(line_number)
2183: INTO
2184: x_number_of_lines_deleted
2185: FROM
2186: pon_auction_item_prices_all
2187: WHERE
2188: auction_header_id = p_auction_header_id AND
2189: (line_number = p_line_number OR parent_line_number = p_line_number);
2190:

Line 2222: pon_auction_item_prices_all paip

2218: (
2219: SELECT
2220: paip.line_number
2221: FROM
2222: pon_auction_item_prices_all paip
2223: WHERE
2224: paip.parent_line_number = p_line_number AND
2225: paip.auction_header_id = p_auction_header_id AND
2226: paip.line_number = pas.line_number

Line 2245: pon_auction_item_prices_all paip

2241: (
2242: SELECT
2243: paip.line_number
2244: FROM
2245: pon_auction_item_prices_all paip
2246: WHERE
2247: paip.parent_line_number = p_line_number AND
2248: paip.auction_header_id = p_auction_header_id AND
2249: paip.line_number = paa.line_number

Line 2279: pon_auction_item_prices_all paip

2275: (
2276: SELECT
2277: paip.line_number
2278: FROM
2279: pon_auction_item_prices_all paip
2280: WHERE
2281: paip.parent_line_number = p_line_number AND
2282: paip.auction_header_id = p_auction_header_id AND
2283: paip.line_number = ppsv.line_number

Line 2300: pon_auction_item_prices_all paip

2296: (
2297: SELECT
2298: paip.line_number
2299: FROM
2300: pon_auction_item_prices_all paip
2301: WHERE
2302: paip.parent_line_number = p_line_number AND
2303: paip.auction_header_id = p_auction_header_id AND
2304: paip.line_number = ppe.line_number

Line 2350: pon_auction_item_prices_all paip

2346: (
2347: SELECT
2348: paip.line_number
2349: FROM
2350: pon_auction_item_prices_all paip
2351: WHERE
2352: paip.parent_line_number = p_line_number AND
2353: paip.auction_header_id = p_auction_header_id AND
2354: paip.line_number = paps.line_number

Line 2395: pon_auction_item_prices_all paip

2391: (
2392: SELECT
2393: paip.line_number
2394: FROM
2395: pon_auction_item_prices_all paip
2396: WHERE
2397: paip.parent_line_number = p_line_number AND
2398: paip.auction_header_id = p_auction_header_id AND
2399: paip.line_number = pasa.line_number

Line 2435: pon_auction_item_prices_all paip

2431: (
2432: SELECT
2433: paip.line_number
2434: FROM
2435: pon_auction_item_prices_all paip
2436: WHERE
2437: paip.parent_line_number = p_line_number AND
2438: paip.auction_header_id = p_auction_header_id AND
2439: paip.line_number = ppd.line_number

Line 2467: pon_auction_item_prices_all paip

2463: (
2464: SELECT
2465: paip.line_number
2466: FROM
2467: pon_auction_item_prices_all paip
2468: WHERE
2469: paip.parent_line_number = p_line_number AND
2470: paip.auction_header_id = p_auction_header_id AND
2471: paip.line_number = pple.line_number

Line 2486: x_entity_name =>'PON_AUCTION_ITEM_PRICES_ALL',

2482: --Delete Attachments
2483: FOR attachment_line IN lines_with_attachements LOOP
2484:
2485: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
2486: x_entity_name =>'PON_AUCTION_ITEM_PRICES_ALL',
2487: x_pk1_value => p_auction_header_id,
2488: x_pk2_value => attachment_line.line_number,
2489: x_pk3_value => NULL,
2490: x_pk4_value => NULL,

Line 2549: pon_auction_item_prices_all

2545: END IF;
2546:
2547: -- Finally delete the lines
2548: DELETE FROM
2549: pon_auction_item_prices_all
2550: WHERE
2551: auction_header_id = p_auction_header_id AND
2552: (line_number = p_line_number OR parent_line_number = p_line_number);
2553:

Line 2726: PON_AUCTION_ITEM_PRICES_ALL

2722: LINE_NUMBER
2723: BULK COLLECT INTO
2724: l_line_number
2725: FROM
2726: PON_AUCTION_ITEM_PRICES_ALL
2727: WHERE
2728: AUCTION_HEADER_ID = p_auction_header_id AND
2729: GROUP_TYPE IN ('LOT', 'GROUP', 'LINE') AND
2730: SUB_LINE_SEQUENCE_NUMBER > l_max_document_line_num AND

Line 2764: PON_AUCTION_ITEM_PRICES_ALL

2760: NVL (MAX (SUB_LINE_SEQUENCE_NUMBER), 0)
2761: INTO
2762: l_max_sub_line_sequence_number
2763: FROM
2764: PON_AUCTION_ITEM_PRICES_ALL
2765: WHERE
2766: AUCTION_HEADER_ID = p_auction_header_id AND
2767: DISP_LINE_NUMBER < p_min_disp_line_number_parent AND
2768: GROUP_TYPE IN ('LINE','LOT', 'GROUP');

Line 2809: PON_AUCTION_ITEM_PRICES_ALL

2805:
2806: --UPDATE THE LINES, LOTS AND GROUPS WITH THE NEW VALUES
2807: FORALL x in 1..l_line_number.COUNT
2808: UPDATE
2809: PON_AUCTION_ITEM_PRICES_ALL
2810: SET
2811: SUB_LINE_SEQUENCE_NUMBER = l_sub_line_seq_number (x),
2812: DOCUMENT_DISP_LINE_NUMBER = l_sub_line_seq_number (x),
2813: LAST_UPDATE_DATE = SYSDATE,

Line 2842: PON_AUCTION_ITEM_PRICES_ALL CHILDREN,

2838: l_parent_max_sub_line_seq_num,
2839: l_parent_line_number,
2840: l_parent_doc_disp_line_number
2841: FROM
2842: PON_AUCTION_ITEM_PRICES_ALL CHILDREN,
2843: PON_AUCTION_ITEM_PRICES_ALL PARENT
2844: WHERE
2845: CHILDREN.AUCTION_HEADER_ID = p_auction_header_id AND
2846: PARENT.AUCTION_HEADER_ID = p_auction_header_id AND

Line 2843: PON_AUCTION_ITEM_PRICES_ALL PARENT

2839: l_parent_line_number,
2840: l_parent_doc_disp_line_number
2841: FROM
2842: PON_AUCTION_ITEM_PRICES_ALL CHILDREN,
2843: PON_AUCTION_ITEM_PRICES_ALL PARENT
2844: WHERE
2845: CHILDREN.AUCTION_HEADER_ID = p_auction_header_id AND
2846: PARENT.AUCTION_HEADER_ID = p_auction_header_id AND
2847: PARENT.LINE_NUMBER = CHILDREN.PARENT_LINE_NUMBER AND

Line 2885: PON_AUCTION_ITEM_PRICES_ALL

2881: NVL (MAX (SUB_LINE_SEQUENCE_NUMBER), 0)
2882: INTO
2883: l_current_max_sub_line_seq
2884: FROM
2885: PON_AUCTION_ITEM_PRICES_ALL
2886: WHERE
2887: AUCTION_HEADER_ID = p_auction_header_id AND
2888: PARENT_LINE_NUMBER = p_min_child_parent_line_num AND
2889: DISP_LINE_NUMBER < p_min_disp_line_number_child;

Line 2955: UPDATE PON_AUCTION_ITEM_PRICES_ALL

2951: END LOOP;
2952:
2953: --UPDATE THE LOT_LINES AND GROUP_LINES WITH THE NEW VALUES
2954: FORALL x in 1..l_line_number.COUNT
2955: UPDATE PON_AUCTION_ITEM_PRICES_ALL
2956: SET
2957: SUB_LINE_SEQUENCE_NUMBER = l_sub_line_seq_number (x),
2958: DOCUMENT_DISP_LINE_NUMBER = l_document_disp_line_number (x),
2959: LAST_UPDATE_DATE = SYSDATE,

Line 2992: PON_AUCTION_ITEM_PRICES_ALL

2988: LINE_NUMBER
2989: BULK COLLECT INTO
2990: l_line_number
2991: FROM
2992: PON_AUCTION_ITEM_PRICES_ALL
2993: WHERE
2994: AUCTION_HEADER_ID = p_auction_header_id AND
2995: DISP_LINE_NUMBER > l_min_disp_line_number
2996: ORDER BY

Line 3019: pon_auction_item_prices_all

3015: MAX(sub_line_sequence_number)
3016: INTO
3017: l_temp_char
3018: FROM
3019: pon_auction_item_prices_all
3020: WHERE
3021: auction_header_id = p_auction_header_id and
3022: group_type IN ('LOT', 'LINE', 'GROUP');
3023:

Line 3063: UPDATE PON_AUCTION_ITEM_PRICES_ALL

3059: END IF;
3060:
3061: --BULK UPDATE TO SET THE NEW DISP_LINE_NUMBER
3062: FORALL x IN 1..l_line_number.COUNT
3063: UPDATE PON_AUCTION_ITEM_PRICES_ALL
3064: SET DISP_LINE_NUMBER = l_new_disp_line_number (x)
3065: WHERE LINE_NUMBER = l_line_number(x)
3066: AND AUCTION_HEADER_ID = p_auction_header_id;
3067:

Line 3075: pon_auction_item_prices_all

3071: MAX(sub_line_sequence_number)
3072: INTO
3073: x_last_line_number
3074: FROM
3075: pon_auction_item_prices_all
3076: WHERE
3077: auction_header_id = p_auction_header_id and
3078: group_type IN ('LOT', 'LINE', 'GROUP');
3079:

Line 3142: FROM PON_AUCTION_ITEM_PRICES_ALL

3138: --that have SUB_LINE_SEQUENCE_NUMBER > p_value
3139:
3140: SELECT MIN(disp_line_number)
3141: INTO x_curr_min_disp_line_num
3142: FROM PON_AUCTION_ITEM_PRICES_ALL
3143: WHERE AUCTION_HEADER_ID = p_curr_auction_header_id
3144: AND GROUP_TYPE IN ('LOT', 'GROUP', 'LINE')
3145: AND SUB_LINE_SEQUENCE_NUMBER > p_value;
3146:

Line 3149: FROM PON_AUCTION_ITEM_PRICES_ALL

3145: AND SUB_LINE_SEQUENCE_NUMBER > p_value;
3146:
3147: SELECT MIN(disp_line_number)
3148: INTO x_prev_min_disp_line_num
3149: FROM PON_AUCTION_ITEM_PRICES_ALL
3150: WHERE AUCTION_HEADER_ID = p_prev_auction_header_id
3151: AND GROUP_TYPE IN ('LOT', 'GROUP', 'LINE')
3152: AND SUB_LINE_SEQUENCE_NUMBER > p_value;
3153:

Line 3190: l_curr_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;

3186: x_curr_max_disp_line_num OUT NOCOPY NUMBER,
3187: x_prev_max_disp_line_num OUT NOCOPY NUMBER
3188: ) IS
3189:
3190: l_curr_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3191: l_curr_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3192: l_prev_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3193: l_prev_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3194:

Line 3191: l_curr_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;

3187: x_prev_max_disp_line_num OUT NOCOPY NUMBER
3188: ) IS
3189:
3190: l_curr_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3191: l_curr_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3192: l_prev_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3193: l_prev_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3194:
3195: BEGIN

Line 3192: l_prev_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;

3188: ) IS
3189:
3190: l_curr_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3191: l_curr_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3192: l_prev_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3193: l_prev_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3194:
3195: BEGIN
3196:

Line 3193: l_prev_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;

3189:
3190: l_curr_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3191: l_curr_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3192: l_prev_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
3193: l_prev_group_type PON_AUCTION_ITEM_PRICES_ALL.GROUP_TYPE%TYPE;
3194:
3195: BEGIN
3196:
3197: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 3211: FROM PON_AUCTION_ITEM_PRICES_ALL

3207: --that have SUB_LINE_SEQUENCE_NUMBER < p_value
3208:
3209: SELECT MAX(DISP_LINE_NUMBER)
3210: INTO x_curr_max_disp_line_num
3211: FROM PON_AUCTION_ITEM_PRICES_ALL
3212: WHERE AUCTION_HEADER_ID = p_curr_auction_header_id
3213: AND GROUP_TYPE IN ('LOT', 'LINE', 'GROUP')
3214: AND SUB_LINE_SEQUENCE_NUMBER < p_value;
3215:

Line 3218: FROM PON_AUCTION_ITEM_PRICES_ALL

3214: AND SUB_LINE_SEQUENCE_NUMBER < p_value;
3215:
3216: SELECT MAX(DISP_LINE_NUMBER)
3217: INTO x_prev_max_disp_line_num
3218: FROM PON_AUCTION_ITEM_PRICES_ALL
3219: WHERE AUCTION_HEADER_ID = p_prev_auction_header_id
3220: AND GROUP_TYPE IN ('LOT', 'LINE', 'GROUP')
3221: AND SUB_LINE_SEQUENCE_NUMBER < p_value;
3222:

Line 3243: FROM PON_AUCTION_ITEM_PRICES_ALL

3239: END IF;
3240:
3241: SELECT GROUP_TYPE, LINE_NUMBER
3242: INTO l_curr_group_type, l_curr_line_number
3243: FROM PON_AUCTION_ITEM_PRICES_ALL
3244: WHERE AUCTION_HEADER_ID = p_curr_auction_header_id
3245: AND DISP_LINE_NUMBER = x_curr_max_disp_line_num;
3246:
3247: SELECT GROUP_TYPE, LINE_NUMBER

Line 3249: FROM PON_AUCTION_ITEM_PRICES_ALL

3245: AND DISP_LINE_NUMBER = x_curr_max_disp_line_num;
3246:
3247: SELECT GROUP_TYPE, LINE_NUMBER
3248: INTO l_prev_group_type, l_prev_line_number
3249: FROM PON_AUCTION_ITEM_PRICES_ALL
3250: WHERE AUCTION_HEADER_ID = p_prev_auction_header_id
3251: AND DISP_LINE_NUMBER = x_prev_max_disp_line_num;
3252:
3253: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 3269: FROM PON_AUCTION_ITEM_PRICES_ALL

3265:
3266: IF (l_curr_group_type <> 'LINE') THEN
3267: SELECT NVL (MAX(DISP_LINE_NUMBER), x_curr_max_disp_line_num)
3268: INTO x_curr_max_disp_line_num
3269: FROM PON_AUCTION_ITEM_PRICES_ALL
3270: WHERE AUCTION_HEADER_ID = p_curr_auction_header_id
3271: AND PARENT_LINE_NUMBER = l_curr_line_number;
3272: END IF;
3273:

Line 3277: FROM PON_AUCTION_ITEM_PRICES_ALL

3273:
3274: IF (l_prev_group_type <> 'LINE') THEN
3275: SELECT NVL (MAX(DISP_LINE_NUMBER), x_prev_max_disp_line_num)
3276: INTO x_prev_max_disp_line_num
3277: FROM PON_AUCTION_ITEM_PRICES_ALL
3278: WHERE AUCTION_HEADER_ID = p_prev_auction_header_id
3279: AND PARENT_LINE_NUMBER = l_prev_line_number;
3280: END IF;
3281:

Line 3468: FROM pon_auction_item_prices_all WHERE auction_header_id = p_auction_header_id;

3464: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
3465:
3466: SELECT max(disp_line_number)
3467: INTO l_max_line_number
3468: FROM pon_auction_item_prices_all WHERE auction_header_id = p_auction_header_id;
3469:
3470: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3471: FND_LOG.string(log_level => FND_LOG.level_statement,
3472: module => g_module_prefix || 'UPDATE_STAG_LINES_CLOSE_DATES',

Line 3490: from pon_auction_item_prices_all

3486: END IF;
3487:
3488: select nvl (max(close_bidding_date), p_first_line_close_date)
3489: into x_last_line_close_date
3490: from pon_auction_item_prices_all
3491: where auction_header_id = p_auction_header_id;
3492:
3493: return;
3494: END IF; --}

Line 3501: from pon_auction_item_prices_all

3497: l_stag_interval := p_staggered_closing_interval/1440;
3498:
3499: select nvl (max(close_bidding_date), (p_first_line_close_date - l_stag_interval))
3500: into l_curr_close_date
3501: from pon_auction_item_prices_all
3502: where auction_header_id = p_auction_header_id
3503: and disp_line_number < p_start_disp_line_number;
3504:
3505: --we offset the current close date back by the staggered interval

Line 3551: from pon_auction_item_prices_all

3547:
3548: select line_number, close_bidding_date, group_type
3549: bulk collect into
3550: l_line_number, l_close_date, l_group_type
3551: from pon_auction_item_prices_all
3552: WHERE auction_header_id = p_auction_header_id
3553: AND disp_line_number >= l_batch_start
3554: AND disp_line_number <= l_batch_end
3555: order by disp_line_number;

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

3576: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3577: FND_LOG.string(log_level => FND_LOG.level_statement,
3578: module => g_module_prefix || 'UPDATE_STAG_LINES_CLOSE_DATES',
3579: 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')
3580: ||'; now bulk updating the PON_AUCTION_ITEM_PRICES_ALL'
3581: );
3582: END IF;
3583:
3584: FORALL x IN 1..l_line_number.COUNT

Line 3585: UPDATE PON_AUCTION_ITEM_PRICES_ALL

3581: );
3582: END IF;
3583:
3584: FORALL x IN 1..l_line_number.COUNT
3585: UPDATE PON_AUCTION_ITEM_PRICES_ALL
3586: set close_bidding_date = l_close_date(x)
3587: WHERE auction_header_id = p_auction_header_id
3588: AND line_number = l_line_number(x);
3589:

Line 3666: FROM pon_auction_item_prices_all

3662: END IF;
3663:
3664:
3665: SELECT Count(1) into l_lines_lots_groups_count
3666: FROM pon_auction_item_prices_all
3667: WHERE group_type IN ('LINE', 'LOT', 'GROUP')
3668: AND auction_header_id = p_auction_header_id;
3669:
3670: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN

Line 3918: FROM PON_AUCTION_ITEM_PRICES_ALL

3914: -- retrieve the maximum line number present for the auction
3915: --
3916: SELECT MAX(LINE_NUMBER)
3917: INTO l_max_line_number
3918: FROM PON_AUCTION_ITEM_PRICES_ALL
3919: WHERE AUCTION_HEADER_ID=p_auction_header_id;
3920:
3921: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3922: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 4008: 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');

4004:
4005: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
4006: FND_LOG.string(log_level => FND_LOG.level_statement,
4007: module => g_module_prefix || l_module_name,
4008: 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');
4009: END IF;
4010:
4011: UPDATE pon_auction_item_prices_all
4012: SET price_break_type = 'NONE',

Line 4011: UPDATE pon_auction_item_prices_all

4007: module => g_module_prefix || l_module_name,
4008: 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');
4009: END IF;
4010:
4011: UPDATE pon_auction_item_prices_all
4012: SET price_break_type = 'NONE',
4013: price_break_neg_flag = 'Y'
4014: WHERE auction_header_id = p_auction_header_id
4015: AND line_number >= l_batch_start

Line 4082: UPDATE pon_auction_item_prices_all

4078: --Only those lines which were present in previous round or previous
4079: --amendment we need to set the modified_flag.
4080: --
4081:
4082: UPDATE pon_auction_item_prices_all
4083: SET has_quantity_tiers = 'N',
4084: has_shipments_flag = 'N',
4085: modified_flag = decode(least(line_number,l_parent_auc_max_line_number),
4086: line_number,'Y', modified_flag),

Line 4102: UPDATE pon_auction_item_prices_all

4098: module => g_module_prefix || l_module_name,
4099: message => 'Negotiation is a not new round or an amendment. Updating has_quantity_tiers flag');
4100: END IF;
4101:
4102: UPDATE pon_auction_item_prices_all
4103: SET has_quantity_tiers = 'N',
4104: has_shipments_flag = 'N'
4105: WHERE
4106: auction_header_id = p_auction_header_id AND