APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PON_AUC_PRICE_DIFFER_INT

Line 1341: l_auction_header_id pon_auc_price_differ_int.auction_header_id%TYPE;

1337: p_source VARCHAR2,
1338: p_batch_id NUMBER
1339: )AS
1340:
1341: l_auction_header_id pon_auc_price_differ_int.auction_header_id%TYPE;
1342: l_message_suffix VARCHAR2(2);
1343: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1344: l_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
1345:

Line 1354: FROM pon_auc_price_differ_int papd

1350:
1351:
1352: SELECT max(papd.auction_header_id)
1353: INTO l_auction_header_id
1354: FROM pon_auc_price_differ_int papd
1355: WHERE papd.batch_id = p_batch_id;
1356:
1357: SELECT pon_auction_pkg.get_message_suffix(doc.internal_name)
1358: INTO l_message_suffix

Line 1371: DELETE FROM pon_auc_price_differ_int

1367: FROM pon_auction_headers_all pah
1368: WHERE pah.auction_header_id = l_auction_header_id;
1369:
1370: IF ((l_contract_type <> 'BLANKET' AND l_contract_type <> 'CONTRACT') OR l_global_agreement <> 'Y') THEN
1371: DELETE FROM pon_auc_price_differ_int
1372: WHERE batch_id = p_batch_id;
1373: RETURN;
1374: END IF ;
1375:

Line 1385: UPDATE pon_auc_price_differ_int papdi

1381: END;
1382:
1383: -- update the interface table with the price_type values
1384: -- from the po_price_diff_lookups_v values
1385: UPDATE pon_auc_price_differ_int papdi
1386: SET price_type = (SELECT Nvl(MAX(ppdl.price_differential_type),'PRICE_TYPE_INVALID')
1387: FROM po_price_diff_lookups_v ppdl
1388: WHERE papdi.price_type_name = ppdl.price_differential_dsp(+)),
1389:

Line 1420: 'PON_AUC_PRICE_DIFFER_INT',

1416: VALUES
1417: (
1418: selected_batch_id,
1419: selected_interface_line_id,
1420: 'PON_AUC_PRICE_DIFFER_INT',
1421: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1422: 'PON_FIELD_MUST_BE_ENTERED',
1423: null
1424: )

Line 1447: 'PON_AUC_PRICE_DIFFER_INT',

1443: values
1444: (
1445: selected_batch_id,
1446: selected_interface_line_id,
1447: 'PON_AUC_PRICE_DIFFER_INT',
1448: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1449: 'PON_TYPE_VALUE_INVALID',
1450: selected_price_type_name
1451: )

Line 1459: pon_auc_price_differ_int papd

1455: papd.interface_line_id selected_interface_line_id,
1456: papd.multiplier selected_multiplier,
1457: papd.price_type_name selected_price_type_name
1458: FROM
1459: pon_auc_price_differ_int papd
1460: WHERE
1461: papd.batch_id = p_batch_id;
1462:
1463: -- Price Type errors will go into the interface table

Line 1478: 'PON_AUC_PRICE_DIFFER_INT',

1474:
1475: SELECT
1476: papd.batch_id,
1477: papd.interface_line_id,
1478: 'PON_AUC_PRICE_DIFFER_INT',
1479: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1480: 'PON_DUPLICATE_WARN_PRICE_TYPE',
1481: papd.price_type_name
1482: FROM pon_auc_price_differ_int papd,

Line 1482: FROM pon_auc_price_differ_int papd,

1478: 'PON_AUC_PRICE_DIFFER_INT',
1479: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1480: 'PON_DUPLICATE_WARN_PRICE_TYPE',
1481: papd.price_type_name
1482: FROM pon_auc_price_differ_int papd,
1483: pon_auc_price_differ_int papd2
1484: WHERE papd.batch_id = p_batch_id
1485: AND papd.batch_id = papd2.batch_id
1486: AND papd.interface_line_id = papd2.interface_line_id

Line 1483: pon_auc_price_differ_int papd2

1479: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1480: 'PON_DUPLICATE_WARN_PRICE_TYPE',
1481: papd.price_type_name
1482: FROM pon_auc_price_differ_int papd,
1483: pon_auc_price_differ_int papd2
1484: WHERE papd.batch_id = p_batch_id
1485: AND papd.batch_id = papd2.batch_id
1486: AND papd.interface_line_id = papd2.interface_line_id
1487: AND papd.price_type = papd2.price_type