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_CP_INTRFAC_TO_TRANSACTION dependencies on PON_AUCTION_HEADERS_ALL

Line 100: l_contract_type pon_auction_headers_all.contract_type%type;

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

Line 123: pon_auction_headers_all

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

Line 374: pon_auction_headers_all pah

370: 'x'
371: from
372: pon_price_elements pe,
373: pon_item_prices_interface paip_int,
374: pon_auction_headers_all pah
375: where
376: paip_int.batch_id = p_batch_id
377: and pe_int.auction_line_number = pe.line_number
378: and pe_int.auction_header_id = pe.auction_header_id

Line 1146: pon_auction_headers_all pah

1142: g_user_id,
1143: fnd_global.login_id
1144: from
1145: pon_item_prices_interface p1,
1146: pon_auction_headers_all pah
1147: where
1148: p1.batch_id = g_batch_id
1149: and p1.auction_header_id = pah.auction_header_id
1150: and nvl(p1.action,'+') = g_add_action;

Line 1466: pon_auction_headers_all pah1,

1462: g_user_id,
1463: sysdate,
1464: g_user_id
1465: FROM
1466: pon_auction_headers_all pah1,
1467: pon_auction_headers_all template,
1468: pon_attribute_scores template_attribute_score,
1469: pon_auction_attributes template_attribute,
1470: pon_auction_attributes auction_attributes,

Line 1467: pon_auction_headers_all template,

1463: sysdate,
1464: g_user_id
1465: FROM
1466: pon_auction_headers_all pah1,
1467: pon_auction_headers_all template,
1468: pon_attribute_scores template_attribute_score,
1469: pon_auction_attributes template_attribute,
1470: pon_auction_attributes auction_attributes,
1471: pon_auc_attributes_interface interface_attributes

Line 1507: l_bid_ranking pon_auction_headers_all.bid_ranking%type;

