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 559: l_req_line_id_col dbms_sql.number_table;

555: l_orig_req_line NUMBER;
556: l_req_qty NUMBER;
557: l_num_messages NUMBER;
558: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
559: l_req_line_id_col dbms_sql.number_table;
560: lock_not_acquired EXCEPTION;
561: l_user_id NUMBER;
562:
563: PRAGMA EXCEPTION_INIT(lock_not_acquired, -54);

Line 945: l_bid_number_col dbms_sql.number_table;

941: l_reqIdx NUMBER;
942: l_currentReqIdx NUMBER;
943: l_insert_index NUMBER;
944: l_count NUMBER;
945: l_bid_number_col dbms_sql.number_table;
946: l_award_col dbms_sql.number_table;
947: l_req_line_id_col dbms_sql.number_table;
948: l_req_header_id_col dbms_sql.number_table;
949: l_req_quantity_col dbms_sql.number_table;

Line 946: l_award_col dbms_sql.number_table;

942: l_currentReqIdx NUMBER;
943: l_insert_index NUMBER;
944: l_count NUMBER;
945: l_bid_number_col dbms_sql.number_table;
946: l_award_col dbms_sql.number_table;
947: l_req_line_id_col dbms_sql.number_table;
948: l_req_header_id_col dbms_sql.number_table;
949: l_req_quantity_col dbms_sql.number_table;
950: l_req_new_quantity_col dbms_sql.number_table;

Line 947: l_req_line_id_col dbms_sql.number_table;

943: l_insert_index NUMBER;
944: l_count NUMBER;
945: l_bid_number_col dbms_sql.number_table;
946: l_award_col dbms_sql.number_table;
947: l_req_line_id_col dbms_sql.number_table;
948: l_req_header_id_col dbms_sql.number_table;
949: l_req_quantity_col dbms_sql.number_table;
950: l_req_new_quantity_col dbms_sql.number_table;
951: l_bid_number_insertcol dbms_sql.number_table;

Line 948: l_req_header_id_col dbms_sql.number_table;

944: l_count NUMBER;
945: l_bid_number_col dbms_sql.number_table;
946: l_award_col dbms_sql.number_table;
947: l_req_line_id_col dbms_sql.number_table;
948: l_req_header_id_col dbms_sql.number_table;
949: l_req_quantity_col dbms_sql.number_table;
950: l_req_new_quantity_col dbms_sql.number_table;
951: l_bid_number_insertcol dbms_sql.number_table;
952: l_bid_line_number_insertcol dbms_sql.number_table;

Line 949: l_req_quantity_col dbms_sql.number_table;

945: l_bid_number_col dbms_sql.number_table;
946: l_award_col dbms_sql.number_table;
947: l_req_line_id_col dbms_sql.number_table;
948: l_req_header_id_col dbms_sql.number_table;
949: l_req_quantity_col dbms_sql.number_table;
950: l_req_new_quantity_col dbms_sql.number_table;
951: l_bid_number_insertcol dbms_sql.number_table;
952: l_bid_line_number_insertcol dbms_sql.number_table;
953: l_orig_req_line_insertcol dbms_sql.number_table;

Line 950: l_req_new_quantity_col dbms_sql.number_table;

946: l_award_col dbms_sql.number_table;
947: l_req_line_id_col dbms_sql.number_table;
948: l_req_header_id_col dbms_sql.number_table;
949: l_req_quantity_col dbms_sql.number_table;
950: l_req_new_quantity_col dbms_sql.number_table;
951: l_bid_number_insertcol dbms_sql.number_table;
952: l_bid_line_number_insertcol dbms_sql.number_table;
953: l_orig_req_line_insertcol dbms_sql.number_table;
954: l_orig_req_header_insertcol dbms_sql.number_table;

Line 951: l_bid_number_insertcol dbms_sql.number_table;

947: l_req_line_id_col dbms_sql.number_table;
948: l_req_header_id_col dbms_sql.number_table;
949: l_req_quantity_col dbms_sql.number_table;
950: l_req_new_quantity_col dbms_sql.number_table;
951: l_bid_number_insertcol dbms_sql.number_table;
952: l_bid_line_number_insertcol dbms_sql.number_table;
953: l_orig_req_line_insertcol dbms_sql.number_table;
954: l_orig_req_header_insertcol dbms_sql.number_table;
955: l_allocated_qty_insertcol dbms_sql.number_table;

Line 952: l_bid_line_number_insertcol dbms_sql.number_table;

948: l_req_header_id_col dbms_sql.number_table;
949: l_req_quantity_col dbms_sql.number_table;
950: l_req_new_quantity_col dbms_sql.number_table;
951: l_bid_number_insertcol dbms_sql.number_table;
952: l_bid_line_number_insertcol dbms_sql.number_table;
953: l_orig_req_line_insertcol dbms_sql.number_table;
954: l_orig_req_header_insertcol dbms_sql.number_table;
955: l_allocated_qty_insertcol dbms_sql.number_table;
956: l_auction_header_id_insertcol dbms_sql.number_table;

Line 953: l_orig_req_line_insertcol dbms_sql.number_table;

949: l_req_quantity_col dbms_sql.number_table;
950: l_req_new_quantity_col dbms_sql.number_table;
951: l_bid_number_insertcol dbms_sql.number_table;
952: l_bid_line_number_insertcol dbms_sql.number_table;
953: l_orig_req_line_insertcol dbms_sql.number_table;
954: l_orig_req_header_insertcol dbms_sql.number_table;
955: l_allocated_qty_insertcol dbms_sql.number_table;
956: l_auction_header_id_insertcol dbms_sql.number_table;
957: -- Clin Slin Changes

Line 954: l_orig_req_header_insertcol dbms_sql.number_table;

950: l_req_new_quantity_col dbms_sql.number_table;
951: l_bid_number_insertcol dbms_sql.number_table;
952: l_bid_line_number_insertcol dbms_sql.number_table;
953: l_orig_req_line_insertcol dbms_sql.number_table;
954: l_orig_req_header_insertcol dbms_sql.number_table;
955: l_allocated_qty_insertcol dbms_sql.number_table;
956: l_auction_header_id_insertcol dbms_sql.number_table;
957: -- Clin Slin Changes
958: --l_split_req_line_id_insertcol dbms_sql.number_table;

Line 955: l_allocated_qty_insertcol dbms_sql.number_table;

951: l_bid_number_insertcol dbms_sql.number_table;
952: l_bid_line_number_insertcol dbms_sql.number_table;
953: l_orig_req_line_insertcol dbms_sql.number_table;
954: l_orig_req_header_insertcol dbms_sql.number_table;
955: l_allocated_qty_insertcol dbms_sql.number_table;
956: l_auction_header_id_insertcol dbms_sql.number_table;
957: -- Clin Slin Changes
958: --l_split_req_line_id_insertcol dbms_sql.number_table;
959: l_clm_info_flag dbms_sql.number_table;

Line 956: l_auction_header_id_insertcol dbms_sql.number_table;

952: l_bid_line_number_insertcol dbms_sql.number_table;
953: l_orig_req_line_insertcol dbms_sql.number_table;
954: l_orig_req_header_insertcol dbms_sql.number_table;
955: l_allocated_qty_insertcol dbms_sql.number_table;
956: l_auction_header_id_insertcol dbms_sql.number_table;
957: -- Clin Slin Changes
958: --l_split_req_line_id_insertcol dbms_sql.number_table;
959: l_clm_info_flag dbms_sql.number_table;
960:

Line 958: --l_split_req_line_id_insertcol dbms_sql.number_table;

954: l_orig_req_header_insertcol dbms_sql.number_table;
955: l_allocated_qty_insertcol dbms_sql.number_table;
956: l_auction_header_id_insertcol dbms_sql.number_table;
957: -- Clin Slin Changes
958: --l_split_req_line_id_insertcol dbms_sql.number_table;
959: l_clm_info_flag dbms_sql.number_table;
960:
961: l_empty_table dbms_sql.number_table;
962: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 959: l_clm_info_flag dbms_sql.number_table;

955: l_allocated_qty_insertcol dbms_sql.number_table;
956: l_auction_header_id_insertcol dbms_sql.number_table;
957: -- Clin Slin Changes
958: --l_split_req_line_id_insertcol dbms_sql.number_table;
959: l_clm_info_flag dbms_sql.number_table;
960:
961: l_empty_table dbms_sql.number_table;
962: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
963: l_user_id NUMBER;

Line 961: l_empty_table dbms_sql.number_table;

957: -- Clin Slin Changes
958: --l_split_req_line_id_insertcol dbms_sql.number_table;
959: l_clm_info_flag dbms_sql.number_table;
960:
961: l_empty_table dbms_sql.number_table;
962: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
963: l_user_id NUMBER;
964: l_login_id NUMBER;
965: l_bid_price_col dbms_sql.number_table;

Line 965: l_bid_price_col dbms_sql.number_table;

961: l_empty_table dbms_sql.number_table;
962: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
963: l_user_id NUMBER;
964: l_login_id NUMBER;
965: l_bid_price_col dbms_sql.number_table;
966: l_order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE;
967: l_purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE;
968: l_contract_type pon_auction_headers_all.contract_type%TYPE;
969:

Line 4130: l_cursorName := DBMS_SQL.Open_Cursor;

4126: from pon_auction_headers_all
4127: where auction_header_id = p_auction_header_id;
4128:
4129:
4130: l_cursorName := DBMS_SQL.Open_Cursor;
4131: l_cur_interface_line_id := -9999;
4132:
4133: OPEN descriptors;
4134: LOOP

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

4170: ')';
4171:
4172: log_message(l_po_attr_values_stmt);
4173:
4174: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);
4175:
4176: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
4177: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4178: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);

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

4172: log_message(l_po_attr_values_stmt);
4173:
4174: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);
4175:
4176: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
4177: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4178: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
4179: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4180: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);

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

4173:
4174: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);
4175:
4176: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
4177: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4178: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
4179: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4180: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4181: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);

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

4174: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);
4175:
4176: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
4177: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4178: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
4179: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4180: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4181: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4182: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);

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

4175:
4176: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
4177: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4178: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
4179: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4180: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4181: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4182: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
4183: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);

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

4176: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
4177: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4178: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
4179: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4180: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4181: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4182: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
4183: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
4184: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);

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

4177: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4178: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
4179: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4180: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4181: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4182: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
4183: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
4184: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
4185: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);

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

4178: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
4179: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4180: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4181: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4182: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
4183: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
4184: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
4185: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
4186: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);

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

4179: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4180: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4181: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4182: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
4183: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
4184: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
4185: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
4186: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
4187:

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

4180: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4181: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4182: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
4183: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
4184: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
4185: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
4186: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
4187:
4188: FOR i in 1 .. l_numValuesCount

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

4181: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4182: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
4183: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
4184: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
4185: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
4186: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
4187:
4188: FOR i in 1 .. l_numValuesCount
4189: LOOP

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

4182: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
4183: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
4184: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
4185: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
4186: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
4187:
4188: FOR i in 1 .. l_numValuesCount
4189: LOOP
4190: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset), l_numValues(i));

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

4186: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
4187:
4188: FOR i in 1 .. l_numValuesCount
4189: LOOP
4190: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset), l_numValues(i));
4191: END LOOP;
4192:
4193: FOR i in 1 ..l_txtValuesCount
4194: LOOP

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

4191: END LOOP;
4192:
4193: FOR i in 1 ..l_txtValuesCount
4194: LOOP
4195: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset+l_numValuesCount), l_txtValues(i));
4196: END LOOP;
4197:
4198: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
4199:

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

4194: LOOP
4195: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset+l_numValuesCount), l_txtValues(i));
4196: END LOOP;
4197:
4198: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
4199:
4200: END IF;
4201:
4202: -- process translateable text descriptors

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

4238: ')';
4239:
4240: log_message(l_po_attr_values_tlp_stmt);
4241:
4242: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);
4243:
4244: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
4245: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4246: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);

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

4240: log_message(l_po_attr_values_tlp_stmt);
4241:
4242: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);
4243:
4244: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
4245: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4246: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
4247: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4248: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);

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

4241:
4242: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);
4243:
4244: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
4245: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4246: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
4247: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4248: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4249: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);

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

4242: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);
4243:
4244: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
4245: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4246: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
4247: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4248: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4249: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4250: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);

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

4243:
4244: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
4245: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4246: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
4247: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4248: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4249: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4250: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
4251: DBMS_SQL.Bind_Variable(l_cursorName, ':8', SubStrB(l_cur_item_description,1,240));

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

4244: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
4245: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4246: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
4247: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4248: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4249: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4250: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
4251: DBMS_SQL.Bind_Variable(l_cursorName, ':8', SubStrB(l_cur_item_description,1,240));
4252: DBMS_SQL.Bind_Variable(l_cursorName, ':9', SubStrB(l_cur_item_description,1,2000));

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

4245: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
4246: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
4247: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4248: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4249: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4250: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
4251: DBMS_SQL.Bind_Variable(l_cursorName, ':8', SubStrB(l_cur_item_description,1,240));
4252: DBMS_SQL.Bind_Variable(l_cursorName, ':9', SubStrB(l_cur_item_description,1,2000));
4253: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_login_id);

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

4246: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
4247: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4248: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4249: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4250: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
4251: DBMS_SQL.Bind_Variable(l_cursorName, ':8', SubStrB(l_cur_item_description,1,240));
4252: DBMS_SQL.Bind_Variable(l_cursorName, ':9', SubStrB(l_cur_item_description,1,2000));
4253: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_login_id);
4254: DBMS_SQL.Bind_Variable(l_cursorName, ':11', p_user_id);

Line 4251: DBMS_SQL.Bind_Variable(l_cursorName, ':8', SubStrB(l_cur_item_description,1,240));

4247: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
4248: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4249: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4250: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
4251: DBMS_SQL.Bind_Variable(l_cursorName, ':8', SubStrB(l_cur_item_description,1,240));
4252: DBMS_SQL.Bind_Variable(l_cursorName, ':9', SubStrB(l_cur_item_description,1,2000));
4253: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_login_id);
4254: DBMS_SQL.Bind_Variable(l_cursorName, ':11', p_user_id);
4255: DBMS_SQL.Bind_Variable(l_cursorName, ':12', sysdate);

Line 4252: DBMS_SQL.Bind_Variable(l_cursorName, ':9', SubStrB(l_cur_item_description,1,2000));

4248: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
4249: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4250: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
4251: DBMS_SQL.Bind_Variable(l_cursorName, ':8', SubStrB(l_cur_item_description,1,240));
4252: DBMS_SQL.Bind_Variable(l_cursorName, ':9', SubStrB(l_cur_item_description,1,2000));
4253: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_login_id);
4254: DBMS_SQL.Bind_Variable(l_cursorName, ':11', p_user_id);
4255: DBMS_SQL.Bind_Variable(l_cursorName, ':12', sysdate);
4256: DBMS_SQL.Bind_Variable(l_cursorName, ':13', p_user_id);

Line 4253: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_login_id);

4249: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
4250: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
4251: DBMS_SQL.Bind_Variable(l_cursorName, ':8', SubStrB(l_cur_item_description,1,240));
4252: DBMS_SQL.Bind_Variable(l_cursorName, ':9', SubStrB(l_cur_item_description,1,2000));
4253: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_login_id);
4254: DBMS_SQL.Bind_Variable(l_cursorName, ':11', p_user_id);
4255: DBMS_SQL.Bind_Variable(l_cursorName, ':12', sysdate);
4256: DBMS_SQL.Bind_Variable(l_cursorName, ':13', p_user_id);
4257: DBMS_SQL.Bind_Variable(l_cursorName, ':14', sysdate);

Line 4254: DBMS_SQL.Bind_Variable(l_cursorName, ':11', p_user_id);

4250: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
4251: DBMS_SQL.Bind_Variable(l_cursorName, ':8', SubStrB(l_cur_item_description,1,240));
4252: DBMS_SQL.Bind_Variable(l_cursorName, ':9', SubStrB(l_cur_item_description,1,2000));
4253: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_login_id);
4254: DBMS_SQL.Bind_Variable(l_cursorName, ':11', p_user_id);
4255: DBMS_SQL.Bind_Variable(l_cursorName, ':12', sysdate);
4256: DBMS_SQL.Bind_Variable(l_cursorName, ':13', p_user_id);
4257: DBMS_SQL.Bind_Variable(l_cursorName, ':14', sysdate);
4258:

Line 4255: DBMS_SQL.Bind_Variable(l_cursorName, ':12', sysdate);

4251: DBMS_SQL.Bind_Variable(l_cursorName, ':8', SubStrB(l_cur_item_description,1,240));
4252: DBMS_SQL.Bind_Variable(l_cursorName, ':9', SubStrB(l_cur_item_description,1,2000));
4253: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_login_id);
4254: DBMS_SQL.Bind_Variable(l_cursorName, ':11', p_user_id);
4255: DBMS_SQL.Bind_Variable(l_cursorName, ':12', sysdate);
4256: DBMS_SQL.Bind_Variable(l_cursorName, ':13', p_user_id);
4257: DBMS_SQL.Bind_Variable(l_cursorName, ':14', sysdate);
4258:
4259: FOR i in 1 .. l_transTxtValuesCount

Line 4256: DBMS_SQL.Bind_Variable(l_cursorName, ':13', p_user_id);

4252: DBMS_SQL.Bind_Variable(l_cursorName, ':9', SubStrB(l_cur_item_description,1,2000));
4253: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_login_id);
4254: DBMS_SQL.Bind_Variable(l_cursorName, ':11', p_user_id);
4255: DBMS_SQL.Bind_Variable(l_cursorName, ':12', sysdate);
4256: DBMS_SQL.Bind_Variable(l_cursorName, ':13', p_user_id);
4257: DBMS_SQL.Bind_Variable(l_cursorName, ':14', sysdate);
4258:
4259: FOR i in 1 .. l_transTxtValuesCount
4260: LOOP

Line 4257: DBMS_SQL.Bind_Variable(l_cursorName, ':14', sysdate);

4253: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_login_id);
4254: DBMS_SQL.Bind_Variable(l_cursorName, ':11', p_user_id);
4255: DBMS_SQL.Bind_Variable(l_cursorName, ':12', sysdate);
4256: DBMS_SQL.Bind_Variable(l_cursorName, ':13', p_user_id);
4257: DBMS_SQL.Bind_Variable(l_cursorName, ':14', sysdate);
4258:
4259: FOR i in 1 .. l_transTxtValuesCount
4260: LOOP
4261: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_trans_txt_offset), l_transTxtValues(i));

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

4257: DBMS_SQL.Bind_Variable(l_cursorName, ':14', sysdate);
4258:
4259: FOR i in 1 .. l_transTxtValuesCount
4260: LOOP
4261: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_trans_txt_offset), l_transTxtValues(i));
4262: END LOOP;
4263:
4264: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
4265:

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

4260: LOOP
4261: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_trans_txt_offset), l_transTxtValues(i));
4262: END LOOP;
4263:
4264: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
4265:
4266: END IF;
4267:
4268: EXIT WHEN descriptors%NOTFOUND;

Line 4331: IF DBMS_SQL.IS_OPEN(l_cursorName) THEN

4327:
4328: END LOOP;
4329: CLOSE descriptors;
4330:
4331: IF DBMS_SQL.IS_OPEN(l_cursorName) THEN
4332: DBMS_SQL.CLOSE_CURSOR(l_cursorName);
4333: END IF;
4334:
4335:

Line 4332: DBMS_SQL.CLOSE_CURSOR(l_cursorName);

4328: END LOOP;
4329: CLOSE descriptors;
4330:
4331: IF DBMS_SQL.IS_OPEN(l_cursorName) THEN
4332: DBMS_SQL.CLOSE_CURSOR(l_cursorName);
4333: END IF;
4334:
4335:
4336: END INSERT_IP_DESCRIPTORS;