APPS.PON_CLM_CLO_UTIL_PKG dependencies on DUAL

Line 425: SELECT fnd_global.user_id INTO l_user_id FROM dual;

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;
426:
427:
428:
429: copy_line_information(p_auction_header_id,

Line 566: SELECT fnd_global.user_id INTO l_user_id FROM dual;

562: ELSE
563: l_max_line_number := x_max_line_number;
564: END IF;
565:
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

Line 575: SELECT pon_clo_renumber_pkg.NEXT_CLIN_NUM_WRAPPER(p_auction_header_id,'PON') INTO l_clin_num FROM dual;

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
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

Line 908: --RESIDUAL_QUANTITY,

904: AUCTION_HEADER_ID_PREV_ROUND,
905: --LINE_NUMBER_ORIGINAL_ROUND,
906: --LINE_NUMBER_PREV_ROUND,
907: MULTIPLE_PRICES_FLAG,
908: --RESIDUAL_QUANTITY,
909: --PENDING_QUANTITY,
910: --CANCEL_QUANTITY,
911: --NUMBER_OF_COMMITMENTS,
912: --NUMBER_OF_PENDING_COMMITMENTS,

Line 1057: --RESIDUAL_QUANTITY,

1053: AUCTION_HEADER_ID_PREV_ROUND,
1054: --LINE_NUMBER_ORIGINAL_ROUND,
1055: --LINE_NUMBER_PREV_ROUND,
1056: MULTIPLE_PRICES_FLAG,
1057: --RESIDUAL_QUANTITY,
1058: --PENDING_QUANTITY,
1059: --CANCEL_QUANTITY,
1060: --NUMBER_OF_COMMITMENTS,
1061: --NUMBER_OF_PENDING_COMMITMENTS,

Line 1768: FROM dual;

1764: WHERE requisition_line_id=l_req_line_id;
1765: END IF;
1766: SELECT PON_LINE_DELETE_WF_S.nextval
1767: INTO l_sequence
1768: FROM dual;
1769:
1770: BEGIN
1771: IF(p_caller <>'PON') THEN
1772: SELECT papf.full_name

Line 1976: SELECT fnd_global.user_id INTO l_user_id FROM dual;

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;
1977:
1978: -- check whether source line is a clin and whethere it is an option
1979: SELECT Nvl2(group_line_id, 'N', 'Y'),
1980: NVL(group_line_id, l_max_line_number + 1),

Line 1991: FROM dual;

1987: IF l_clin_flag = 'Y' THEN
1988: SELECT pon_clo_renumber_pkg.NEXT_CLIN_NUM_WRAPPER(p_auction_header_id,
1989: 'PON')
1990: INTO l_clin_num
1991: FROM dual;
1992:
1993: ELSIF l_clin_flag = 'N' THEN
1994: SELECT SUBSTR(line_num_display, 1, 4)
1995: INTO l_clin_num