APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PON_AUC_PRICE_DIFFER_INT

Line 1346: l_auction_header_id pon_auc_price_differ_int.auction_header_id%TYPE;

1342: p_source VARCHAR2,
1343: p_batch_id NUMBER
1344: )AS
1345:
1346: l_auction_header_id pon_auc_price_differ_int.auction_header_id%TYPE;
1347: l_message_suffix VARCHAR2(2);
1348: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1349: l_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
1350:

Line 1359: FROM pon_auc_price_differ_int papd

1355:
1356:
1357: SELECT max(papd.auction_header_id)
1358: INTO l_auction_header_id
1359: FROM pon_auc_price_differ_int papd
1360: WHERE papd.batch_id = p_batch_id;
1361:
1362: SELECT pon_auction_pkg.get_message_suffix(doc.internal_name)
1363: INTO l_message_suffix

Line 1376: DELETE FROM pon_auc_price_differ_int

1372: FROM pon_auction_headers_all pah
1373: WHERE pah.auction_header_id = l_auction_header_id;
1374:
1375: IF ((l_contract_type <> 'BLANKET' AND l_contract_type <> 'CONTRACT') OR l_global_agreement <> 'Y') THEN
1376: DELETE FROM pon_auc_price_differ_int
1377: WHERE batch_id = p_batch_id;
1378: RETURN;
1379: END IF ;
1380:

Line 1390: UPDATE pon_auc_price_differ_int papdi

1386: END;
1387:
1388: -- update the interface table with the price_type values
1389: -- from the po_price_diff_lookups_v values
1390: UPDATE pon_auc_price_differ_int papdi
1391: SET price_type = (SELECT Nvl(MAX(ppdl.price_differential_type),'PRICE_TYPE_INVALID')
1392: FROM po_price_diff_lookups_v ppdl
1393: WHERE papdi.price_type_name = ppdl.price_differential_dsp(+)),
1394:

Line 1425: 'PON_AUC_PRICE_DIFFER_INT',

1421: VALUES
1422: (
1423: selected_batch_id,
1424: selected_interface_line_id,
1425: 'PON_AUC_PRICE_DIFFER_INT',
1426: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1427: 'PON_FIELD_MUST_BE_ENTERED',
1428: null
1429: )

Line 1452: 'PON_AUC_PRICE_DIFFER_INT',

1448: values
1449: (
1450: selected_batch_id,
1451: selected_interface_line_id,
1452: 'PON_AUC_PRICE_DIFFER_INT',
1453: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1454: 'PON_TYPE_VALUE_INVALID',
1455: selected_price_type_name
1456: )

Line 1464: pon_auc_price_differ_int papd

1460: papd.interface_line_id selected_interface_line_id,
1461: papd.multiplier selected_multiplier,
1462: papd.price_type_name selected_price_type_name
1463: FROM
1464: pon_auc_price_differ_int papd
1465: WHERE
1466: papd.batch_id = p_batch_id;
1467:
1468: -- Price Type errors will go into the interface table

Line 1483: 'PON_AUC_PRICE_DIFFER_INT',

1479:
1480: SELECT
1481: papd.batch_id,
1482: papd.interface_line_id,
1483: 'PON_AUC_PRICE_DIFFER_INT',
1484: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1485: 'PON_DUPLICATE_WARN_PRICE_TYPE',
1486: papd.price_type_name
1487: FROM pon_auc_price_differ_int papd,

Line 1487: FROM pon_auc_price_differ_int papd,

1483: 'PON_AUC_PRICE_DIFFER_INT',
1484: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1485: 'PON_DUPLICATE_WARN_PRICE_TYPE',
1486: papd.price_type_name
1487: FROM pon_auc_price_differ_int papd,
1488: pon_auc_price_differ_int papd2
1489: WHERE papd.batch_id = p_batch_id
1490: AND papd.batch_id = papd2.batch_id
1491: AND papd.interface_line_id = papd2.interface_line_id

Line 1488: pon_auc_price_differ_int papd2

1484: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1485: 'PON_DUPLICATE_WARN_PRICE_TYPE',
1486: papd.price_type_name
1487: FROM pon_auc_price_differ_int papd,
1488: pon_auc_price_differ_int papd2
1489: WHERE papd.batch_id = p_batch_id
1490: AND papd.batch_id = papd2.batch_id
1491: AND papd.interface_line_id = papd2.interface_line_id
1492: AND papd.price_type = papd2.price_type