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_AUCTION_CREATE_PO_PKG dependencies on DBMS_SQL

Line 533: l_req_line_id_col dbms_sql.number_table;

529: l_orig_req_line NUMBER;
530: l_req_qty NUMBER;
531: l_num_messages NUMBER;
532: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
533: l_req_line_id_col dbms_sql.number_table;
534: lock_not_acquired EXCEPTION;
535: l_user_id NUMBER;
536:
537: PRAGMA EXCEPTION_INIT(lock_not_acquired, -54);

Line 893: l_bid_number_col dbms_sql.number_table;

889: l_reqIdx NUMBER;
890: l_currentReqIdx NUMBER;
891: l_insert_index NUMBER;
892: l_count NUMBER;
893: l_bid_number_col dbms_sql.number_table;
894: l_award_col dbms_sql.number_table;
895: l_req_line_id_col dbms_sql.number_table;
896: l_req_header_id_col dbms_sql.number_table;
897: l_req_quantity_col dbms_sql.number_table;

Line 894: l_award_col dbms_sql.number_table;

890: l_currentReqIdx NUMBER;
891: l_insert_index NUMBER;
892: l_count NUMBER;
893: l_bid_number_col dbms_sql.number_table;
894: l_award_col dbms_sql.number_table;
895: l_req_line_id_col dbms_sql.number_table;
896: l_req_header_id_col dbms_sql.number_table;
897: l_req_quantity_col dbms_sql.number_table;
898: l_req_new_quantity_col dbms_sql.number_table;

Line 895: l_req_line_id_col dbms_sql.number_table;

891: l_insert_index NUMBER;
892: l_count NUMBER;
893: l_bid_number_col dbms_sql.number_table;
894: l_award_col dbms_sql.number_table;
895: l_req_line_id_col dbms_sql.number_table;
896: l_req_header_id_col dbms_sql.number_table;
897: l_req_quantity_col dbms_sql.number_table;
898: l_req_new_quantity_col dbms_sql.number_table;
899: l_bid_number_insertcol dbms_sql.number_table;

Line 896: l_req_header_id_col dbms_sql.number_table;

892: l_count NUMBER;
893: l_bid_number_col dbms_sql.number_table;
894: l_award_col dbms_sql.number_table;
895: l_req_line_id_col dbms_sql.number_table;
896: l_req_header_id_col dbms_sql.number_table;
897: l_req_quantity_col dbms_sql.number_table;
898: l_req_new_quantity_col dbms_sql.number_table;
899: l_bid_number_insertcol dbms_sql.number_table;
900: l_bid_line_number_insertcol dbms_sql.number_table;

Line 897: l_req_quantity_col dbms_sql.number_table;

893: l_bid_number_col dbms_sql.number_table;
894: l_award_col dbms_sql.number_table;
895: l_req_line_id_col dbms_sql.number_table;
896: l_req_header_id_col dbms_sql.number_table;
897: l_req_quantity_col dbms_sql.number_table;
898: l_req_new_quantity_col dbms_sql.number_table;
899: l_bid_number_insertcol dbms_sql.number_table;
900: l_bid_line_number_insertcol dbms_sql.number_table;
901: l_orig_req_line_insertcol dbms_sql.number_table;

Line 898: l_req_new_quantity_col dbms_sql.number_table;

894: l_award_col dbms_sql.number_table;
895: l_req_line_id_col dbms_sql.number_table;
896: l_req_header_id_col dbms_sql.number_table;
897: l_req_quantity_col dbms_sql.number_table;
898: l_req_new_quantity_col dbms_sql.number_table;
899: l_bid_number_insertcol dbms_sql.number_table;
900: l_bid_line_number_insertcol dbms_sql.number_table;
901: l_orig_req_line_insertcol dbms_sql.number_table;
902: l_orig_req_header_insertcol dbms_sql.number_table;

Line 899: l_bid_number_insertcol dbms_sql.number_table;

895: l_req_line_id_col dbms_sql.number_table;
896: l_req_header_id_col dbms_sql.number_table;
897: l_req_quantity_col dbms_sql.number_table;
898: l_req_new_quantity_col dbms_sql.number_table;
899: l_bid_number_insertcol dbms_sql.number_table;
900: l_bid_line_number_insertcol dbms_sql.number_table;
901: l_orig_req_line_insertcol dbms_sql.number_table;
902: l_orig_req_header_insertcol dbms_sql.number_table;
903: l_allocated_qty_insertcol dbms_sql.number_table;

Line 900: l_bid_line_number_insertcol dbms_sql.number_table;

896: l_req_header_id_col dbms_sql.number_table;
897: l_req_quantity_col dbms_sql.number_table;
898: l_req_new_quantity_col dbms_sql.number_table;
899: l_bid_number_insertcol dbms_sql.number_table;
900: l_bid_line_number_insertcol dbms_sql.number_table;
901: l_orig_req_line_insertcol dbms_sql.number_table;
902: l_orig_req_header_insertcol dbms_sql.number_table;
903: l_allocated_qty_insertcol dbms_sql.number_table;
904: l_auction_header_id_insertcol dbms_sql.number_table;

Line 901: l_orig_req_line_insertcol dbms_sql.number_table;

897: l_req_quantity_col dbms_sql.number_table;
898: l_req_new_quantity_col dbms_sql.number_table;
899: l_bid_number_insertcol dbms_sql.number_table;
900: l_bid_line_number_insertcol dbms_sql.number_table;
901: l_orig_req_line_insertcol dbms_sql.number_table;
902: l_orig_req_header_insertcol dbms_sql.number_table;
903: l_allocated_qty_insertcol dbms_sql.number_table;
904: l_auction_header_id_insertcol dbms_sql.number_table;
905: l_empty_table dbms_sql.number_table;

Line 902: l_orig_req_header_insertcol dbms_sql.number_table;

898: l_req_new_quantity_col dbms_sql.number_table;
899: l_bid_number_insertcol dbms_sql.number_table;
900: l_bid_line_number_insertcol dbms_sql.number_table;
901: l_orig_req_line_insertcol dbms_sql.number_table;
902: l_orig_req_header_insertcol dbms_sql.number_table;
903: l_allocated_qty_insertcol dbms_sql.number_table;
904: l_auction_header_id_insertcol dbms_sql.number_table;
905: l_empty_table dbms_sql.number_table;
906: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 903: l_allocated_qty_insertcol dbms_sql.number_table;

899: l_bid_number_insertcol dbms_sql.number_table;
900: l_bid_line_number_insertcol dbms_sql.number_table;
901: l_orig_req_line_insertcol dbms_sql.number_table;
902: l_orig_req_header_insertcol dbms_sql.number_table;
903: l_allocated_qty_insertcol dbms_sql.number_table;
904: l_auction_header_id_insertcol dbms_sql.number_table;
905: l_empty_table dbms_sql.number_table;
906: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
907: l_user_id NUMBER;

Line 904: l_auction_header_id_insertcol dbms_sql.number_table;

900: l_bid_line_number_insertcol dbms_sql.number_table;
901: l_orig_req_line_insertcol dbms_sql.number_table;
902: l_orig_req_header_insertcol dbms_sql.number_table;
903: l_allocated_qty_insertcol dbms_sql.number_table;
904: l_auction_header_id_insertcol dbms_sql.number_table;
905: l_empty_table dbms_sql.number_table;
906: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
907: l_user_id NUMBER;
908: l_login_id NUMBER;

Line 905: l_empty_table dbms_sql.number_table;

901: l_orig_req_line_insertcol dbms_sql.number_table;
902: l_orig_req_header_insertcol dbms_sql.number_table;
903: l_allocated_qty_insertcol dbms_sql.number_table;
904: l_auction_header_id_insertcol dbms_sql.number_table;
905: l_empty_table dbms_sql.number_table;
906: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
907: l_user_id NUMBER;
908: l_login_id NUMBER;
909: l_bid_price_col dbms_sql.number_table;

Line 909: l_bid_price_col dbms_sql.number_table;

905: l_empty_table dbms_sql.number_table;
906: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
907: l_user_id NUMBER;
908: l_login_id NUMBER;
909: l_bid_price_col dbms_sql.number_table;
910: l_order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE;
911: l_purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE;
912: l_contract_type pon_auction_headers_all.contract_type%TYPE;
913:

Line 3238: l_cursorName := DBMS_SQL.Open_Cursor;

3234: from pon_auction_headers_all
3235: where auction_header_id = p_auction_header_id;
3236:
3237:
3238: l_cursorName := DBMS_SQL.Open_Cursor;
3239: l_cur_interface_line_id := -9999;
3240:
3241: OPEN descriptors;
3242: LOOP

Line 3282: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);

3278: ')';
3279:
3280: log_message(l_po_attr_values_stmt);
3281:
3282: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);
3283:
3284: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
3285: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3286: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);

Line 3284: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);

3280: log_message(l_po_attr_values_stmt);
3281:
3282: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);
3283:
3284: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
3285: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3286: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
3287: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3288: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);

Line 3285: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);

3281:
3282: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);
3283:
3284: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
3285: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3286: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
3287: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3288: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3289: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);

Line 3286: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);

3282: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);
3283:
3284: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
3285: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3286: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
3287: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3288: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3289: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3290: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);

Line 3287: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);

3283:
3284: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
3285: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3286: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
3287: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3288: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3289: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3290: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
3291: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);

Line 3288: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);

3284: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
3285: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3286: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
3287: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3288: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3289: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3290: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
3291: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
3292: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);

Line 3289: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);

3285: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3286: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
3287: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3288: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3289: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3290: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
3291: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
3292: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
3293: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);

Line 3290: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);

3286: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
3287: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3288: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3289: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3290: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
3291: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
3292: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
3293: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
3294: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);

Line 3291: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);

3287: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3288: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3289: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3290: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
3291: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
3292: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
3293: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
3294: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
3295:

Line 3292: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);

3288: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3289: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3290: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
3291: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
3292: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
3293: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
3294: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
3295:
3296: FOR i in 1 .. l_numValuesCount

Line 3293: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);

3289: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3290: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
3291: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
3292: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
3293: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
3294: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
3295:
3296: FOR i in 1 .. l_numValuesCount
3297: LOOP

Line 3294: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);

3290: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
3291: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
3292: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
3293: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
3294: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
3295:
3296: FOR i in 1 .. l_numValuesCount
3297: LOOP
3298: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset), l_numValues(i));

Line 3298: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset), l_numValues(i));

3294: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
3295:
3296: FOR i in 1 .. l_numValuesCount
3297: LOOP
3298: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset), l_numValues(i));
3299: END LOOP;
3300:
3301: FOR i in 1 ..l_txtValuesCount
3302: LOOP

Line 3303: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset+l_numValuesCount), l_txtValues(i));

3299: END LOOP;
3300:
3301: FOR i in 1 ..l_txtValuesCount
3302: LOOP
3303: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset+l_numValuesCount), l_txtValues(i));
3304: END LOOP;
3305:
3306: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
3307:

Line 3306: l_cursorResult := DBMS_SQL.Execute(l_cursorName);

3302: LOOP
3303: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset+l_numValuesCount), l_txtValues(i));
3304: END LOOP;
3305:
3306: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
3307:
3308: END IF;
3309:
3310: -- process translateable text descriptors

Line 3348: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);

3344: ')';
3345:
3346: log_message(l_po_attr_values_tlp_stmt);
3347:
3348: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);
3349:
3350: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
3351: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3352: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);

Line 3350: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);

3346: log_message(l_po_attr_values_tlp_stmt);
3347:
3348: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);
3349:
3350: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
3351: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3352: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
3353: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3354: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);

Line 3351: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);

3347:
3348: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);
3349:
3350: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
3351: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3352: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
3353: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3354: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3355: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);

Line 3352: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);

3348: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);
3349:
3350: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
3351: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3352: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
3353: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3354: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3355: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3356: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);

Line 3353: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);

3349:
3350: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
3351: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3352: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
3353: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3354: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3355: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3356: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
3357: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);

Line 3354: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);

3350: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
3351: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3352: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
3353: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3354: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3355: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3356: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
3357: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
3358: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);

Line 3355: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);

3351: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
3352: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
3353: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3354: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3355: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3356: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
3357: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
3358: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
3359: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);

Line 3356: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);

3352: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
3353: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3354: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3355: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3356: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
3357: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
3358: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
3359: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
3360: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);

Line 3357: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);

3353: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
3354: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3355: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3356: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
3357: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
3358: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
3359: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
3360: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
3361: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);

Line 3358: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);

3354: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
3355: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3356: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
3357: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
3358: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
3359: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
3360: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
3361: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);
3362: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);

Line 3359: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);

3355: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
3356: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
3357: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
3358: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
3359: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
3360: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
3361: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);
3362: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);
3363:

Line 3360: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);

3356: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
3357: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
3358: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
3359: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
3360: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
3361: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);
3362: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);
3363:
3364: FOR i in 1 .. l_transTxtValuesCount

Line 3361: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);

3357: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
3358: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
3359: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
3360: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
3361: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);
3362: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);
3363:
3364: FOR i in 1 .. l_transTxtValuesCount
3365: LOOP

Line 3362: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);

3358: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
3359: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
3360: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
3361: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);
3362: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);
3363:
3364: FOR i in 1 .. l_transTxtValuesCount
3365: LOOP
3366: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_trans_txt_offset), l_transTxtValues(i));

Line 3366: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_trans_txt_offset), l_transTxtValues(i));

3362: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);
3363:
3364: FOR i in 1 .. l_transTxtValuesCount
3365: LOOP
3366: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_trans_txt_offset), l_transTxtValues(i));
3367: END LOOP;
3368:
3369: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
3370:

Line 3369: l_cursorResult := DBMS_SQL.Execute(l_cursorName);

3365: LOOP
3366: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_trans_txt_offset), l_transTxtValues(i));
3367: END LOOP;
3368:
3369: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
3370:
3371: END IF;
3372:
3373: EXIT WHEN descriptors%NOTFOUND;

Line 3436: IF DBMS_SQL.IS_OPEN(l_cursorName) THEN

3432:
3433: END LOOP;
3434: CLOSE descriptors;
3435:
3436: IF DBMS_SQL.IS_OPEN(l_cursorName) THEN
3437: DBMS_SQL.CLOSE_CURSOR(l_cursorName);
3438: END IF;
3439:
3440:

Line 3437: DBMS_SQL.CLOSE_CURSOR(l_cursorName);

3433: END LOOP;
3434: CLOSE descriptors;
3435:
3436: IF DBMS_SQL.IS_OPEN(l_cursorName) THEN
3437: DBMS_SQL.CLOSE_CURSOR(l_cursorName);
3438: END IF;
3439:
3440:
3441: END INSERT_IP_DESCRIPTORS;