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

Line 70: FROM pon_auction_item_prices_all

66: sub_line_sequence_number,
67: clm_base_line_num,
68: line_num_display,
69: clm_option_indicator
70: FROM pon_auction_item_prices_all
71: WHERE auction_header_id =p_auction_header_id
72: AND (line_number = p_line_number
73: OR clm_base_line_num = p_line_number);
74:

Line 84: FROM pon_auction_item_prices_all

80: org_id,
81: parent_line_number,
82: sub_line_sequence_number,
83: clm_option_indicator
84: FROM pon_auction_item_prices_all
85: WHERE auction_header_id =p_auction_header_id
86: AND group_line_id = i_parent_line;
87:
88: CURSOR CrossLinkedOptionLines(i_base_line_num NUMBER) IS

Line 97: FROM pon_auction_item_prices_all

93: org_id,
94: parent_line_number,
95: sub_line_sequence_number,
96: clm_option_indicator
97: FROM pon_auction_item_prices_all
98: WHERE auction_header_id =p_auction_header_id
99: AND clm_base_line_num = i_base_line_num;
100:
101: CURSOR OptionsForRenum(i_parent_line NUMBER) IS

Line 106: FROM pon_auction_item_prices_all

102: SELECT
103: ROWNUM AS rownumber,
104: auction_header_id,
105: line_number
106: FROM pon_auction_item_prices_all
107: WHERE auction_header_id = p_auction_header_id
108: AND clm_base_line_num = i_parent_line;
109:
110:

Line 154: UPDATE pon_auction_item_prices_all

150:
151: IF(p_delete_linked_option <> 'Y') THEN
152: --If linked option lines are not to be deleted, then unlink them first so that they
153: -- will not get picked by the op_line cursor for deletion
154: UPDATE pon_auction_item_prices_all
155: SET clm_base_line_num = null,
156: clm_option_num = null
157: WHERE auction_header_id =p_auction_header_id
158: AND clm_base_line_num = p_line_number;

Line 204: UPDATE pon_auction_item_prices_all

200: END IF;
201: END LOOP;
202: ELSE
203: --Unlink the option lines
204: UPDATE pon_auction_item_prices_all
205: SET clm_base_line_num = null,
206: clm_option_num = null
207: WHERE auction_header_id =p_auction_header_id
208: AND clm_base_line_num = sl_line.line_number;

Line 290: UPDATE pon_auction_item_prices_all SET clm_option_num = options.rownumber

286: message => 'Renumbering options for ' || op_line.clm_base_line_num);
287: END IF;
288:
289: FOR options IN OptionsForRenum(op_line.clm_base_line_num) LOOP
290: UPDATE pon_auction_item_prices_all SET clm_option_num = options.rownumber
291: WHERE auction_header_id = p_auction_header_id
292: AND line_number = options.line_number;
293: opcount := opcount + 1;
294: END LOOP;

Line 297: UPDATE pon_auction_item_prices_all SET clm_option_indicator = NULL

293: opcount := opcount + 1;
294: END LOOP;
295:
296: IF (opcount = 0 ) THEN
297: UPDATE pon_auction_item_prices_all SET clm_option_indicator = NULL
298: WHERE auction_header_id = p_auction_header_id
299: AND line_number = op_line.clm_base_line_num;
300: END IF;
301: END IF;

Line 412: SELECT (Max(line_number) + 1) INTO l_new_line_number FROM pon_auction_item_prices_all

408: ', p_line_number = ' || p_src_line_number);
409: END IF;
410:
411: -- determine the new line number
412: SELECT (Max(line_number) + 1) INTO l_new_line_number FROM pon_auction_item_prices_all
413: WHERE auction_header_id = p_auction_header_id;
414:
415: SELECT group_line_id,clm_info_flag,Nvl2(group_line_id,'N','Y'),SubStr(line_num_display,1,4)
416: INTO l_new_group_line_id,l_info_flag,l_is_clin, l_clin_num

Line 417: FROM pon_auction_item_prices_all

413: WHERE auction_header_id = p_auction_header_id;
414:
415: SELECT group_line_id,clm_info_flag,Nvl2(group_line_id,'N','Y'),SubStr(line_num_display,1,4)
416: INTO l_new_group_line_id,l_info_flag,l_is_clin, l_clin_num
417: FROM pon_auction_item_prices_all
418: WHERE auction_header_id = p_auction_header_id
419: AND line_number = p_src_line_number;
420:
421: SELECT (Count(clm_option_num) + 1) INTO l_option_num FROM pon_auction_item_prices_all

Line 421: SELECT (Count(clm_option_num) + 1) INTO l_option_num FROM pon_auction_item_prices_all

