APPS.PO_NEGOTIATIONS_SV2 dependencies on PON_AUCTION_PO_PKG

Line 1362: pon_auction_po_pkg.get_attachment( x_auction_header_id,

1358: x_security_id := po_moac_utils_pvt.get_current_org_id; --
1359: if X_from_entity_name in ('PON_BID_ATTRIBUTES') then
1360: x_progress :='001';
1361: x_category_id_tmp := g_cat_TO_SUPPLIER; --
1362: pon_auction_po_pkg.get_attachment( x_auction_header_id,
1363: x_bid_number,
1364: x_bid_line_number,
1365: X_from_entity_name,
1366: x_description_tmp,

Line 1375: pon_auction_po_pkg.get_attachment( x_auction_header_id,

1371: elsif X_from_entity_name in ('PON_AUC_SUPPLIER_LINE_NOTES',
1372: 'PON_AUC_SUPPLIER_HEADER_NOTES') then
1373: x_progress :='002';
1374: x_category_id_tmp := g_cat_TO_SUPPLIER; --
1375: pon_auction_po_pkg.get_attachment( x_auction_header_id,
1376: x_bid_number,
1377: x_bid_line_number,
1378: X_from_entity_name,
1379: x_description_tmp,

Line 1388: pon_auction_po_pkg.get_attachment(

1384: ELSIF (X_from_entity_name = 'PON_AUC_PYMNT_SHIP_SUPP_NOTES') THEN
1385:
1386: x_category_id_tmp := g_cat_TO_SUPPLIER; -- to supplier
1387:
1388: pon_auction_po_pkg.get_attachment(
1389: pk1 => p_auction_payment_id
1390: , pk2 => NULL
1391: , pk3 => NULL
1392: , attachmenttype => X_from_entity_name

Line 1403: pon_auction_po_pkg.get_attachment( x_auction_header_id,

1399: --
1400: elsif X_from_entity_name in ('PON_BID_BUYER_NOTES') then
1401: x_progress :='003';
1402: x_category_id_tmp :=39;--Internal to PO,to buyer from sourcing perspecti
1403: pon_auction_po_pkg.get_attachment( x_auction_header_id,
1404: x_bid_number,
1405: x_bid_line_number,
1406: X_from_entity_name,
1407: x_description_tmp,

Line 1414: pon_auction_po_pkg.get_attachment( x_auction_header_id,

1410: x_errormessage);
1411: elsif X_from_entity_name in ('PON_BID_TOTAL_COST') then
1412: x_progress :='004';
1413: x_category_id_tmp := g_cat_TO_SUPPLIER; --
1414: pon_auction_po_pkg.get_attachment( x_auction_header_id,
1415: x_bid_number,
1416: x_bid_line_number,
1417: X_from_entity_name,
1418: x_description_tmp,

Line 1431: PON_AUCTION_PO_PKG.get_attachment

1427:
1428: x_progress := '005';
1429: x_category_id_tmp := g_cat_TO_SUPPLIER; --
1430:
1431: PON_AUCTION_PO_PKG.get_attachment
1432: ( pk1 => x_auction_header_id -- IN
1433: , pk2 => NULL -- IN
1434: , pk3 => x_auction_line_number -- IN
1435: , attachmentType => x_from_entity_name -- IN

Line 1489: PO_LOG.stmt(d_module, 10, 'CALLING PON_AUCTION_PO_PKG.get_attachment ');

1485: */
1486:
1487: IF l_size < l_max_size THEN
1488: IF (PO_LOG.d_stmt) THEN
1489: PO_LOG.stmt(d_module, 10, 'CALLING PON_AUCTION_PO_PKG.get_attachment ');
1490: END IF;
1491: PON_AUCTION_PO_PKG.get_attachment ( pk1 => x_auction_header_id -- IN
1492: , pk2 => x_bid_number -- IN
1493: , pk3 => NULL -- IN

Line 1491: PON_AUCTION_PO_PKG.get_attachment ( pk1 => x_auction_header_id -- IN

1487: IF l_size < l_max_size THEN
1488: IF (PO_LOG.d_stmt) THEN
1489: PO_LOG.stmt(d_module, 10, 'CALLING PON_AUCTION_PO_PKG.get_attachment ');
1490: END IF;
1491: PON_AUCTION_PO_PKG.get_attachment ( pk1 => x_auction_header_id -- IN
1492: , pk2 => x_bid_number -- IN
1493: , pk3 => NULL -- IN
1494: , attachmentType => x_from_entity_name -- IN
1495: , attachmentDesc => x_description_tmp -- OUT

Line 1503: PO_LOG.stmt(d_module, 10, 'CALLING PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACH_CLOB ');

1499: );
1500: c_text := NULL;
1501: ELSE
1502: IF (PO_LOG.d_stmt) THEN
1503: PO_LOG.stmt(d_module, 10, 'CALLING PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACH_CLOB ');
1504: END IF;
1505: PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACH_CLOB ( p_auction_header_id => x_auction_header_id -- IN
1506: , p_bid_number => x_bid_number -- IN
1507: , p_line_number => NULL -- IN

Line 1505: PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACH_CLOB ( p_auction_header_id => x_auction_header_id -- IN

1501: ELSE
1502: IF (PO_LOG.d_stmt) THEN
1503: PO_LOG.stmt(d_module, 10, 'CALLING PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACH_CLOB ');
1504: END IF;
1505: PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACH_CLOB ( p_auction_header_id => x_auction_header_id -- IN
1506: , p_bid_number => x_bid_number -- IN
1507: , p_line_number => NULL -- IN
1508: , p_attachmentDesc => x_description_tmp -- IN
1509: , p_attachment => c_text -- OUT