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 6: g_price_break_type pon_auction_item_prices_all.price_break_type%type;

2: /* $Header: PONAUCIB.pls 120.55.12020000.5 2013/02/09 06:02:15 hvutukur ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_AUCTION_INTERFACE_PKG';
4: g_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE := 'NONE';
5: -- global variables added for header price break default project
6: g_price_break_type pon_auction_item_prices_all.price_break_type%type;
7: g_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;
8: /*
9: ===================
10: PROCEDURES

Line 7: g_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;

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

Line 902: v_price pon_auction_item_prices_all.current_price%TYPE;

898: v_item_attach_count NUMBER;
899: v_site_id pon_auction_headers_all.trading_partner_id%TYPE :=NULL;
900: v_org_id pon_auction_headers_all.org_id%TYPE;
901: v_seq_num fnd_attached_documents.seq_num%TYPE;
902: v_price pon_auction_item_prices_all.current_price%TYPE;
903: v_category_name pon_auction_item_prices_all.category_name%TYPE;
904: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
905: v_quantity pon_auction_item_prices_all.quantity%TYPE;
906: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;

Line 903: v_category_name pon_auction_item_prices_all.category_name%TYPE;

899: v_site_id pon_auction_headers_all.trading_partner_id%TYPE :=NULL;
900: v_org_id pon_auction_headers_all.org_id%TYPE;
901: v_seq_num fnd_attached_documents.seq_num%TYPE;
902: v_price pon_auction_item_prices_all.current_price%TYPE;
903: v_category_name pon_auction_item_prices_all.category_name%TYPE;
904: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
905: v_quantity pon_auction_item_prices_all.quantity%TYPE;
906: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
907: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';

Line 904: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;

900: v_org_id pon_auction_headers_all.org_id%TYPE;
901: v_seq_num fnd_attached_documents.seq_num%TYPE;
902: v_price pon_auction_item_prices_all.current_price%TYPE;
903: v_category_name pon_auction_item_prices_all.category_name%TYPE;
904: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
905: v_quantity pon_auction_item_prices_all.quantity%TYPE;
906: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
907: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';
908: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';

Line 905: v_quantity pon_auction_item_prices_all.quantity%TYPE;

901: v_seq_num fnd_attached_documents.seq_num%TYPE;
902: v_price pon_auction_item_prices_all.current_price%TYPE;
903: v_category_name pon_auction_item_prices_all.category_name%TYPE;
904: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
905: v_quantity pon_auction_item_prices_all.quantity%TYPE;
906: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
907: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';
908: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
909: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;

Line 906: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;

902: v_price pon_auction_item_prices_all.current_price%TYPE;
903: v_category_name pon_auction_item_prices_all.category_name%TYPE;
904: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
905: v_quantity pon_auction_item_prices_all.quantity%TYPE;
906: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
907: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';
908: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
909: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
910: v_purchase_basis po_line_types_b.purchase_basis%TYPE;

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

903: v_category_name pon_auction_item_prices_all.category_name%TYPE;
904: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
905: v_quantity pon_auction_item_prices_all.quantity%TYPE;
906: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
907: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';
908: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
909: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
910: v_purchase_basis po_line_types_b.purchase_basis%TYPE;
911: v_att_category_id fnd_document_categories.category_id%TYPE;

Line 922: need_by_dt pon_auction_item_prices_all.need_by_date%TYPE;

918: v_blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE;
919: v_msg_count NUMBER; --
920: v_return_status VARCHAR2(1); --
921: v_doctype_id pon_auction_headers_all.doctype_id%TYPE; --
922: need_by_dt pon_auction_item_prices_all.need_by_date%TYPE;
923: pop_start_dt pon_auction_item_prices_all.need_by_date%TYPE;
924: pop_end_dt pon_auction_item_prices_all.need_by_date%TYPE;
925: --CLM Bug : 10096343
926: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;

Line 923: pop_start_dt pon_auction_item_prices_all.need_by_date%TYPE;

919: v_msg_count NUMBER; --
920: v_return_status VARCHAR2(1); --
921: v_doctype_id pon_auction_headers_all.doctype_id%TYPE; --
922: need_by_dt pon_auction_item_prices_all.need_by_date%TYPE;
923: pop_start_dt pon_auction_item_prices_all.need_by_date%TYPE;
924: pop_end_dt pon_auction_item_prices_all.need_by_date%TYPE;
925: --CLM Bug : 10096343
926: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
927: l_comp_pricing_grp_id po_uda_ag_template_usages.ATTRIBUTE_GROUP_ID%TYPE; -- bug 13571062

Line 924: pop_end_dt pon_auction_item_prices_all.need_by_date%TYPE;

920: v_return_status VARCHAR2(1); --
921: v_doctype_id pon_auction_headers_all.doctype_id%TYPE; --
922: need_by_dt pon_auction_item_prices_all.need_by_date%TYPE;
923: pop_start_dt pon_auction_item_prices_all.need_by_date%TYPE;
924: pop_end_dt pon_auction_item_prices_all.need_by_date%TYPE;
925: --CLM Bug : 10096343
926: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
927: l_comp_pricing_grp_id po_uda_ag_template_usages.ATTRIBUTE_GROUP_ID%TYPE; -- bug 13571062
928: BEGIN

Line 1255: FROM pon_auction_item_prices_all

1251: logme(l_log_module, 'Line exist check ');
1252: BEGIN
1253: SELECT 'Y'
1254: INTO l_line_exist
1255: FROM pon_auction_item_prices_all
1256: WHERE auction_header_id =p_document_number
1257: AND line_number = p_line_number;
1258: EXCEPTION
1259: WHEN OTHERS THEN

Line 1272: FROM pon_auction_item_prices_all

1268: IF (V_CONTRACT_TYPE = 'STANDARD') THEN
1269: BEGIN
1270: SELECT 'Y'
1271: INTO l_line_valid
1272: FROM pon_auction_item_prices_all
1273: WHERE auction_header_id = P_DOCUMENT_NUMBER
1274: AND line_number = P_LINE_NUMBER
1275: AND line_type_id = P_LINE_TYPE_ID
1276: AND NVL(p_item_id, -1) = NVL(item_id, -1)

Line 1302: FROM pon_auction_item_prices_all paip,

1298: ELSE
1299: BEGIN
1300: SELECT 'Y'
1301: INTO l_line_valid
1302: FROM pon_auction_item_prices_all paip,
1303: pon_backing_requisitions pbr,
1304: po_requisition_lines_all prl
1305: WHERE paip.auction_header_id = P_DOCUMENT_NUMBER
1306: AND paip.line_number = P_LINE_NUMBER

Line 1350: FROM pon_auction_item_prices_all

1346: logme(l_log_module, 'Grouping Line search select ');
1347: IF (V_CONTRACT_TYPE = 'STANDARD') THEN
1348: SELECT MAX(line_number)
1349: INTO P_LINE_NUMBER
1350: FROM pon_auction_item_prices_all
1351: WHERE auction_header_id = P_DOCUMENT_NUMBER
1352: AND line_type_id = P_LINE_TYPE_ID
1353: AND NVL(p_item_id, -1) = NVL(item_id, -1)
1354: AND NVL(p_item_revision, -1) = NVL(item_revision, -1)

Line 1373: FROM pon_auction_item_prices_all paip,

1369: AND line_origination_code = 'REQUISITION';
1370: ELSE
1371: SELECT MAX(paip.line_number)
1372: INTO P_LINE_NUMBER
1373: FROM pon_auction_item_prices_all paip,
1374: pon_backing_requisitions pbr,
1375: po_requisition_lines_all prl
1376: WHERE paip.auction_header_id = P_DOCUMENT_NUMBER
1377: AND paip.line_type_id = P_LINE_TYPE_ID

Line 1416: UPDATE pon_auction_item_prices_all

1412: IF (v_order_type_lookup_code = 'AMOUNT') THEN
1413: -- Update row in PON_AUCTION_ITEM_PRICES
1414: v_debug_status := 'UPDATE_PAIP_1';
1415: logme(l_log_module, v_debug_status);
1416: UPDATE pon_auction_item_prices_all
1417: SET requisition_number = 'MULTIPLE',
1418: -- problem: least() and greater() return NULL if any argument is NULL
1419: -- need_by_start := NULL if P_NEED_BY_DATE and need_by_start == NULL
1420: need_by_start_date = DECODE(V_CONTRACT_TYPE, 'BLANKET', to_date(NULL),

Line 1436: UPDATE pon_auction_item_prices_all

1432: WHERE auction_header_id = P_DOCUMENT_NUMBER
1433: AND line_number = P_LINE_NUMBER;
1434: ELSIF ( v_order_type_lookup_code IS NULL) THEN
1435: -- Clin Slin Changes : Special case for info lines. We need to update only the req num field on the line.
1436: UPDATE pon_auction_item_prices_all
1437: SET requisition_number = 'MULTIPLE'
1438: WHERE auction_header_id = P_DOCUMENT_NUMBER
1439: AND line_number = P_LINE_NUMBER;
1440: ELSE

Line 1444: UPDATE pon_auction_item_prices_all

1440: ELSE
1441: -- Update row in PON_AUCTION_ITEM_PRICES
1442: v_debug_status := 'UPDATE_PAIP_2';
1443: logme(l_log_module, v_debug_status);
1444: UPDATE pon_auction_item_prices_all
1445: SET quantity = quantity + P_QUANTITY,
1446: residual_quantity = residual_quantity + P_QUANTITY,
1447: requisition_number = 'MULTIPLE',
1448: -- problem: least() and greater() return NULL if any argument is NULL

Line 1535: FROM pon_auction_item_prices_all

1531: -- for setting the number_of_lines and last_line_number fields
1532: -- also.
1533: SELECT NVL(MAX(line_number),0)+1
1534: INTO P_LINE_NUMBER
1535: FROM pon_auction_item_prices_all
1536: WHERE auction_header_id = P_DOCUMENT_NUMBER;
1537:
1538: v_debug_status := 'INSERT_PAIP';
1539: logme(l_log_module, v_debug_status);

Line 1541: INTO PON_AUCTION_ITEM_PRICES_ALL

1537:
1538: v_debug_status := 'INSERT_PAIP';
1539: logme(l_log_module, v_debug_status);
1540: INSERT
1541: INTO PON_AUCTION_ITEM_PRICES_ALL
1542: (
1543: AUCTION_HEADER_ID,
1544: LINE_NUMBER,
1545: DISP_LINE_NUMBER,

Line 1687: UPDATE pon_auction_item_prices_all

1683: pop_end_dt
1684: FROM po_requisition_lines_all
1685: WHERE requisition_header_id = p_requisition_header_id
1686: AND requisition_line_id = p_requisition_line_id;
1687: UPDATE pon_auction_item_prices_all
1688: SET clm_need_by_date = DECODE(V_CONTRACT_TYPE, 'BLANKET', to_date(NULL), need_by_dt),
1689: need_by_start_date = DECODE(V_CONTRACT_TYPE, 'BLANKET', to_date(NULL), pop_start_dt),
1690: need_by_date = DECODE(V_CONTRACT_TYPE, 'BLANKET', to_date(NULL), pop_end_dt)
1691: WHERE auction_header_id = P_DOCUMENT_NUMBER

Line 1748: 'PON_AUCTION_ITEM_PRICES_ALL', -- entity_name

1744: NULL, -- from_pk2_value
1745: NULL, -- from_pk3_value
1746: NULL, -- from_pk4_value
1747: NULL, -- from_pk5_value
1748: 'PON_AUCTION_ITEM_PRICES_ALL', -- entity_name
1749: TO_CHAR(P_DOCUMENT_NUMBER), -- PK1_VALUE
1750: TO_CHAR(P_LINE_NUMBER), -- PK2_VALUE
1751: NULL, -- PK3_VALUE
1752: NULL, -- PK4_VALUE

Line 1779: 'PON_AUCTION_ITEM_PRICES_ALL', -- entity_name

1775: NULL, -- from_pk2_value
1776: NULL, -- from_pk3_value
1777: NULL, -- from_pk4_value
1778: NULL, -- from_pk5_value
1779: 'PON_AUCTION_ITEM_PRICES_ALL', -- entity_name
1780: TO_CHAR(P_DOCUMENT_NUMBER), -- PK1_VALUE
1781: TO_CHAR(P_LINE_NUMBER), -- PK2_VALUE
1782: NULL, -- PK3_VALUE
1783: NULL, -- PK4_VALUE

Line 1866: UPDATE pon_auction_item_prices_all

1862: WHERE template_id = P_REQ_LINE_TEMP_ID
1863: AND ATTRIBUTE1 = P_CLM_IDC_TYPE
1864: AND ATTRIBUTE2 = P_CLM_CONTRACT_TYPE;
1865:
1866: UPDATE pon_auction_item_prices_all
1867: SET clm_amount = clm_amount
1868: + PO_UDA_PUB.get_single_attr_value(
1869: p_entity_code => 'PO_REQ_LINE_EXT_ATTRS',
1870: pk1_value => P_REQUISITION_LINE_ID,

Line 1896: UPDATE pon_auction_item_prices_all

1892: WHERE template_id = P_UDA_TEMPLATE_ID
1893: AND ATTRIBUTE1 = P_CLM_IDC_TYPE
1894: AND ATTRIBUTE2 = P_CLM_CONTRACT_TYPE;
1895:
1896: UPDATE pon_auction_item_prices_all
1897: SET clm_amount =
1898: PO_UDA_PUB.get_single_attr_value(
1899: p_entity_code => 'PON_AUC_PRICES_EXT_ATTRS',
1900: pk1_value => P_DOCUMENT_NUMBER,

Line 1915: UPDATE pon_auction_item_prices_all

1911: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',
1912: 'Exception in updating complex pricing extended price ');
1913: END;
1914: ELSE -- quantity based lines
1915: UPDATE pon_auction_item_prices_all
1916: SET clm_unit_price = current_price,
1917: clm_amount = (NVL(quantity,0)*NVL(current_price,0))
1918: WHERE auction_header_id = P_DOCUMENT_NUMBER
1919: AND line_number = P_LINE_NUMBER;

Line 1973: FROM pon_auction_item_prices_all paip,

1969: CURSOR nonCatalogLines
1970: IS
1971: SELECT DISTINCT paip.line_number,
1972: paip.ip_category_id
1973: FROM pon_auction_item_prices_all paip,
1974: pon_backing_requisitions pbr,
1975: po_requisition_lines_all prl
1976: WHERE paip.auction_header_id = p_document_number
1977: AND paip.auction_header_id = pbr.auction_header_id

Line 2656: UPDATE pon_auction_item_prices_all

2652: BEGIN
2653: logme(l_log_module, 'in maintain_clm_relations');
2654: FOR oneline IN req_based_lines
2655: LOOP
2656: UPDATE pon_auction_item_prices_all
2657: SET group_line_id = oneline.line_number
2658: WHERE auction_header_id = P_DOCUMENT_NUMBER
2659: AND group_line_id = oneline.requisition_line_id;
2660: UPDATE pon_auction_item_prices_all

Line 2660: UPDATE pon_auction_item_prices_all

2656: UPDATE pon_auction_item_prices_all
2657: SET group_line_id = oneline.line_number
2658: WHERE auction_header_id = P_DOCUMENT_NUMBER
2659: AND group_line_id = oneline.requisition_line_id;
2660: UPDATE pon_auction_item_prices_all
2661: SET clm_base_line_num = oneline.line_number
2662: WHERE auction_header_id = P_DOCUMENT_NUMBER
2663: AND clm_base_line_num = oneline.requisition_line_id;
2664: END LOOP;

Line 2705: UPDATE pon_auction_item_prices_all

2701: INTO l_line_number
2702: FROM pon_backing_requisitions
2703: WHERE auction_header_id = p_document_number
2704: AND requisition_line_id = p_req_line_clin;
2705: UPDATE pon_auction_item_prices_all
2706: SET group_line_id = l_line_number
2707: WHERE auction_header_id = p_document_number
2708: AND line_number = p_line_number;
2709: END IF;

Line 2724: UPDATE pon_auction_item_prices_all

2720: INTO l_line_number
2721: FROM pon_backing_requisitions
2722: WHERE auction_header_id = p_document_number
2723: AND requisition_line_id = p_req_line_opt;
2724: UPDATE pon_auction_item_prices_all
2725: SET clm_base_line_num = l_line_number
2726: WHERE auction_header_id = p_document_number
2727: AND line_number = p_line_number;
2728: END IF;