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.

[Home] [Help]

APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_AUCTION_HEADERS_ALL

Line 102: l_contract_type pon_auction_headers_all.contract_type%type;

98: p_auction_header_id IN NUMBER,
99: p_batch_id IN NUMBER) IS
100:
101: l_prev_max_line_number number;
102: l_contract_type pon_auction_headers_all.contract_type%type;
103: l_is_blanket_agreement VARCHAR2(1);
104: l_is_amendment VARCHAR2(1);
105:
106: l_module CONSTANT VARCHAR2(30) := 'DEFAULT_PREV_ROUND_AMEND_LINES';

Line 125: pon_auction_headers_all

121: l_prev_max_line_number,
122: l_contract_type,
123: l_is_amendment
124: from
125: pon_auction_headers_all
126: where auction_header_id = p_auction_header_id;
127:
128: IF (l_contract_type = 'BLANKET' or l_contract_type = 'CONTRACT') THEN
129: l_is_blanket_agreement := 'Y' ;

Line 379: pon_auction_headers_all pah

375: 'x'
376: from
377: pon_price_elements pe,
378: pon_item_prices_interface paip_int,
379: pon_auction_headers_all pah
380: where
381: paip_int.batch_id = p_batch_id
382: and pe_int.auction_line_number = pe.line_number
383: and pe_int.auction_header_id = pe.auction_header_id

Line 1053: l_uda_template_date pon_auction_headers_all.uda_template_date%TYPE;

1049: next_clin_num VARCHAR2(10);
1050: len NUMBER;
1051:
1052: -- uda template id
1053: l_uda_template_date pon_auction_headers_all.uda_template_date%TYPE;
1054: l_template_return_status VARCHAR2(10);
1055: l_template_err_msg VARCHAR2(50);
1056: l_uda_template_id pon_auction_item_prices_all.uda_template_id%TYPE;
1057:

Line 1066: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = g_auction_header_id;

1062:
1063:
1064: BEGIN
1065:
1066: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = g_auction_header_id;
1067:
1068: SELECT
1069: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1070: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules

Line 1262: pon_auction_headers_all pah

1258: Decode(l_is_fed,'Y', decode(p1.group_type,'GROUP',NULL,'LOT_LINE',NULL,p1.CLM_POP_DURATION), NULL),
1259: Decode(l_is_fed,'Y', decode(p1.group_type,'GROUP',NULL,'LOT_LINE',NULL,p1.CLM_POP_DURATION_UOM_CODE), NULL)
1260: from
1261: pon_item_prices_interface p1,
1262: pon_auction_headers_all pah
1263: where
1264: p1.batch_id = g_batch_id
1265: and p1.auction_header_id = pah.auction_header_id
1266: and nvl(p1.action,'+') = g_add_action;

Line 1359: FROM pon_auction_Headers_all

