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.PO_AUTOCREATE_GROUPING_PVT dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 717: l_sol_line_num_disp PON_AUCTION_ITEM_PRICES_ALL.LINE_NUM_DISPLAY%TYPE;

713: d_position NUMBER := 0;
714:
715: l_num_lines NUMBER;
716: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
717: l_sol_line_num_disp PON_AUCTION_ITEM_PRICES_ALL.LINE_NUM_DISPLAY%TYPE;
718: l_sol_line_num PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
719: l_message_code VARCHAR2(30) := NULL;
720: l_token_name VARCHAR2(30) := NULL;
721: l_token_value VARCHAR2(2000) := NULL;

Line 718: l_sol_line_num PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;

714:
715: l_num_lines NUMBER;
716: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
717: l_sol_line_num_disp PON_AUCTION_ITEM_PRICES_ALL.LINE_NUM_DISPLAY%TYPE;
718: l_sol_line_num PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
719: l_message_code VARCHAR2(30) := NULL;
720: l_token_name VARCHAR2(30) := NULL;
721: l_token_value VARCHAR2(2000) := NULL;
722: req_line_type_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;

Line 724: sol_line_type_id PON_AUCTION_ITEM_PRICES_ALL.line_type_id%TYPE;

720: l_token_name VARCHAR2(30) := NULL;
721: l_token_value VARCHAR2(2000) := NULL;
722: req_line_type_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;
723: req_group_line_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;
724: sol_line_type_id PON_AUCTION_ITEM_PRICES_ALL.line_type_id%TYPE;
725: req_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
726: sol_item_id PON_AUCTION_ITEM_PRICES_ALL.item_id%TYPE;
727: req_item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE;
728: sol_item_revision PON_AUCTION_ITEM_PRICES_ALL.item_revision%TYPE;

Line 726: sol_item_id PON_AUCTION_ITEM_PRICES_ALL.item_id%TYPE;

722: req_line_type_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;
723: req_group_line_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;
724: sol_line_type_id PON_AUCTION_ITEM_PRICES_ALL.line_type_id%TYPE;
725: req_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
726: sol_item_id PON_AUCTION_ITEM_PRICES_ALL.item_id%TYPE;
727: req_item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE;
728: sol_item_revision PON_AUCTION_ITEM_PRICES_ALL.item_revision%TYPE;
729: req_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;
730: sol_category_id PON_AUCTION_ITEM_PRICES_ALL.category_id%TYPE;

Line 728: sol_item_revision PON_AUCTION_ITEM_PRICES_ALL.item_revision%TYPE;

724: sol_line_type_id PON_AUCTION_ITEM_PRICES_ALL.line_type_id%TYPE;
725: req_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
726: sol_item_id PON_AUCTION_ITEM_PRICES_ALL.item_id%TYPE;
727: req_item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE;
728: sol_item_revision PON_AUCTION_ITEM_PRICES_ALL.item_revision%TYPE;
729: req_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;
730: sol_category_id PON_AUCTION_ITEM_PRICES_ALL.category_id%TYPE;
731: sol_group_line_id PON_AUCTION_ITEM_PRICES_ALL.group_line_id%TYPE;
732: sol_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.clm_info_flag%TYPE;

Line 730: sol_category_id PON_AUCTION_ITEM_PRICES_ALL.category_id%TYPE;

726: sol_item_id PON_AUCTION_ITEM_PRICES_ALL.item_id%TYPE;
727: req_item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE;
728: sol_item_revision PON_AUCTION_ITEM_PRICES_ALL.item_revision%TYPE;
729: req_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;
730: sol_category_id PON_AUCTION_ITEM_PRICES_ALL.category_id%TYPE;
731: sol_group_line_id PON_AUCTION_ITEM_PRICES_ALL.group_line_id%TYPE;
732: sol_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.clm_info_flag%TYPE;
733: sol_clm_option_indicator PON_AUCTION_ITEM_PRICES_ALL.clm_option_indicator%TYPE;
734: sol_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;

Line 731: sol_group_line_id PON_AUCTION_ITEM_PRICES_ALL.group_line_id%TYPE;

727: req_item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE;
728: sol_item_revision PON_AUCTION_ITEM_PRICES_ALL.item_revision%TYPE;
729: req_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;
730: sol_category_id PON_AUCTION_ITEM_PRICES_ALL.category_id%TYPE;
731: sol_group_line_id PON_AUCTION_ITEM_PRICES_ALL.group_line_id%TYPE;
732: sol_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.clm_info_flag%TYPE;
733: sol_clm_option_indicator PON_AUCTION_ITEM_PRICES_ALL.clm_option_indicator%TYPE;
734: sol_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
735: req_line_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;

Line 732: sol_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.clm_info_flag%TYPE;