417: FROM pon_auction_item_prices_all
418: WHERE auction_header_id = p_auction_header_id
419: AND line_number = p_src_line_number;
420:
421: SELECT (Count(clm_option_num) + 1) INTO l_option_num FROM pon_auction_item_prices_all
422: WHERE auction_header_id = p_auction_header_id
423: AND clm_base_line_num = p_src_line_number;
424:
425: SELECT fnd_global.user_id INTO l_user_id FROM dual;

Line 435: UPDATE pon_auction_item_prices_all

431: l_new_line_number,
432: l_new_group_line_id,
433: l_user_id);
434:
435: UPDATE pon_auction_item_prices_all
436: SET clm_option_Num = l_option_num,
437: clm_option_indicator = 'O',
438: clm_base_line_num = p_src_line_number
439: WHERE auction_header_id = p_auction_header_id

Line 442: UPDATE pon_auction_item_prices_all

438: clm_base_line_num = p_src_line_number
439: WHERE auction_header_id = p_auction_header_id
440: AND line_Number = l_new_line_number;
441:
442: UPDATE pon_auction_item_prices_all
443: SET clm_option_indicator = 'B'
444: WHERE auction_header_id = p_auction_header_id
445: AND line_Number = p_src_line_number;
446:

Line 452: UPDATE pon_auction_item_prices_all

448: IF (l_is_clin = 'Y') THEN
449:
450: l_line_num_disp := pon_clo_renumber_pkg.NEXT_CLIN_NUM_WRAPPER(p_auction_header_id,'PON');
451:
452: UPDATE pon_auction_item_prices_all
453: SET line_num_display = l_line_num_disp
454: WHERE auction_header_id = p_auction_header_id
455: AND line_Number = l_new_line_number;
456:

Line 527: l_clm_base_option pon_auction_item_prices_all.clm_option_indicator%TYPE;

523:
524: base_line_numbers numbers := numbers();
525: copied_base_line_numbers numbers := numbers();
526: len NUMBER;
527: l_clm_base_option pon_auction_item_prices_all.clm_option_indicator%TYPE;
528: l_clm_base_line pon_auction_item_prices_all.clm_base_line_num%TYPE;
529: l_next_option_num pon_auction_item_prices_all.clm_option_num%TYPE;
530: l_is_option_copy VARCHAR2(1);
531: l_new_group_line_id number;

Line 528: l_clm_base_line pon_auction_item_prices_all.clm_base_line_num%TYPE;

524: base_line_numbers numbers := numbers();
525: copied_base_line_numbers numbers := numbers();
526: len NUMBER;
527: l_clm_base_option pon_auction_item_prices_all.clm_option_indicator%TYPE;
528: l_clm_base_line pon_auction_item_prices_all.clm_base_line_num%TYPE;
529: l_next_option_num pon_auction_item_prices_all.clm_option_num%TYPE;
530: l_is_option_copy VARCHAR2(1);
531: l_new_group_line_id number;
532:

Line 529: l_next_option_num pon_auction_item_prices_all.clm_option_num%TYPE;

525: copied_base_line_numbers numbers := numbers();
526: len NUMBER;
527: l_clm_base_option pon_auction_item_prices_all.clm_option_indicator%TYPE;
528: l_clm_base_line pon_auction_item_prices_all.clm_base_line_num%TYPE;
529: l_next_option_num pon_auction_item_prices_all.clm_option_num%TYPE;
530: l_is_option_copy VARCHAR2(1);
531: l_new_group_line_id number;
532:
533: l_new_clins numbers;

Line 553: FROM pon_auction_item_prices_all

549:
550: -- Changes for bug 10119899 start. First copy parent line before processing its options/slins.
551: -- following query selects given source line
552: SELECT line_number, clm_info_flag BULK COLLECT INTO l_line_numbers, l_info_flags
553: FROM pon_auction_item_prices_all
554: WHERE auction_header_id = p_auction_header_id
555: AND line_number = p_src_line_number;
556:
557: -- we will return x_max_line_number to the calling method so it will be used

Line 560: SELECT Max(line_number) INTO l_max_line_number FROM pon_auction_item_prices_all

556:
557: -- we will return x_max_line_number to the calling method so it will be used
558: -- in copying subsequent lines if user had selected more than one line to copy.
559: IF x_max_line_number IS NULL THEN
560: SELECT Max(line_number) INTO l_max_line_number FROM pon_auction_item_prices_all
561: WHERE auction_header_id = p_auction_header_id;
562: ELSE
563: l_max_line_number := x_max_line_number;
564: END IF;

Line 570: FROM pon_auction_item_prices_all