1503: ======================================================================*/
1504: PROCEDURE ADD_NEW_LINE_WITH_CHILDREN is
1505:
1506: l_module CONSTANT VARCHAR2(26) := 'ADD_NEW_LINE_WITH_CHILDREN';
1507: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
1508: l_template_id pon_auction_headers_all.template_id%type;
1509:
1510: BEGIN
1511: --{

Line 1508: l_template_id pon_auction_headers_all.template_id%type;

1504: PROCEDURE ADD_NEW_LINE_WITH_CHILDREN is
1505:
1506: l_module CONSTANT VARCHAR2(26) := 'ADD_NEW_LINE_WITH_CHILDREN';
1507: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
1508: l_template_id pon_auction_headers_all.template_id%type;
1509:
1510: BEGIN
1511: --{
1512: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1523: pon_auction_headers_all pah

1519: INTO
1520: l_bid_ranking,
1521: l_template_id
1522: FROM
1523: pon_auction_headers_all pah
1524: WHERE
1525: pah.auction_header_id = g_auction_header_id;
1526:
1527: add_lines;

Line 1572: l_contract_type pon_auction_headers_all.contract_type%TYPE;

1568: ======================================================================*/
1569: PROCEDURE UPDATE_LINES is
1570:
1571: l_module CONSTANT VARCHAR2(12) := 'UPDATE_LINES';
1572: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1573: l_last_amendment_update pon_auction_headers_all.amendment_number%TYPE;
1574: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;
1575:
1576: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 1573: l_last_amendment_update pon_auction_headers_all.amendment_number%TYPE;

1569: PROCEDURE UPDATE_LINES is
1570:
1571: l_module CONSTANT VARCHAR2(12) := 'UPDATE_LINES';
1572: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1573: l_last_amendment_update pon_auction_headers_all.amendment_number%TYPE;
1574: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;
1575:
1576: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1577: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;

Line 1574: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;

1570:
1571: l_module CONSTANT VARCHAR2(12) := 'UPDATE_LINES';
1572: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1573: l_last_amendment_update pon_auction_headers_all.amendment_number%TYPE;
1574: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%TYPE;
1575:
1576: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
1577: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
1578: l_item_description PON_NEG_COPY_DATATYPES_GRP.VARCHAR2500_TYPE;

Line 1638: pon_auction_headers_all

1634: l_contract_type,
1635: l_last_amendment_update,
1636: l_max_internal_line_num
1637: FROM
1638: pon_auction_headers_all
1639: WHERE
1640: auction_header_id = g_auction_header_id;
1641:
1642: -- delete category descriptors if ip category has changed

Line 2157: l_bid_ranking pon_auction_headers_all.bid_ranking%type;

2153: ======================================================================*/
2154: PROCEDURE UPDATE_LINE_ATTRIBUTES is
2155:
2156: l_module CONSTANT VARCHAR2(22) := 'UPDATE_LINE_ATTRIBUTES';
2157: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2158: l_max_neg_line_attr_seq_num number;
2159: l_attribute_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2160: l_attribute_name PON_NEG_COPY_DATATYPES_GRP.VARCHAR4000_TYPE;
2161: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

Line 2187: pon_auction_headers_all pah

2183: pah.bid_ranking
2184: INTO
2185: l_bid_ranking
2186: FROM
2187: pon_auction_headers_all pah
2188: WHERE
2189: pah.auction_header_id = g_auction_header_id;
2190:
2191: if ( g_attribute_score_enabled_flag = 'Y' ) then

Line 2624: l_number_of_lines pon_auction_headers_all.number_of_lines%TYPE;

2620: AND paip.attachment_url IS NOT NULL
2621: AND paip.attachment_desc IS NOT NULL;
2622:
2623: l_module CONSTANT VARCHAR2(32) := 'SYNCH_FROM_INTERFACE';
2624: l_number_of_lines pon_auction_headers_all.number_of_lines%TYPE;
2625: l_max_display_number pon_auction_headers_all.last_line_number%TYPE;
2626: l_progress varchar2(200);
2627:
2628: -- for attachments

Line 2625: l_max_display_number pon_auction_headers_all.last_line_number%TYPE;

2621: AND paip.attachment_desc IS NOT NULL;
2622:
2623: l_module CONSTANT VARCHAR2(32) := 'SYNCH_FROM_INTERFACE';
2624: l_number_of_lines pon_auction_headers_all.number_of_lines%TYPE;
2625: l_max_display_number pon_auction_headers_all.last_line_number%TYPE;
2626: l_progress varchar2(200);
2627:
2628: -- for attachments
2629: l_sequence NUMBER :=0;

Line 2631: l_line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%TYPE;

2627:
2628: -- for attachments
2629: l_sequence NUMBER :=0;
2630:
2631: l_line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%TYPE;
2632: l_contract_type pon_auction_headers_all.contract_type%TYPE;
2633: l_internal_name pon_auc_doctypes.internal_name%TYPE;
2634: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2635: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;

Line 2632: l_contract_type pon_auction_headers_all.contract_type%TYPE;

2628: -- for attachments
2629: l_sequence NUMBER :=0;
2630:
2631: l_line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%TYPE;
2632: l_contract_type pon_auction_headers_all.contract_type%TYPE;
2633: l_internal_name pon_auc_doctypes.internal_name%TYPE;
2634: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2635: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2636: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;

Line 2634: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;

2630:
2631: l_line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%TYPE;
2632: l_contract_type pon_auction_headers_all.contract_type%TYPE;
2633: l_internal_name pon_auc_doctypes.internal_name%TYPE;
2634: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2635: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2636: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2637: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2638: l_auction_round_number pon_auction_headers_all.auction_round_number%type;

Line 2635: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;

2631: l_line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%TYPE;
2632: l_contract_type pon_auction_headers_all.contract_type%TYPE;
2633: l_internal_name pon_auc_doctypes.internal_name%TYPE;
2634: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2635: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2636: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2637: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2638: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2639: l_amendment_number pon_auction_headers_all.amendment_number%type;

Line 2636: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;

2632: l_contract_type pon_auction_headers_all.contract_type%TYPE;
2633: l_internal_name pon_auc_doctypes.internal_name%TYPE;
2634: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2635: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2636: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2637: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2638: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2639: l_amendment_number pon_auction_headers_all.amendment_number%type;
2640: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;

Line 2637: l_bid_ranking pon_auction_headers_all.bid_ranking%type;

2633: l_internal_name pon_auc_doctypes.internal_name%TYPE;
2634: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2635: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2636: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2637: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2638: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2639: l_amendment_number pon_auction_headers_all.amendment_number%type;
2640: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2641: l_template_id pon_auction_headers_all.template_id%type;

Line 2638: l_auction_round_number pon_auction_headers_all.auction_round_number%type;

2634: l_is_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
2635: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2636: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2637: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2638: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2639: l_amendment_number pon_auction_headers_all.amendment_number%type;
2640: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2641: l_template_id pon_auction_headers_all.template_id%type;
2642: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;

Line 2639: l_amendment_number pon_auction_headers_all.amendment_number%type;

2635: l_price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE;
2636: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2637: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2638: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2639: l_amendment_number pon_auction_headers_all.amendment_number%type;
2640: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2641: l_template_id pon_auction_headers_all.template_id%type;
2642: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2643: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;

Line 2640: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;

2636: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
2637: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2638: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2639: l_amendment_number pon_auction_headers_all.amendment_number%type;
2640: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2641: l_template_id pon_auction_headers_all.template_id%type;
2642: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2643: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2644: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;

Line 2641: l_template_id pon_auction_headers_all.template_id%type;

2637: l_bid_ranking pon_auction_headers_all.bid_ranking%type;
2638: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2639: l_amendment_number pon_auction_headers_all.amendment_number%type;
2640: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2641: l_template_id pon_auction_headers_all.template_id%type;
2642: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2643: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2644: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;
2645: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;

Line 2642: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;

2638: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2639: l_amendment_number pon_auction_headers_all.amendment_number%type;
2640: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2641: l_template_id pon_auction_headers_all.template_id%type;
2642: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2643: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2644: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;
2645: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
2646: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;

Line 2643: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;

2639: l_amendment_number pon_auction_headers_all.amendment_number%type;
2640: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2641: l_template_id pon_auction_headers_all.template_id%type;
2642: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2643: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2644: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;
2645: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
2646: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;
2647:

Line 2644: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;

2640: l_large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type;
2641: l_template_id pon_auction_headers_all.template_id%type;
2642: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2643: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2644: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;
2645: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
2646: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;
2647:
2648: BEGIN

Line 2645: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;

2641: l_template_id pon_auction_headers_all.template_id%type;
2642: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2643: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2644: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;
2645: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
2646: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;
2647:
2648: BEGIN
2649: --{

Line 2646: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;

2642: l_supplier_view_type pon_auction_headers_all.supplier_view_type%type;
2643: l_full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%type;
2644: l_max_internal_line_num pon_auction_headers_all.max_internal_line_num%type;
2645: l_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
2646: l_staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE;
2647:
2648: BEGIN
2649: --{
2650: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2699: pon_auction_headers_all pah,

2695: l_max_internal_line_num,
2696: l_first_line_close_date,
2697: l_staggered_closing_interval
2698: from
2699: pon_auction_headers_all pah,
2700: pon_auc_doctypes doctypes
2701: where
2702: auction_header_id = p_auction_header_id
2703: and doctypes.doctype_id = pah.doctype_id;

Line 2977: l_prev_amend_auc_id pon_auction_headers_all.auction_header_id_prev_amend%TYPE;

2973: l_module CONSTANT VARCHAR2(32) := 'SYNCH_PAYMENTS_FROM_INTERFACE';
2974: l_progress varchar2(200);
2975: l_sequence NUMBER :=0;
2976: l_previous_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
2977: l_prev_amend_auc_id pon_auction_headers_all.auction_header_id_prev_amend%TYPE;
2978: l_supplier_modify_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE;
2979:
2980:
2981: CURSOR l_attachment_cursor

Line 2978: l_supplier_modify_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE;

2974: l_progress varchar2(200);
2975: l_sequence NUMBER :=0;
2976: l_previous_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
2977: l_prev_amend_auc_id pon_auction_headers_all.auction_header_id_prev_amend%TYPE;
2978: l_supplier_modify_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE;
2979:
2980:
2981: CURSOR l_attachment_cursor
2982: IS

Line 3037: PON_AUCTION_HEADERS_ALL pah,

3033: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, porg.organization_id)) PROJECT_EXP_ORGANIZATION_ID,
3034: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, ppi.PROJECT_EXPENDITURE_ITEM_DATE)) PROJECT_EXPENDITURE_ITEM_DATE
3035: FROM PON_AUC_PAYMENTS_INTERFACE ppi,
3036: PON_AUCTION_ITEM_PRICES_ALL pai,
3037: PON_AUCTION_HEADERS_ALL pah,
3038: FND_USER fu,
3039: HR_LOCATIONS_ALL hrl,
3040: MTL_UNITS_OF_MEASURE uom,
3041: PO_LOOKUP_CODES fl,

Line 3178: FROM PON_AUCTION_HEADERS_ALL pah

3174: SELECT pah.auction_header_id_prev_amend,
3175: pah.supplier_enterable_pymt_flag
3176: INTO l_prev_amend_auc_id,
3177: l_supplier_modify_flag
3178: FROM PON_AUCTION_HEADERS_ALL pah
3179: WHERE auction_header_id = p_auction_header_id;
3180:
3181: IF l_prev_amend_auc_id IS NOT NULL THEN
3182: --Update pon_auction_item_prices_all to set lastupdatedate