1355: -- updating uda_template_id for all lines
1356: BEGIN
1357:
1358: SELECT uda_template_date INTO l_uda_template_date
1359: FROM pon_auction_Headers_all
1360: WHERE auction_header_id = g_auction_header_id;
1361:
1362: l_uda_template_id := po_uda_data_util.get_template_id(
1363: p_functional_area => 'SOURCING',

Line 1688: pon_auction_headers_all pah1,

1684: g_user_id,
1685: sysdate,
1686: g_user_id
1687: FROM
1688: pon_auction_headers_all pah1,
1689: pon_auction_headers_all template,
1690: pon_attribute_scores template_attribute_score,
1691: pon_auction_attributes template_attribute,
1692: pon_auction_attributes auction_attributes,

Line 1689: pon_auction_headers_all template,

1685: sysdate,
1686: g_user_id
1687: FROM
1688: pon_auction_headers_all pah1,
1689: pon_auction_headers_all template,
1690: pon_attribute_scores template_attribute_score,
1691: pon_auction_attributes template_attribute,
1692: pon_auction_attributes auction_attributes,
1693: pon_auc_attributes_interface interface_attributes

Line 1729: l_bid_ranking pon_auction_headers_all.bid_ranking%type;

1725: ======================================================================*/
1726: PROCEDURE ADD_NEW_LINE_WITH_CHILDREN is
1727:
1728: l_module CONSTANT VARCHAR2(26) := 'ADD_NEW_LINE_WITH_CHILDREN';
1729: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
1730: l_template_id pon_auction_headers_all.template_id%type;
1731:
1732: BEGIN
1733: --{

Line 1730: l_template_id pon_auction_headers_all.template_id%type;

1726: PROCEDURE ADD_NEW_LINE_WITH_CHILDREN is
1727:
1728: l_module CONSTANT VARCHAR2(26) := 'ADD_NEW_LINE_WITH_CHILDREN';
1729: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
1730: l_template_id pon_auction_headers_all.template_id%type;
1731:
1732: BEGIN
1733: --{
1734: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1745: pon_auction_headers_all pah

1741: INTO
1742: l_bid_ranking,
1743: l_template_id
1744: FROM
1745: pon_auction_headers_all pah
1746: WHERE
1747: pah.auction_header_id = g_auction_header_id;
1748:
1749: add_lines;

Line 1794: l_contract_type pon_auction_headers_all.contract_type%TYPE;

1790: ======================================================================*/
1791: PROCEDURE UPDATE_LINES is
1792:
1793: l_module CONSTANT VARCHAR2(12) := 'UPDATE_LINES';
1794: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1795: l_last_amendment_update pon_auction_headers_all.amendment_number%TYPE;
1796: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;
1797:
1798: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1795: l_last_amendment_update pon_auction_headers_all.amendment_number%TYPE;

1791: PROCEDURE UPDATE_LINES is
1792:
1793: l_module CONSTANT VARCHAR2(12) := 'UPDATE_LINES';
1794: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1795: l_last_amendment_update pon_auction_headers_all.amendment_number%TYPE;
1796: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;
1797:
1798: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1799: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1796: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;

1792:
1793: l_module CONSTANT VARCHAR2(12) := 'UPDATE_LINES';
1794: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1795: l_last_amendment_update pon_auction_headers_all.amendment_number%TYPE;
1796: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;
1797:
1798: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1799: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1800: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;

Line 1871: pon_auction_headers_all

1867: l_contract_type,
1868: l_last_amendment_update,
1869: l_max_internal_line_num
1870: FROM
1871: pon_auction_headers_all
1872: WHERE
1873: auction_header_id = g_auction_header_id;
1874:
1875: -- delete category descriptors if ip category has changed

Line 2418: l_bid_ranking pon_auction_headers_all.bid_ranking%type;

2414: ======================================================================*/
2415: PROCEDURE UPDATE_LINE_ATTRIBUTES is
2416:
2417: l_module CONSTANT VARCHAR2(22) := 'UPDATE_LINE_ATTRIBUTES';
2418: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2419: l_max_neg_line_attr_seq_num number;
2420: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2421: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2422: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2448: pon_auction_headers_all pah

2444: pah.bid_ranking
2445: INTO
2446: l_bid_ranking
2447: FROM
2448: pon_auction_headers_all pah
2449: WHERE
2450: pah.auction_header_id = g_auction_header_id;
2451:
2452: if ( g_attribute_score_enabled_flag = 'Y' ) then

Line 2885: l_number_of_lines pon_auction_headers_all.number_of_lines%TYPE;

2881: AND paip.attachment_url IS NOT NULL
2882: AND paip.attachment_desc IS NOT NULL;
2883:
2884: l_module CONSTANT VARCHAR2(32) := 'SYNCH_FROM_INTERFACE';
2885: l_number_of_lines pon_auction_headers_all.number_of_lines%TYPE;
2886: l_max_display_number pon_auction_headers_all.last_line_number%TYPE;
2887: l_progress varchar2(200);
2888:
2889: -- for attachments

Line 2886: l_max_display_number pon_auction_headers_all.last_line_number%TYPE;

2882: AND paip.attachment_desc IS NOT NULL;
2883:
2884: l_module CONSTANT VARCHAR2(32) := 'SYNCH_FROM_INTERFACE';
2885: l_number_of_lines pon_auction_headers_all.number_of_lines%TYPE;
2886: l_max_display_number pon_auction_headers_all.last_line_number%TYPE;
2887: l_progress varchar2(200);
2888:
2889: -- for attachments
2890: l_sequence NUMBER :=0;

Line 2892: l_line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%TYPE;

2888:
2889: -- for attachments
2890: l_sequence NUMBER :=0;
2891:
2892: l_line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%TYPE;
2893: l_contract_type pon_auction_headers_all.contract_type%TYPE;
2894: l_internal_name pon_auc_doctypes.internal_name%TYPE;
2895: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2896: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;

Line 2893: l_contract_type pon_auction_headers_all.contract_type%TYPE;

2889: -- for attachments
2890: l_sequence NUMBER :=0;
2891:
2892: l_line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%TYPE;
2893: l_contract_type pon_auction_headers_all.contract_type%TYPE;
2894: l_internal_name pon_auc_doctypes.internal_name%TYPE;
2895: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2896: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2897: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;

Line 2895: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;

2891:
2892: l_line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%TYPE;
2893: l_contract_type pon_auction_headers_all.contract_type%TYPE;
2894: l_internal_name pon_auc_doctypes.internal_name%TYPE;
2895: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2896: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2897: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2898: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2899: l_auction_round_number pon_auction_headers_all.auction_round_number%type;

Line 2896: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;

2892: l_line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%TYPE;
2893: l_contract_type pon_auction_headers_all.contract_type%TYPE;
2894: l_internal_name pon_auc_doctypes.internal_name%TYPE;
2895: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2896: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2897: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2898: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2899: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2900: l_amendment_number pon_auction_headers_all.amendment_number%type;

Line 2897: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;

2893: l_contract_type pon_auction_headers_all.contract_type%TYPE;
2894: l_internal_name pon_auc_doctypes.internal_name%TYPE;
2895: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2896: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2897: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2898: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2899: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2900: l_amendment_number pon_auction_headers_all.amendment_number%type;
2901: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;

Line 2898: l_bid_ranking pon_auction_headers_all.bid_ranking%type;

2894: l_internal_name pon_auc_doctypes.internal_name%TYPE;
2895: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2896: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2897: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2898: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2899: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2900: l_amendment_number pon_auction_headers_all.amendment_number%type;
2901: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2902: l_template_id pon_auction_headers_all.template_id%type;

Line 2899: l_auction_round_number pon_auction_headers_all.auction_round_number%type;

2895: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2896: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2897: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2898: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2899: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2900: l_amendment_number pon_auction_headers_all.amendment_number%type;
2901: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2902: l_template_id pon_auction_headers_all.template_id%type;
2903: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;

Line 2900: l_amendment_number pon_auction_headers_all.amendment_number%type;

2896: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2897: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2898: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2899: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2900: l_amendment_number pon_auction_headers_all.amendment_number%type;
2901: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2902: l_template_id pon_auction_headers_all.template_id%type;
2903: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2904: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;

Line 2901: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;

2897: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2898: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2899: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2900: l_amendment_number pon_auction_headers_all.amendment_number%type;
2901: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2902: l_template_id pon_auction_headers_all.template_id%type;
2903: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2904: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2905: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;

Line 2902: l_template_id pon_auction_headers_all.template_id%type;

2898: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2899: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2900: l_amendment_number pon_auction_headers_all.amendment_number%type;
2901: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2902: l_template_id pon_auction_headers_all.template_id%type;
2903: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2904: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2905: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;
2906: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;

Line 2903: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;

2899: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2900: l_amendment_number pon_auction_headers_all.amendment_number%type;
2901: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2902: l_template_id pon_auction_headers_all.template_id%type;
2903: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2904: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2905: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;
2906: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
2907: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;

Line 2904: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;

2900: l_amendment_number pon_auction_headers_all.amendment_number%type;
2901: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2902: l_template_id pon_auction_headers_all.template_id%type;
2903: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2904: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2905: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;
2906: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
2907: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;
2908:

Line 2905: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;

2901: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2902: l_template_id pon_auction_headers_all.template_id%type;
2903: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2904: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2905: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;
2906: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
2907: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;
2908:
2909: BEGIN

Line 2906: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;

2902: l_template_id pon_auction_headers_all.template_id%type;
2903: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2904: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2905: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;
2906: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
2907: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;
2908:
2909: BEGIN
2910: --{

Line 2907: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;

2903: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2904: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2905: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;
2906: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
2907: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;
2908:
2909: BEGIN
2910: --{
2911: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2960: pon_auction_headers_all pah,

2956: l_max_internal_line_num,
2957: l_first_line_close_date,
2958: l_staggered_closing_interval
2959: from
2960: pon_auction_headers_all pah,
2961: pon_auc_doctypes doctypes
2962: where
2963: auction_header_id = p_auction_header_id
2964: and doctypes.doctype_id = pah.doctype_id;

Line 3272: l_prev_amend_auc_id pon_auction_headers_all.auction_header_id_prev_amend%TYPE;

3268: l_module CONSTANT VARCHAR2(32) := 'SYNCH_PAYMENTS_FROM_INTERFACE';
3269: l_progress varchar2(200);
3270: l_sequence NUMBER :=0;
3271: l_previous_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
3272: l_prev_amend_auc_id pon_auction_headers_all.auction_header_id_prev_amend%TYPE;
3273: l_supplier_modify_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE;
3274:
3275:
3276: CURSOR l_attachment_cursor

Line 3273: l_supplier_modify_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE;

3269: l_progress varchar2(200);
3270: l_sequence NUMBER :=0;
3271: l_previous_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
3272: l_prev_amend_auc_id pon_auction_headers_all.auction_header_id_prev_amend%TYPE;
3273: l_supplier_modify_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE;
3274:
3275:
3276: CURSOR l_attachment_cursor
3277: IS

Line 3332: PON_AUCTION_HEADERS_ALL pah,

3328: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, porg.organization_id)) PROJECT_EXP_ORGANIZATION_ID,
3329: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, ppi.PROJECT_EXPENDITURE_ITEM_DATE)) PROJECT_EXPENDITURE_ITEM_DATE
3330: FROM PON_AUC_PAYMENTS_INTERFACE ppi,
3331: PON_AUCTION_ITEM_PRICES_ALL pai,
3332: PON_AUCTION_HEADERS_ALL pah,
3333: FND_USER fu,
3334: HR_LOCATIONS_ALL hrl,
3335: MTL_UNITS_OF_MEASURE uom,
3336: PO_LOOKUP_CODES fl,

Line 3473: FROM PON_AUCTION_HEADERS_ALL pah

3469: SELECT pah.auction_header_id_prev_amend,
3470: pah.supplier_enterable_pymt_flag
3471: INTO l_prev_amend_auc_id,
3472: l_supplier_modify_flag
3473: FROM PON_AUCTION_HEADERS_ALL pah
3474: WHERE auction_header_id = p_auction_header_id;
3475:
3476: IF l_prev_amend_auc_id IS NOT NULL THEN
3477: --Update pon_auction_item_prices_all to set lastupdatedate