566: SELECT fnd_global.user_id INTO l_user_id FROM dual;
567:
568: -- check whether source line is a clin and whethere it is an option
569: SELECT Nvl2(group_line_id,'N','Y'),nvl(group_line_id,l_max_line_number+1), decode(Nvl(clm_option_indicator,'N'),'O','Y','N') INTO l_clin_flag,l_new_group_line_id,l_is_option_copy
570: FROM pon_auction_item_prices_all
571: WHERE auction_header_id = p_auction_header_id
572: AND line_number = p_src_line_number;
573:
574: IF l_clin_flag = 'Y' THEN

Line 578: SELECT SubStr(line_num_display,1,4) INTO l_clin_num FROM pon_auction_item_prices_all

574: IF l_clin_flag = 'Y' THEN
575: SELECT pon_clo_renumber_pkg.NEXT_CLIN_NUM_WRAPPER(p_auction_header_id,'PON') INTO l_clin_num FROM dual;
576:
577: ELSIF l_clin_flag = 'N' THEN
578: SELECT SubStr(line_num_display,1,4) INTO l_clin_num FROM pon_auction_item_prices_all
579: WHERE auctioN_header_id = p_auction_header_id
580: AND line_number = p_src_line_number;
581: END IF;
582:

Line 595: FROM pon_auction_item_prices_all

591:
592:
593: -- if current copied line is a base or option then, corresponding option num and base_line_num will have to be updated
594: SELECT clm_option_indicator, clm_base_line_num INTO l_clm_base_option, l_clm_base_line
595: FROM pon_auction_item_prices_all
596: WHERE auction_header_id = p_auction_header_id
597: AND line_number = l_line_number;
598:
599: IF (l_clm_base_option = 'B') THEN

Line 609: SELECT (Max(clm_option_num) + 1) INTO l_next_option_num FROM pon_auction_item_prices_all

605: base_line_numbers(len) := l_line_numbers(1);
606: copied_base_line_numbers(len) := l_line_number;
607: ELSIF (l_clm_base_option = 'O' AND l_is_option_copy = 'Y') THEN
608: -- if source line is optional line, we only need to update option number.
609: SELECT (Max(clm_option_num) + 1) INTO l_next_option_num FROM pon_auction_item_prices_all
610: WHERE auction_header_id = p_auction_header_id
611: AND clm_base_line_num = l_clm_base_line;
612:
613: UPDATE pon_auction_item_prices_all

Line 613: UPDATE pon_auction_item_prices_all

609: SELECT (Max(clm_option_num) + 1) INTO l_next_option_num FROM pon_auction_item_prices_all
610: WHERE auction_header_id = p_auction_header_id
611: AND clm_base_line_num = l_clm_base_line;
612:
613: UPDATE pon_auction_item_prices_all
614: SET clm_option_num = l_next_option_num
615: WHERE auction_header_id = p_auction_header_id
616: AND line_number = l_line_number;
617: END IF;

Line 621: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

617: END IF;
618:
619:
620: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
621: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
622: X_from_pk1_value => to_char(p_auction_header_id),
623: X_from_pk2_value => to_char(l_line_numbers(1)),
624: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
625: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE

Line 624: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

620: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
621: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
622: X_from_pk1_value => to_char(p_auction_header_id),
623: X_from_pk2_value => to_char(l_line_numbers(1)),
624: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
625: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
626: X_to_pk2_value => to_char(l_line_number),
627: X_created_by => l_user_id, -- CREATED_BY
628: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN

Line 671: FROM pon_auction_item_prices_all

667:
668: -- bug 10119899. After base line is copied now process slins and options
669: -- following query selects sub lines and options for the input source line
670: SELECT line_number, clm_info_flag BULK COLLECT INTO l_line_numbers, l_info_flags
671: FROM pon_auction_item_prices_all
672: WHERE auction_header_id = p_auction_header_id
673: AND (group_line_id = p_src_line_number
674: OR clm_base_line_num = p_src_line_number)
675: ORDER BY line_num_display;

Line 691: FROM pon_auction_item_prices_all

687:
688:
689: -- if current copied line is a base or option then, corresponding option num and base_line_num will have to be updated
690: SELECT clm_option_indicator, clm_base_line_num INTO l_clm_base_option, l_clm_base_line
691: FROM pon_auction_item_prices_all
692: WHERE auction_header_id = p_auction_header_id
693: AND line_number = l_line_number;
694:
695: IF (l_clm_base_option = 'B') THEN

Line 707: UPDATE pon_auction_item_prices_all

703: ELSIF (l_clm_base_option = 'O' AND l_is_option_copy <> 'Y') THEN
704: -- for copied optional lines, find the corresponding base line and update.
705: FOR i IN base_line_numbers.first..base_line_numbers.last LOOP
706: IF (base_line_numbers(i) = l_clm_base_line) THEN
707: UPDATE pon_auction_item_prices_all
708: SET CLM_BASE_LINE_NUM = copied_base_line_numbers(i)
709: WHERE auction_header_id = p_auction_header_id
710: AND line_number = l_line_number;
711: END IF;

Line 715: SELECT (Max(clm_option_num) + 1) INTO l_next_option_num FROM pon_auction_item_prices_all

711: END IF;
712: END LOOP;
713: ELSIF (l_clm_base_option = 'O' AND l_is_option_copy = 'Y') THEN
714: -- if source line is optional line, we only need to update option number.
715: SELECT (Max(clm_option_num) + 1) INTO l_next_option_num FROM pon_auction_item_prices_all
716: WHERE auction_header_id = p_auction_header_id
717: AND clm_base_line_num = l_clm_base_line;
718:
719: UPDATE pon_auction_item_prices_all

Line 719: UPDATE pon_auction_item_prices_all

715: SELECT (Max(clm_option_num) + 1) INTO l_next_option_num FROM pon_auction_item_prices_all
716: WHERE auction_header_id = p_auction_header_id
717: AND clm_base_line_num = l_clm_base_line;
718:
719: UPDATE pon_auction_item_prices_all
720: SET clm_option_num = l_next_option_num
721: WHERE auction_header_id = p_auction_header_id
722: AND line_number = l_line_number;
723: END IF;

Line 727: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

723: END IF;
724:
725:
726: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
727: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
728: X_from_pk1_value => to_char(p_auction_header_id),
729: X_from_pk2_value => to_char(l_line_numbers(i)),
730: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
731: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE

Line 730: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

726: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
727: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
728: X_from_pk1_value => to_char(p_auction_header_id),
729: X_from_pk2_value => to_char(l_line_numbers(i)),
730: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
731: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
732: X_to_pk2_value => to_char(l_line_number),
733: X_created_by => l_user_id, -- CREATED_BY
734: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN

Line 777: FROM pon_auction_item_prices_all

773:
774: BEGIN
775:
776: SELECT line_num_display BULK COLLECT INTO clin_num_tbl
777: FROM pon_auction_item_prices_all
778: WHERE auctioN_header_id = p_auction_header_id
779: AND group_line_id IS NULL
780: order by line_num_display;
781:

Line 792: FROM pon_auction_item_prices_all

788: next_clin_num := pon_clo_renumber_pkg.next_clin_num(clin_num_tbl);
789:
790: -- this query selects new copied clin and its optional clins if any
791: SELECT line_number BULK COLLECT INTO l_new_clins
792: FROM pon_auction_item_prices_all
793: WHERE auction_header_id = p_auction_header_id
794: AND line_number > l_max_line_Number
795: AND group_line_id IS NULL;
796: --ORDER BY line_number;

Line 800: UPDATE pon_auction_item_prices_all

796: --ORDER BY line_number;
797:
798: FOR i IN 1..l_new_clins.Count LOOP
799:
800: UPDATE pon_auction_item_prices_all
801: SET line_num_display = next_clin_num
802: WHERE auction_header_id = p_auction_header_id
803: AND line_number = l_new_clins(i);
804:

Line 815: /* UPDATE pon_auction_item_prices_all

811: next_clin_num := pon_clo_renumber_pkg.next_clin_num(clin_num_tbl);
812:
813: END LOOP;
814:
815: /* UPDATE pon_auction_item_prices_all
816: SET line_num_display = next_clin_num
817: WHERE auction_header_id = p_auction_header_id
818: AND line_number = l_max_line_Number + 1; -- this value would have been assigned to the new copied clin
819: */

Line 849: INSERT INTO pon_auction_item_prices_all

845: /* Bug 9787380
846: Added NEED BY DATE column to be copied when the new line is created
847: using copy action */
848:
849: INSERT INTO pon_auction_item_prices_all
850: (AUCTION_HEADER_ID,
851: --AWARD_STATUS,
852: LINE_NUMBER,
853: ITEM_DESCRIPTION,

Line 1150: FROM pon_auction_item_prices_all

1146: CLM_IDC_TYPE,
1147: CLM_AMOUNT,
1148: CLM_NEED_BY_DATE,
1149: EXHIBIT_NUMBER
1150: FROM pon_auction_item_prices_all
1151: WHERE auction_header_id = p_auction_header_id
1152: AND line_number = p_src_line_number;
1153:
1154: --Invoke UDA Copy for Line

Line 1529: from pon_auction_item_prices_all aip1,

1525: x_option_num OUT NOCOPY PO_TBL_NUMBER,
1526: x_base_num OUT NOCOPY PO_TBL_NUMBER) IS
1527: Cursor CrossLinkedOptions is
1528: select DISTINCT aip1.group_line_id option_number, aip2.group_line_id base_number
1529: from pon_auction_item_prices_all aip1,
1530: pon_auction_item_prices_all aip2
1531: where aip1.auction_header_id = p_auction_header_id
1532: AND aip1.clm_option_indicator = 'O'
1533: AND Nvl(aip1.clm_info_flag,'N') = 'N'