728: sol_item_revision PON_AUCTION_ITEM_PRICES_ALL.item_revision%TYPE;
729: req_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;
730: sol_category_id PON_AUCTION_ITEM_PRICES_ALL.category_id%TYPE;
731: sol_group_line_id PON_AUCTION_ITEM_PRICES_ALL.group_line_id%TYPE;
732: sol_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.clm_info_flag%TYPE;
733: sol_clm_option_indicator PON_AUCTION_ITEM_PRICES_ALL.clm_option_indicator%TYPE;
734: sol_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
735: req_line_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
736: sol_ip_category_id PON_AUCTION_ITEM_PRICES_ALL.ip_category_id%TYPE;

Line 733: sol_clm_option_indicator PON_AUCTION_ITEM_PRICES_ALL.clm_option_indicator%TYPE;

729: req_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;
730: sol_category_id PON_AUCTION_ITEM_PRICES_ALL.category_id%TYPE;
731: sol_group_line_id PON_AUCTION_ITEM_PRICES_ALL.group_line_id%TYPE;
732: sol_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.clm_info_flag%TYPE;
733: sol_clm_option_indicator PON_AUCTION_ITEM_PRICES_ALL.clm_option_indicator%TYPE;
734: sol_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
735: req_line_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
736: sol_ip_category_id PON_AUCTION_ITEM_PRICES_ALL.ip_category_id%TYPE;
737: sol_uom_code VARCHAR2(10);

Line 736: sol_ip_category_id PON_AUCTION_ITEM_PRICES_ALL.ip_category_id%TYPE;

732: sol_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.clm_info_flag%TYPE;
733: sol_clm_option_indicator PON_AUCTION_ITEM_PRICES_ALL.clm_option_indicator%TYPE;
734: sol_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
735: req_line_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
736: sol_ip_category_id PON_AUCTION_ITEM_PRICES_ALL.ip_category_id%TYPE;
737: sol_uom_code VARCHAR2(10);
738: req_line_uom VARCHAR2(10);
739: req_ship_to_location_id hr_locations.ship_to_location_id%TYPE;
740: message_suffix VARCHAR2(2);

Line 741: sol_ship_to_location_id PON_AUCTION_ITEM_PRICES_ALL.ship_to_location_id%TYPE;

737: sol_uom_code VARCHAR2(10);
738: req_line_uom VARCHAR2(10);
739: req_ship_to_location_id hr_locations.ship_to_location_id%TYPE;
740: message_suffix VARCHAR2(2);
741: sol_ship_to_location_id PON_AUCTION_ITEM_PRICES_ALL.ship_to_location_id%TYPE;
742: sol_line_orig_code PON_AUCTION_ITEM_PRICES_ALL.LINE_ORIGINATION_CODE%TYPE;
743: BEGIN
744: IF (PO_LOG.d_proc) THEN
745: PO_LOG.proc_begin(d_mod);

Line 742: sol_line_orig_code PON_AUCTION_ITEM_PRICES_ALL.LINE_ORIGINATION_CODE%TYPE;

738: req_line_uom VARCHAR2(10);
739: req_ship_to_location_id hr_locations.ship_to_location_id%TYPE;
740: message_suffix VARCHAR2(2);
741: sol_ship_to_location_id PON_AUCTION_ITEM_PRICES_ALL.ship_to_location_id%TYPE;
742: sol_line_orig_code PON_AUCTION_ITEM_PRICES_ALL.LINE_ORIGINATION_CODE%TYPE;
743: BEGIN
744: IF (PO_LOG.d_proc) THEN
745: PO_LOG.proc_begin(d_mod);
746: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);

Line 824: FROM pon_auction_item_prices_all paip

820: ,sol_ip_category_id
821: ,sol_uom_code
822: ,sol_ship_to_location_id
823: ,sol_line_orig_code
824: FROM pon_auction_item_prices_all paip
825: WHERE paip.line_number =l_sol_line_num
826: AND paip.auction_header_id =p_draft_id;
827:
828: EXCEPTION

Line 854: FROM pon_auction_item_prices_all paip

850: ,sol_ip_category_id
851: ,sol_uom_code
852: ,sol_ship_to_location_id
853: ,sol_line_orig_code
854: FROM pon_auction_item_prices_all paip
855: WHERE paip.line_num_display =l_sol_line_num_disp
856: AND paip.auction_header_id =p_draft_id;
857:
858:

Line 2215: SELECT Max(LINE_NUMBER) INTO l_max_line_num FROM pon_auction_item_prices_all WHERE AUCTION_HEADER_ID = p_draft_id;

2211: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
2212:
2213: -- Initialize the max PO line number.
2214:
2215: SELECT Max(LINE_NUMBER) INTO l_max_line_num FROM pon_auction_item_prices_all WHERE AUCTION_HEADER_ID = p_draft_id;
2216:
2217:
2218:
2219: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_max_line_num',l_max_line_num); END IF;

Line 4802: FROM pon_auction_item_prices_all

4798: IF ( p_draft_id IS NOT NULL )
4799: THEN
4800: SELECT nvl(max(line_num_display), '0000')
4801: INTO x_max_po_line_num
4802: FROM pon_auction_item_prices_all
4803: WHERE auction_header_id = p_draft_id
4804: and group_line_id is null;
4805: END IF;
4806: