[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select rowidtochar(ROWID)
into p_rowid
from AK_FLOW_REGION_RELATIONS
where FROM_REGION_CODE = 'ICX_PO_HEADERS_D'
and FROM_REGION_APPL_ID = 178
and FROM_PAGE_CODE = 'ICX_PO_HEADERS_D'
and FROM_PAGE_APPL_ID = 178
and TO_PAGE_CODE = 'ICX_PO_HEADERS_DTL_D'
and TO_PAGE_APPL_ID = 178
and FLOW_CODE = 'ICX_INQUIRIES'
and FLOW_APPLICATION_ID = 178;
select po_header_id
into header_id
from po_headers
where TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT') and
segment1 = decode(instrb(seg1,'-'), 0, seg1, substr(seg1, 1, (instrb(seg1,'-')-1)));
FUNCTION item_updateable(l_index in number) RETURN BOOLEAN IS
BEGIN
RETURN (ak_query_pkg.g_items_table(l_index).update_flag = 'Y');
END item_updateable;
IF item_code(l_index) = 'POS_SELECT' THEN
htp.p('');
IF item_code(l_index) = 'POS_SELECT' THEN
htp.p('');
PROCEDURE non_updateable(l_index in number,
l_res_index in number,
l_col in number) IS
BEGIN
htp.p('');
Line: 302
END non_updateable;
Line: 304
PROCEDURE updateable(l_index in number,
l_res_index in number,
l_col in number,
l_row in number default null,
l_wip_row in number default null) IS
x_value varchar2(2000);
Line: 343
END updateable;
Line: 476
'/pos_asn.show_delete_frame"' ||
' name=delete' ||
' marginwidth=5' ||
' marginheight=0' ||
' scrolling=no>');
Line: 509
'/pos_asn.update_header" target="header" method="GET">');
Line: 602
'/pos_asn.update_shipments" target="shipments" method="GET">');
Line: 612
PROCEDURE show_delete_frame IS
v_messageText1 VARCHAR2(2000);
Line: 618
v_messageText2 := fnd_message.get_string('ICX', 'ICX_POS_ASN_EDIT_DELETE_BUT');
Line: 628
END show_delete_frame;
Line: 741
IF item_updateable(l_attribute_index) THEN
single_row_label(l_attribute_index);
Line: 744
updateable(l_attribute_index, l_result_index, l_current_col);
Line: 749
non_updateable(l_attribute_index, l_result_index, l_current_col);
Line: 873
IF item_updateable(l_attribute_index) THEN
IF item_code(l_attribute_index) = 'POS_ASN_WIP_JOB' AND
substrb(get_result_value(l_result_index, l_current_col), 1, 1) <> ' ' THEN
non_updateable(l_attribute_index, l_result_index, l_current_col);
Line: 886
updateable(l_attribute_index,l_result_index,
l_current_col, l_current_row, l_wip_row);
Line: 892
non_updateable(l_attribute_index, l_result_index, l_current_col);
Line: 1016
SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_request_id from dual;
Line: 1018
SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_header_id from dual;
Line: 1020
insert into rcv_headers_interface
(HEADER_INTERFACE_ID ,
GROUP_ID ,
PROCESSING_STATUS_CODE ,
PROCESSING_REQUEST_ID ,
RECEIPT_SOURCE_CODE ,
TRANSACTION_TYPE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_LOGIN ,
CREATION_DATE ,
CREATED_BY ,
LOCATION_ID ,
SHIP_TO_ORGANIZATION_ID ,
VENDOR_ID ,
VENDOR_SITE_ID ,
SHIPPED_DATE ,
ASN_TYPE ,
SHIPMENT_NUM ,
EXPECTED_RECEIPT_DATE ,
PACKING_SLIP ,
WAYBILL_AIRBILL_NUM ,
BILL_OF_LADING ,
FREIGHT_CARRIER_CODE ,
FREIGHT_TERMS ,
NUM_OF_CONTAINERS ,
COMMENTS ,
CARRIER_METHOD ,
CARRIER_EQUIPMENT ,
FREIGHT_BILL_NUMBER ,
GROSS_WEIGHT ,
GROSS_WEIGHT_UOM_CODE ,
NET_WEIGHT ,
NET_WEIGHT_UOM_CODE ,
TAR_WEIGHT ,
TAR_WEIGHT_UOM_CODE ,
PACKAGING_CODE ,
SPECIAL_HANDLING_CODE ,
INVOICE_NUM ,
INVOICE_DATE ,
TOTAL_INVOICE_AMOUNT ,
FREIGHT_AMOUNT ,
TAX_NAME ,
TAX_AMOUNT ,
CURRENCY_CODE ,
CONVERSION_RATE_TYPE ,
CONVERSION_RATE ,
CONVERSION_RATE_DATE ,
VALIDATION_FLAG
)
select
l_header_id ,
l_request_id ,
'RUNNING' ,
l_request_id ,
'VENDOR' ,
'NEW' ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_LOGIN ,
CREATION_DATE ,
CREATED_BY ,
SHIP_TO_LOCATION_ID ,
SHIP_TO_ORGANIZATION_ID ,
VENDOR_ID ,
VENDOR_SITE_ID ,
SHIP_DATE ,
decode(INVOICE_NUM, null, 'ASN', 'ASBN'),
SHIPMENT_NUM ,
EXPECTED_RECEIPT_DATE ,
PACKING_SLIP ,
WAYBILL_AIRBILL_NUM ,
BILL_OF_LADING ,
FREIGHT_CARRIER_CODE ,
FREIGHT_TERMS ,
NUM_OF_CONTAINERS ,
COMMENTS ,
CARRIER_METHOD ,
CARRIER_EQUIPMENT ,
FREIGHT_BILL_NUMBER ,
GROSS_WEIGHT ,
GROSS_WEIGHT_UOM_CODE ,
NET_WEIGHT ,
NET_WEIGHT_UOM_CODE ,
TAR_WEIGHT ,
TAR_WEIGHT_UOM_CODE ,
PACKAGING_CODE ,
SPECIAL_HANDLING_CODE ,
INVOICE_NUM ,
INVOICE_DATE ,
TOTAL_INVOICE_AMOUNT ,
FREIGHT_AMOUNT ,
null , /* TAX_NAME */
null , /* TAX_AMOUNT */
CURRENCY_CODE ,
CURRENCY_CONVERSION_TYPE ,
CURRENCY_CONVERSION_RATE ,
CURRENCY_CONVERSION_DATE ,
'Y'
from pos_asn_shop_cart_headers
where session_id = l_session_id;
Line: 1130
select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_line_id from dual;
Line: 1132
insert into rcv_transactions_interface
( INTERFACE_TRANSACTION_ID ,
HEADER_INTERFACE_ID ,
GROUP_ID ,
TRANSACTION_TYPE ,
TRANSACTION_DATE ,
PROCESSING_STATUS_CODE ,
PROCESSING_MODE_CODE ,
TRANSACTION_STATUS_CODE ,
AUTO_TRANSACT_CODE ,
RECEIPT_SOURCE_CODE ,
SOURCE_DOCUMENT_CODE ,
PO_HEADER_ID ,
PO_LINE_ID ,
PO_LINE_LOCATION_ID ,
QUANTITY ,
UNIT_OF_MEASURE ,
UOM_CODE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_LOGIN ,
CREATION_DATE ,
CREATED_BY ,
ITEM_ID ,
EXPECTED_RECEIPT_DATE ,
COMMENTS ,
WAYBILL_AIRBILL_NUM ,
BARCODE_LABEL ,
BILL_OF_LADING ,
CONTAINER_NUM ,
COUNTRY_OF_ORIGIN_CODE ,
VENDOR_CUM_SHIPPED_QTY ,
FREIGHT_CARRIER_CODE ,
VENDOR_LOT_NUM ,
TRUCK_NUM ,
NUM_OF_CONTAINERS ,
PACKING_SLIP ,
REASON_ID ,
ACTUAL_COST ,
TRANSFER_COST ,
TRANSPORTATION_COST ,
RMA_REFERENCE ,
VALIDATION_FLAG ,
WIP_ENTITY_ID ,
WIP_LINE_ID ,
WIP_OPERATION_SEQ_NUM ,
PO_DISTRIBUTION_ID ,
QUANTITY_INVOICED
)
values
( l_line_id ,
c_rec.HEADER_ID ,
c_rec.GROUP_ID ,
c_rec.TRANSACTION_TYPE ,
c_rec.TRANSACTION_DATE ,
c_rec.PROCESSING_STATUS_CODE ,
c_rec.PROCESSING_MODE_CODE ,
c_rec.TRANSACTION_STATUS_CODE,
c_rec.AUTO_TRANSACT_CODE ,
c_rec.RECEIPT_SOURCE_CODE ,
c_rec.SOURCE_DOCUMENT_CODE ,
c_rec.PO_HEADER_ID ,
c_rec.PO_LINE_ID ,
c_rec.PO_LINE_LOCATION_ID ,
c_rec.QUANTITY ,
c_rec.UNIT_OF_MEASURE ,
c_rec.UOM_CODE ,
c_rec.LAST_UPDATE_DATE ,
c_rec.LAST_UPDATED_BY ,
c_rec.LAST_UPDATE_LOGIN ,
c_rec.CREATION_DATE ,
c_rec.CREATED_BY ,
c_rec.ITEM_ID ,
c_rec.EXPECTED_RECEIPT_DATE ,
c_rec.COMMENTS ,
c_rec.WAYBILL_AIRBILL_NUM ,
c_rec.BARCODE_LABEL ,
c_rec.BILL_OF_LADING ,
c_rec.CONTAINER_NUM ,
c_rec.COUNTRY_OF_ORIGIN_CODE ,
c_rec.VENDOR_CUM_SHIPPED_QTY ,
c_rec.FREIGHT_CARRIER_CODE ,
c_rec.VENDOR_LOT_NUM ,
c_rec.TRUCK_NUM ,
c_rec.NUM_OF_CONTAINERS ,
c_rec.PACKING_SLIP ,
c_rec.REASON_ID ,
c_rec.ACTUAL_COST ,
c_rec.TRANSFER_COST ,
c_rec.TRANSPORTATION_COST ,
c_rec.RMA_REFERENCE ,
c_rec.VALIDATION_FLAG ,
c_rec.WIP_ENTITY_ID ,
c_rec.WIP_LINE_ID ,
c_rec.WIP_OPERATION_SEQ_NUM ,
c_rec.PO_DISTRIBUTION_ID ,
c_rec.QUANTITY_INVOICED
);
Line: 1233
select deliver_to_location_id
into x_deliver_to_location_id
from po_distributions_all
where po_distribution_id = c_rec.PO_DISTRIBUTION_ID;
Line: 1238
update rcv_transactions_interface
set deliver_to_location_id = x_deliver_to_location_id
where INTERFACE_TRANSACTION_ID = l_line_id;
Line: 1244
update rcv_transactions_interface
set deliver_to_location_id =
(select ship_to_location_id
from po_line_locations_all
where line_location_id = c_rec.PO_LINE_LOCATION_ID)
where INTERFACE_TRANSACTION_ID = l_line_id;
Line: 1255
update pos_asn_shop_cart_details asnd
set asnd.INTERFACE_TRANSACTION_ID = l_line_id,
asnd.HEADER_INTERFACE_ID = c_rec.HEADER_ID
where asnd.session_id = l_session_id and
asnd.asn_line_id = c_rec.asn_line_id and
asnd.asn_line_split_id = c_rec.asn_line_split_id;
Line: 1264
update rcv_transactions_interface
set DOCUMENT_LINE_NUM =
(select LINE_NUM
from po_lines_all
where po_line_id = c_rec.PO_LINE_ID)
where INTERFACE_TRANSACTION_ID = l_line_id;
Line: 1272
update rcv_transactions_interface
set DOCUMENT_SHIPMENT_LINE_NUM =
(select SHIPMENT_NUM
from po_line_locations_all
where line_location_id = c_rec.PO_LINE_LOCATION_ID)
where INTERFACE_TRANSACTION_ID = l_line_id;
Line: 1279
update rcv_transactions_interface
set po_release_id =
(select po_release_id
from po_line_locations_all
where line_location_id = c_rec.PO_LINE_LOCATION_ID)
where INTERFACE_TRANSACTION_ID = l_line_id;
Line: 1288
update rcv_transactions_interface
set SUBINVENTORY =
(select destination_subinventory
from po_distributions_all
where po_distribution_id = c_rec.PO_DISTRIBUTION_ID)
where INTERFACE_TRANSACTION_ID = l_line_id;
Line: 1348
select count(*) into error_count from
po_interface_errors where Interface_Header_ID = l_header_id;
Line: 1375
delete from pos_asn_shop_cart_headers where session_id = l_session_id;
Line: 1376
delete from pos_asn_shop_cart_details where session_id = l_session_id;
Line: 1388
update rcv_headers_interface set
validation_flag = 'N',
processing_status_code = 'SUCCESS'
where header_interface_id = l_header_id;
Line: 1393
update rcv_transactions_interface set
PROCESSING_STATUS_CODE = 'PENDING',
TRANSACTION_STATUS_CODE = 'PENDING'
where header_interface_id = l_header_id;
Line: 1414
PROCEDURE update_shipments(pos_quantity_shipped IN t_text_table DEFAULT g_dummy,
pos_select IN t_text_table DEFAULT g_dummy,
pos_unit_of_measure IN t_text_table DEFAULT g_dummy,
pos_comments IN t_text_table DEFAULT g_dummy,
pos_asn_line_id IN t_text_table DEFAULT g_dummy,
pos_asn_line_split_id IN t_text_table DEFAULT g_dummy,
pos_po_line_location_id IN t_text_table DEFAULT g_dummy,
pos_po_distribution_id IN t_text_table DEFAULT g_dummy,
pos_asn_wip_job IN t_text_table DEFAULT g_dummy,
pos_wip_entity_id IN t_text_table DEFAULT g_dummy,
pos_wip_line_id IN t_text_table DEFAULT g_dummy,
pos_wip_operation_seq_num IN t_text_table DEFAULT g_dummy,
pos_item_id IN t_text_table DEFAULT g_dummy,
pos_uom_class IN t_text_table DEFAULT g_dummy,
pos_po_header_id IN t_text_table DEFAULT g_dummy,
pos_submit IN VARCHAR2 DEFAULT NULL) IS
d_count number;
Line: 1437
update pos_asn_shop_cart_details set
quantity_shipped = fnd_number.canonical_to_number(nvl(rtrim(ltrim(pos_quantity_shipped(l_counter))), 0)),
unit_of_measure = pos_unit_of_measure(l_counter),
comments = pos_comments(l_counter),
wip_job_info = pos_osp_job.get_wip_info(pos_po_distribution_id(l_counter)),
po_distribution_id = pos_po_distribution_id(l_counter),
wip_entity_id = pos_wip_entity_id(l_counter),
wip_operation_seq_num = pos_wip_operation_seq_num(l_counter),
wip_line_id = pos_wip_line_id(l_counter),
item_id = nvl(pos_item_id(l_counter), item_id)
where session_id = l_session_id and
asn_line_id = pos_asn_line_id(l_counter) and
asn_line_split_id = pos_asn_line_split_id(l_counter);
Line: 1455
IF pos_submit = 'DELETE' AND pos_select.count > 0 THEN
FOR l_counter IN 1..pos_select.count LOOP
delete from pos_asn_shop_cart_details
where session_id = l_session_id and
asn_line_id = pos_asn_line_id(to_number(pos_select(l_counter))) and
asn_line_split_id = pos_asn_line_split_id(to_number(pos_select(l_counter)));
Line: 1466
select count(*)
into d_count
from pos_asn_shop_cart_details
where session_id = l_session_id;
Line: 1472
delete from pos_asn_shop_cart_headers where session_id = l_session_id;
Line: 1479
IF pos_submit = 'EXPLODE' AND pos_select.count > 0 THEN
FOR l_counter IN 1..pos_select.count LOOP
update pos_asn_shop_cart_details set
asn_line_split_id = asn_line_split_id + 1
where session_id = l_session_id and
asn_line_id = pos_asn_line_id(to_number(pos_select(l_counter))) and
asn_line_split_id > pos_asn_line_split_id(to_number(pos_select(l_counter)));
Line: 1490
insert into pos_asn_shop_cart_details
(session_id,
asn_line_id,
asn_line_split_id,
po_header_id,
po_line_id,
po_line_location_id,
ship_to_organization_id,
last_update_date,
last_updated_by,
unit_of_measure,
item_id )
select
session_id,
asn_line_id,
asn_line_split_id + 1,
po_header_id,
po_line_id,
po_line_location_id,
ship_to_organization_id,
last_update_date,
last_updated_by,
unit_of_measure,
item_id
from pos_asn_shop_cart_details
where session_id = l_session_id and
asn_line_id = pos_asn_line_id(to_number(pos_select(l_counter))) and
asn_line_split_id = pos_asn_line_split_id(to_number(pos_select(l_counter)));
Line: 1550
END update_shipments;
Line: 1552
PROCEDURE update_header ( pos_asn_shipment_num IN VARCHAR2 DEFAULT null,
pos_bill_of_lading IN VARCHAR2 DEFAULT null,
pos_waybill_airbill_num IN VARCHAR2 DEFAULT null,
pos_ship_date IN VARCHAR2 DEFAULT null,
pos_expected_receipt_date IN VARCHAR2 DEFAULT null,
pos_num_of_containers IN VARCHAR2 DEFAULT null,
pos_comments IN VARCHAR2 DEFAULT null,
pos_packing_slip IN VARCHAR2 DEFAULT null,
pos_freight_carrier IN VARCHAR2 DEFAULT null,
pos_freight_carrier_code IN VARCHAR2 DEFAULT null,
pos_freight_term IN VARCHAR2 DEFAULT null,
pos_freight_term_code IN VARCHAR2 DEFAULT null,
pos_freight_bill_num IN VARCHAR2 DEFAULT null,
pos_carrier_method IN VARCHAR2 DEFAULT null,
pos_carrier_equipment IN VARCHAR2 DEFAULT null,
pos_gross_weight IN VARCHAR2 DEFAULT null,
pos_gross_weight_uom IN VARCHAR2 DEFAULT null,
pos_gross_weight_uom_code IN VARCHAR2 DEFAULT null,
pos_net_weight IN VARCHAR2 DEFAULT null,
pos_net_weight_uom IN VARCHAR2 DEFAULT null,
pos_net_weight_uom_code IN VARCHAR2 DEFAULT null,
pos_tar_weight IN VARCHAR2 DEFAULT null,
pos_tar_weight_uom IN VARCHAR2 DEFAULT null,
pos_tar_weight_uom_code IN VARCHAR2 DEFAULT null,
pos_packaging_code IN VARCHAR2 DEFAULT null,
pos_special_handling_code IN VARCHAR2 DEFAULT null,
pos_ship_to_organization_id IN VARCHAR2 DEFAULT null ) IS
l_ship_date varchar2(200);
Line: 1609
update pos_asn_shop_cart_headers set
asn_type = 'NEW',
shipment_num = pos_asn_shipment_num,
bill_of_lading = pos_bill_of_lading,
waybill_airbill_num = pos_waybill_airbill_num,
ship_date = l_ship_date,
expected_receipt_date = l_receipt_date,
num_of_containers = fnd_number.canonical_to_number(rtrim(ltrim(pos_num_of_containers))),
comments = pos_comments,
packing_slip = pos_packing_slip,
freight_carrier_code = pos_freight_carrier_code,
freight_terms = pos_freight_term_code,
freight_bill_number = pos_freight_bill_num,
carrier_method = pos_carrier_method,
carrier_equipment = pos_carrier_equipment,
gross_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_gross_weight))),
gross_weight_uom_code = pos_gross_weight_uom_code,
net_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_net_weight))),
net_weight_uom_code = pos_net_weight_uom_code,
tar_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_tar_weight))),
tar_weight_uom_code = pos_tar_weight_uom_code,
packaging_code = pos_packaging_code,
special_handling_code = pos_special_handling_code
where session_id = l_session_id;
Line: 1641
END update_header;