Line 1530: pon_auction_item_prices_all aip2

1526: x_base_num OUT NOCOPY PO_TBL_NUMBER) IS
1527: Cursor CrossLinkedOptions is
1528: select DISTINCT aip1.group_line_id option_number, aip2.group_line_id base_number
1529: from pon_auction_item_prices_all aip1,
1530: pon_auction_item_prices_all aip2
1531: where aip1.auction_header_id = p_auction_header_id
1532: AND aip1.clm_option_indicator = 'O'
1533: AND Nvl(aip1.clm_info_flag,'N') = 'N'
1534: and aip1.clm_base_line_num is not NULL

Line 1613: pon_auction_item_prices_all paip,

1609: 'SOLICITATION',
1610: prl.item_description,
1611: NULL -- Buyer ID
1612: FROM pon_backing_requisitions pbr,
1613: pon_auction_item_prices_all paip,
1614: pon_auction_headers_all pah,
1615: po_requisition_lines_all prl,
1616: po_requisition_headers_all prh
1617: WHERE pbr.auction_header_id = p_document_id

Line 1910: l_need_by_date pon_auction_item_prices_all.clm_need_by_date%TYPE;

1906: l_src_line_number NUMBER;
1907: count_copy NUMBER := 1;
1908: k NUMBER := 0;
1909:
1910: l_need_by_date pon_auction_item_prices_all.clm_need_by_date%TYPE;
1911: l_pop_start_date pon_auction_item_prices_all.NEED_BY_START_DATE%TYPE;
1912: l_pop_end_date pon_auction_item_prices_all.NEED_BY_DATE%TYPE;
1913: l_option_from_date pon_auction_item_prices_all.clm_option_from_date%TYPE;
1914: l_option_to_date pon_auction_item_prices_all.clm_option_to_date%TYPE;

Line 1911: l_pop_start_date pon_auction_item_prices_all.NEED_BY_START_DATE%TYPE;

1907: count_copy NUMBER := 1;
1908: k NUMBER := 0;
1909:
1910: l_need_by_date pon_auction_item_prices_all.clm_need_by_date%TYPE;
1911: l_pop_start_date pon_auction_item_prices_all.NEED_BY_START_DATE%TYPE;
1912: l_pop_end_date pon_auction_item_prices_all.NEED_BY_DATE%TYPE;
1913: l_option_from_date pon_auction_item_prices_all.clm_option_from_date%TYPE;
1914: l_option_to_date pon_auction_item_prices_all.clm_option_to_date%TYPE;
1915: l_clm_option_num pon_auction_item_prices_all.clm_option_num%TYPE;

Line 1912: l_pop_end_date pon_auction_item_prices_all.NEED_BY_DATE%TYPE;

1908: k NUMBER := 0;
1909:
1910: l_need_by_date pon_auction_item_prices_all.clm_need_by_date%TYPE;
1911: l_pop_start_date pon_auction_item_prices_all.NEED_BY_START_DATE%TYPE;
1912: l_pop_end_date pon_auction_item_prices_all.NEED_BY_DATE%TYPE;
1913: l_option_from_date pon_auction_item_prices_all.clm_option_from_date%TYPE;
1914: l_option_to_date pon_auction_item_prices_all.clm_option_to_date%TYPE;
1915: l_clm_option_num pon_auction_item_prices_all.clm_option_num%TYPE;
1916: l_clm_option_indicator pon_auction_item_prices_all.clm_option_indicator%TYPE;

Line 1913: l_option_from_date pon_auction_item_prices_all.clm_option_from_date%TYPE;

1909:
1910: l_need_by_date pon_auction_item_prices_all.clm_need_by_date%TYPE;
1911: l_pop_start_date pon_auction_item_prices_all.NEED_BY_START_DATE%TYPE;
1912: l_pop_end_date pon_auction_item_prices_all.NEED_BY_DATE%TYPE;
1913: l_option_from_date pon_auction_item_prices_all.clm_option_from_date%TYPE;
1914: l_option_to_date pon_auction_item_prices_all.clm_option_to_date%TYPE;
1915: l_clm_option_num pon_auction_item_prices_all.clm_option_num%TYPE;
1916: l_clm_option_indicator pon_auction_item_prices_all.clm_option_indicator%TYPE;
1917: l_clm_info_flag pon_auction_item_prices_all.clm_info_flag%TYPE;

Line 1914: l_option_to_date pon_auction_item_prices_all.clm_option_to_date%TYPE;

1910: l_need_by_date pon_auction_item_prices_all.clm_need_by_date%TYPE;
1911: l_pop_start_date pon_auction_item_prices_all.NEED_BY_START_DATE%TYPE;
1912: l_pop_end_date pon_auction_item_prices_all.NEED_BY_DATE%TYPE;
1913: l_option_from_date pon_auction_item_prices_all.clm_option_from_date%TYPE;
1914: l_option_to_date pon_auction_item_prices_all.clm_option_to_date%TYPE;
1915: l_clm_option_num pon_auction_item_prices_all.clm_option_num%TYPE;
1916: l_clm_option_indicator pon_auction_item_prices_all.clm_option_indicator%TYPE;
1917: l_clm_info_flag pon_auction_item_prices_all.clm_info_flag%TYPE;
1918:

Line 1915: l_clm_option_num pon_auction_item_prices_all.clm_option_num%TYPE;

1911: l_pop_start_date pon_auction_item_prices_all.NEED_BY_START_DATE%TYPE;
1912: l_pop_end_date pon_auction_item_prices_all.NEED_BY_DATE%TYPE;
1913: l_option_from_date pon_auction_item_prices_all.clm_option_from_date%TYPE;
1914: l_option_to_date pon_auction_item_prices_all.clm_option_to_date%TYPE;
1915: l_clm_option_num pon_auction_item_prices_all.clm_option_num%TYPE;
1916: l_clm_option_indicator pon_auction_item_prices_all.clm_option_indicator%TYPE;
1917: l_clm_info_flag pon_auction_item_prices_all.clm_info_flag%TYPE;
1918:
1919: l_line_numbers numbers;

Line 1916: l_clm_option_indicator pon_auction_item_prices_all.clm_option_indicator%TYPE;

1912: l_pop_end_date pon_auction_item_prices_all.NEED_BY_DATE%TYPE;
1913: l_option_from_date pon_auction_item_prices_all.clm_option_from_date%TYPE;
1914: l_option_to_date pon_auction_item_prices_all.clm_option_to_date%TYPE;
1915: l_clm_option_num pon_auction_item_prices_all.clm_option_num%TYPE;
1916: l_clm_option_indicator pon_auction_item_prices_all.clm_option_indicator%TYPE;
1917: l_clm_info_flag pon_auction_item_prices_all.clm_info_flag%TYPE;
1918:
1919: l_line_numbers numbers;
1920: l_max_line_number NUMBER := NULL;

Line 1917: l_clm_info_flag pon_auction_item_prices_all.clm_info_flag%TYPE;

1913: l_option_from_date pon_auction_item_prices_all.clm_option_from_date%TYPE;
1914: l_option_to_date pon_auction_item_prices_all.clm_option_to_date%TYPE;
1915: l_clm_option_num pon_auction_item_prices_all.clm_option_num%TYPE;
1916: l_clm_option_indicator pon_auction_item_prices_all.clm_option_indicator%TYPE;
1917: l_clm_info_flag pon_auction_item_prices_all.clm_info_flag%TYPE;
1918:
1919: l_line_numbers numbers;
1920: l_max_line_number NUMBER := NULL;
1921: l_info_flags flags;

Line 1936: l_clm_base_option pon_auction_item_prices_all.clm_option_indicator%TYPE;

1932: next_clin_num VARCHAR2(10);
1933: base_line_numbers numbers := numbers();
1934: copied_base_line_numbers numbers := numbers();
1935: LEN NUMBER;
1936: l_clm_base_option pon_auction_item_prices_all.clm_option_indicator%TYPE;
1937:
1938: l_clm_base_line pon_auction_item_prices_all.clm_base_line_num%TYPE;
1939:
1940: l_next_option_num pon_auction_item_prices_all.clm_option_num%TYPE;

Line 1938: l_clm_base_line pon_auction_item_prices_all.clm_base_line_num%TYPE;

1934: copied_base_line_numbers numbers := numbers();
1935: LEN NUMBER;
1936: l_clm_base_option pon_auction_item_prices_all.clm_option_indicator%TYPE;
1937:
1938: l_clm_base_line pon_auction_item_prices_all.clm_base_line_num%TYPE;
1939:
1940: l_next_option_num pon_auction_item_prices_all.clm_option_num%TYPE;
1941: l_is_option_copy VARCHAR2(1);
1942: l_new_group_line_id NUMBER;

