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

Line 8: g_price_break_type pon_auction_item_prices_all.price_break_type%type;

4: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_AUCTION_INTERFACE_PKG';
5: g_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE := 'NONE';
6:
7: -- global variables added for header price break default project
8: g_price_break_type pon_auction_item_prices_all.price_break_type%type;
9: g_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;
10:
11: /*
12: ===================

Line 9: g_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;

5: g_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE := 'NONE';
6:
7: -- global variables added for header price break default project
8: g_price_break_type pon_auction_item_prices_all.price_break_type%type;
9: g_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;
10:
11: /*
12: ===================
13: PROCEDURES

Line 489: v_price pon_auction_item_prices_all.current_price%TYPE;

485: v_item_attach_count NUMBER;
486: v_site_id pon_auction_headers_all.trading_partner_id%TYPE :=NULL;
487: v_org_id pon_auction_headers_all.org_id%TYPE;
488: v_seq_num fnd_attached_documents.seq_num%TYPE;
489: v_price pon_auction_item_prices_all.current_price%TYPE;
490: v_category_name pon_auction_item_prices_all.category_name%TYPE;
491: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
492: v_quantity pon_auction_item_prices_all.quantity%TYPE;
493: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;

Line 490: v_category_name pon_auction_item_prices_all.category_name%TYPE;

486: v_site_id pon_auction_headers_all.trading_partner_id%TYPE :=NULL;
487: v_org_id pon_auction_headers_all.org_id%TYPE;
488: v_seq_num fnd_attached_documents.seq_num%TYPE;
489: v_price pon_auction_item_prices_all.current_price%TYPE;
490: v_category_name pon_auction_item_prices_all.category_name%TYPE;
491: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
492: v_quantity pon_auction_item_prices_all.quantity%TYPE;
493: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
494: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';

Line 491: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;

487: v_org_id pon_auction_headers_all.org_id%TYPE;
488: v_seq_num fnd_attached_documents.seq_num%TYPE;
489: v_price pon_auction_item_prices_all.current_price%TYPE;
490: v_category_name pon_auction_item_prices_all.category_name%TYPE;
491: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
492: v_quantity pon_auction_item_prices_all.quantity%TYPE;
493: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
494: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';
495: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';

Line 492: v_quantity pon_auction_item_prices_all.quantity%TYPE;

488: v_seq_num fnd_attached_documents.seq_num%TYPE;
489: v_price pon_auction_item_prices_all.current_price%TYPE;
490: v_category_name pon_auction_item_prices_all.category_name%TYPE;
491: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
492: v_quantity pon_auction_item_prices_all.quantity%TYPE;
493: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
494: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';
495: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
496: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;

Line 493: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;

489: v_price pon_auction_item_prices_all.current_price%TYPE;
490: v_category_name pon_auction_item_prices_all.category_name%TYPE;
491: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
492: v_quantity pon_auction_item_prices_all.quantity%TYPE;
493: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
494: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';
495: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
496: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
497: v_purchase_basis po_line_types_b.purchase_basis%TYPE;

Line 494: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';

490: v_category_name pon_auction_item_prices_all.category_name%TYPE;
491: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
492: v_quantity pon_auction_item_prices_all.quantity%TYPE;
493: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
494: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';
495: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
496: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
497: v_purchase_basis po_line_types_b.purchase_basis%TYPE;
498: v_att_category_id fnd_document_categories.category_id%TYPE;

Line 761: FROM pon_auction_item_prices_all

757: IF (P_CONTRACT_TYPE = 'STANDARD') THEN
758:
759: SELECT max(line_number)
760: INTO P_LINE_NUMBER
761: FROM pon_auction_item_prices_all
762: WHERE auction_header_id = P_DOCUMENT_NUMBER
763: AND line_type_id = P_LINE_TYPE_ID
764: AND nvl(p_item_id, -1) = nvl(item_id, -1)
765: AND nvl(p_item_revision, -1) = nvl(item_revision, -1)

Line 776: FROM pon_auction_item_prices_all paip,

772: ELSE
773:
774: SELECT max(paip.line_number)
775: INTO P_LINE_NUMBER
776: FROM pon_auction_item_prices_all paip,
777: pon_backing_requisitions pbr,
778: po_requisition_lines_all prl
779: WHERE paip.auction_header_id = P_DOCUMENT_NUMBER
780: AND paip.line_type_id = P_LINE_TYPE_ID

Line 806: UPDATE pon_auction_item_prices_all

802:
803: IF (v_order_type_lookup_code = 'AMOUNT') THEN
804: -- Update row in PON_AUCTION_ITEM_PRICES
805: v_debug_status := 'UPDATE_PAIP_1';
806: UPDATE pon_auction_item_prices_all
807: SET requisition_number = 'MULTIPLE',
808: -- problem: least() and greater() return NULL if any argument is NULL
809: -- need_by_start := NULL if P_NEED_BY_DATE and need_by_start == NULL
810: need_by_start_date = decode(P_CONTRACT_TYPE, 'BLANKET', to_date(NULL), least(nvl(need_by_start_date,P_NEED_BY_DATE), nvl(P_NEED_BY_DATE,need_by_start_date))),

Line 821: UPDATE pon_auction_item_prices_all

817: AND line_number = P_LINE_NUMBER;
818: ELSE
819: -- Update row in PON_AUCTION_ITEM_PRICES
820: v_debug_status := 'UPDATE_PAIP_2';
821: UPDATE pon_auction_item_prices_all
822: SET quantity = quantity + P_QUANTITY,
823: residual_quantity = residual_quantity + P_QUANTITY,
824: requisition_number = 'MULTIPLE',
825: -- problem: least() and greater() return NULL if any argument is NULL

Line 913: FROM pon_auction_item_prices_all

909: -- for setting the number_of_lines and last_line_number fields
910: -- also.
911: SELECT nvl(max(line_number),0)+1
912: INTO P_LINE_NUMBER
913: FROM pon_auction_item_prices_all
914: WHERE auction_header_id = P_DOCUMENT_NUMBER;
915:
916: v_debug_status := 'INSERT_PAIP';
917: INSERT INTO PON_AUCTION_ITEM_PRICES_ALL (

Line 917: INSERT INTO PON_AUCTION_ITEM_PRICES_ALL (

913: FROM pon_auction_item_prices_all
914: WHERE auction_header_id = P_DOCUMENT_NUMBER;
915:
916: v_debug_status := 'INSERT_PAIP';
917: INSERT INTO PON_AUCTION_ITEM_PRICES_ALL (
918: AUCTION_HEADER_ID,
919: LINE_NUMBER,
920: DISP_LINE_NUMBER,
921: LAST_AMENDMENT_UPDATE,

Line 1064: 'PON_AUCTION_ITEM_PRICES_ALL', -- entity_name

1060: NULL, -- from_pk2_value
1061: NULL, -- from_pk3_value
1062: NULL, -- from_pk4_value
1063: NULL, -- from_pk5_value
1064: 'PON_AUCTION_ITEM_PRICES_ALL', -- entity_name
1065: to_char(P_DOCUMENT_NUMBER), -- PK1_VALUE
1066: to_char(P_LINE_NUMBER), -- PK2_VALUE
1067: NULL, -- PK3_VALUE
1068: NULL, -- PK4_VALUE

Line 1088: 'PON_AUCTION_ITEM_PRICES_ALL', -- entity_name

1084: NULL, -- from_pk2_value
1085: NULL, -- from_pk3_value
1086: NULL, -- from_pk4_value
1087: NULL, -- from_pk5_value
1088: 'PON_AUCTION_ITEM_PRICES_ALL', -- entity_name
1089: to_char(P_DOCUMENT_NUMBER), -- PK1_VALUE
1090: to_char(P_LINE_NUMBER), -- PK2_VALUE
1091: NULL, -- PK3_VALUE
1092: NULL, -- PK4_VALUE

Line 1156: FROM pon_auction_item_prices_all paip,

1152:
1153:
1154: CURSOR nonCatalogLines IS
1155: SELECT distinct paip.line_number, paip.ip_category_id
1156: FROM pon_auction_item_prices_all paip,
1157: pon_backing_requisitions pbr,
1158: po_requisition_lines_all prl
1159: WHERE paip.auction_header_id = p_document_number and
1160: paip.auction_header_id = pbr.auction_header_id and