Line 1940: l_next_option_num pon_auction_item_prices_all.clm_option_num%TYPE;

1936: l_clm_base_option pon_auction_item_prices_all.clm_option_indicator%TYPE;
1937:
1938: l_clm_base_line pon_auction_item_prices_all.clm_base_line_num%TYPE;
1939:
1940: l_next_option_num pon_auction_item_prices_all.clm_option_num%TYPE;
1941: l_is_option_copy VARCHAR2(1);
1942: l_new_group_line_id NUMBER;
1943: l_new_clins numbers;
1944: l_module_name VARCHAR2(50);

Line 1960: FROM pon_auction_item_prices_all

1956: -- in copying subsequent lines if user had selected more than one line to copy.
1957: --IF l_max_line_number IS NULL THEN
1958: SELECT MAX(line_number)
1959: INTO l_max_line_number
1960: FROM pon_auction_item_prices_all
1961: WHERE auction_header_id = p_auction_header_id;
1962:
1963: FOR i IN p_src_line_numbers.first .. p_src_line_numbers.last LOOP
1964:

Line 1972: FROM pon_auction_item_prices_all

1968: -- Changes for bug 10119899 start. First copy parent line before processing its options/slins.
1969: -- following query selects given source line
1970: SELECT line_number, clm_info_flag,exhibit_number BULK COLLECT
1971: INTO l_line_numbers, l_info_flags,l_exhibits
1972: FROM pon_auction_item_prices_all
1973: WHERE auction_header_id = p_auction_header_id
1974: AND line_number = l_src_line_number;
1975:
1976: SELECT fnd_global.user_id INTO l_user_id FROM dual;

Line 1983: FROM pon_auction_item_prices_all

1979: SELECT Nvl2(group_line_id, 'N', 'Y'),
1980: NVL(group_line_id, l_max_line_number + 1),
1981: DECODE(NVL(clm_option_indicator, 'N'), 'O', 'Y', 'N')
1982: INTO l_clin_flag, l_new_group_line_id, l_is_option_copy
1983: FROM pon_auction_item_prices_all
1984: WHERE auction_header_id = p_auction_header_id
1985: AND line_number = l_src_line_number;
1986:
1987: IF l_clin_flag = 'Y' THEN

Line 1996: FROM pon_auction_item_prices_all

1992:
1993: ELSIF l_clin_flag = 'N' THEN
1994: SELECT SUBSTR(line_num_display, 1, 4)
1995: INTO l_clin_num
1996: FROM pon_auction_item_prices_all
1997: WHERE auctioN_header_id = p_auction_header_id
1998: AND line_number = l_src_line_number;
1999: END IF;
2000:

Line 2009: /* FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS(X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

2005: l_line_number,
2006: l_new_group_line_id,
2007: l_user_id);
2008:
2009: /* FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS(X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2010: X_from_pk1_value => TO_CHAR(p_auction_header_id),
2011: X_from_pk2_value => TO_CHAR(l_src_line_number),
2012: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2013: X_to_pk1_value => TO_CHAR(p_auction_header_id), -- PK1_VALUE

Line 2012: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

2008:
2009: /* FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS(X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2010: X_from_pk1_value => TO_CHAR(p_auction_header_id),
2011: X_from_pk2_value => TO_CHAR(l_src_line_number),
2012: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2013: X_to_pk1_value => TO_CHAR(p_auction_header_id), -- PK1_VALUE
2014: X_to_pk2_value => TO_CHAR(l_line_number),
2015: X_created_by => l_user_id, -- CREATED_BY
2016: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN

Line 2061: FROM pon_auction_item_prices_all

2057: l_option_to_date,
2058: l_clm_option_num,
2059: l_clm_option_indicator,
2060: l_clm_info_flag
2061: FROM pon_auction_item_prices_all
2062: WHERE auction_header_id = p_auction_header_id
2063: AND line_number = l_line_number;
2064:
2065: redefault_tx(l_need_by_date,

Line 2083: UPDATE pon_auction_item_prices_all

2079: ELSE
2080: l_clm_base_line := l_src_line_number;
2081: END IF;
2082:
2083: UPDATE pon_auction_item_prices_all
2084: SET clm_need_by_date = l_need_by_date,
2085: need_by_start_date = l_pop_start_date,
2086: need_by_date = l_pop_end_date,
2087:

Line 2113: FROM pon_auction_item_prices_all

2109: -- bug 10119899. After base line is copied now process slins and options
2110: -- following query selects sub lines and options for the input source line
2111: SELECT line_number, clm_info_flag BULK COLLECT
2112: INTO l_line_numbers, l_info_flags
2113: FROM pon_auction_item_prices_all
2114: WHERE auction_header_id = p_auction_header_id
2115: AND (group_line_id = l_src_line_number)
2116: ORDER BY line_num_display;
2117: --l_max_line_Number := l_max_line_Number + 1;

Line 2136: /* FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS(X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

2132: l_copied_line_numbers.extend();
2133: count_copy := l_copied_line_numbers.count();
2134: l_copied_line_numbers(count_copy) := l_line_numbers(j);
2135:
2136: /* FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS(X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2137: X_from_pk1_value => TO_CHAR(p_auction_header_id),
2138: X_from_pk2_value => TO_CHAR(l_line_numbers(i)),
2139: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2140: X_to_pk1_value => TO_CHAR(p_auction_header_id), -- PK1_VALUE

Line 2139: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

2135:
2136: /* FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS(X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2137: X_from_pk1_value => TO_CHAR(p_auction_header_id),
2138: X_from_pk2_value => TO_CHAR(l_line_numbers(i)),
2139: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2140: X_to_pk1_value => TO_CHAR(p_auction_header_id), -- PK1_VALUE
2141: X_to_pk2_value => TO_CHAR(l_line_number),
2142: X_created_by => l_user_id, -- CREATED_BY
2143: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN

Line 2187: FROM pon_auction_item_prices_all

2183: l_option_to_date,
2184: l_clm_option_num,
2185: l_clm_option_indicator,
2186: l_clm_info_flag
2187: FROM pon_auction_item_prices_all
2188: WHERE auction_header_id = p_auction_header_id
2189: AND line_number = l_line_number;
2190:
2191: redefault_tx(l_need_by_date,

Line 2208: UPDATE pon_auction_item_prices_all

2204: ELSE
2205: l_clm_base_line := l_line_numbers(j);
2206: END IF;
2207:
2208: UPDATE pon_auction_item_prices_all
2209: SET clm_need_by_date = l_need_by_date,
2210: need_by_start_date = l_pop_start_date,
2211: need_by_date = l_pop_end_date,
2212:

Line 2235: FROM pon_auction_item_prices_all

2231: -- if line being copied is a clin, then we need to find next clin number for it.
2232: BEGIN
2233: SELECT line_num_display BULK COLLECT
2234: INTO clin_num_tbl
2235: FROM pon_auction_item_prices_all
2236: WHERE auctioN_header_id = p_auction_header_id
2237: AND group_line_id IS NULL
2238: ORDER BY line_num_display;
2239: EXCEPTION

Line 2248: FROM pon_auction_item_prices_all

2244: next_clin_num := pon_clo_renumber_pkg.next_clin_num(clin_num_tbl);
2245: -- this query selects new copied clin and its optional clins if any
2246: SELECT line_number,exhibit_number BULK COLLECT
2247: INTO l_new_clins,l_new_exhibits
2248: FROM pon_auction_item_prices_all
2249: WHERE auction_header_id = p_auction_header_id
2250: AND line_number > l_max_line_Number
2251: AND group_line_id IS NULL;
2252: --ORDER BY line_number;

Line 2262: UPDATE pon_auction_item_prices_all

2258: next_clin_num := pon_clo_renumber_pkg.NEXT_ELIN_NUM_WRAPPER2(p_auction_header_id,'PON',exhibit);
2259: END IF;
2260:
2261:
2262: UPDATE pon_auction_item_prices_all
2263: SET line_num_display = next_clin_num
2264: WHERE auction_header_id = p_auction_header_id
2265: AND line_number = l_new_clins(i);
2266:

Line 2279: /* UPDATE pon_auction_item_prices_all

2275: clin_num_tbl(LEN) := next_clin_num;
2276: next_clin_num := pon_clo_renumber_pkg.next_clin_num(clin_num_tbl);
2277: END IF;
2278: END LOOP;
2279: /* UPDATE pon_auction_item_prices_all
2280: SET line_num_display = next_clin_num
2281: WHERE auction_header_id = p_auction_header_id
2282: AND line_number = l_max_line_Number + 1; -- this value would have been assigned to the new copied clin
2283: */

Line 2299: FROM pon_auction_item_prices_all

2295: END LOOP;
2296:
2297: SELECT Count(*)
2298: INTO x_max_line_number
2299: FROM pon_auction_item_prices_all
2300: WHERE auction_header_id = p_auction_header_id;
2301:
2302: END copy_lines;
2303: