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.CSE_PO_RECEIPT_INTO_PROJECT dependencies on CSE_DATASTRUCTURES_PUB

Line 26: x_rcv_attributes_rec OUT NOCOPY cse_datastructures_pub.rcv_attributes_rec_type)

22: p_msg_header IN xnp_message.msg_header_rec_type,
23: p_msg_text IN varchar2,
24: x_return_status OUT NOCOPY varchar2,
25: x_error_message OUT NOCOPY varchar2,
26: x_rcv_attributes_rec OUT NOCOPY cse_datastructures_pub.rcv_attributes_rec_type)
27: IS
28: l_rcv_transaction_id number;
29: l_file varchar2(500);
30: BEGIN

Line 84: p_rcv_attributes_rec IN cse_datastructures_pub.rcv_attributes_rec_type,

80:
81: END cleanup_transaction_temps;
82:
83: PROCEDURE update_csi_data(
84: p_rcv_attributes_rec IN cse_datastructures_pub.rcv_attributes_rec_type,
85: x_rcv_txn_tbl OUT NOCOPY cse_datastructures_pub.rcv_txn_tbl_type,
86: x_return_status OUT NOCOPY varchar2,
87: x_error_message OUT NOCOPY varchar2)
88: IS

Line 85: x_rcv_txn_tbl OUT NOCOPY cse_datastructures_pub.rcv_txn_tbl_type,

81: END cleanup_transaction_temps;
82:
83: PROCEDURE update_csi_data(
84: p_rcv_attributes_rec IN cse_datastructures_pub.rcv_attributes_rec_type,
85: x_rcv_txn_tbl OUT NOCOPY cse_datastructures_pub.rcv_txn_tbl_type,
86: x_return_status OUT NOCOPY varchar2,
87: x_error_message OUT NOCOPY varchar2)
88: IS
89: l_rcv_transaction_id NUMBER;

Line 192: l_transaction_status_code := cse_datastructures_pub.G_PENDING;

188: p_inventory_item_id => x_rcv_txn_tbl(1).Inventory_Item_Id,
189: p_depreciable => l_Depreciable);
190:
191: IF l_depreciable = 'Y' THEN
192: l_transaction_status_code := cse_datastructures_pub.G_PENDING;
193: debug(' depreciable item');
194: ELSIF l_depreciable = 'N' THEN
195: l_transaction_status_code := cse_datastructures_pub.G_COMPLETE;
196: debug(' normal item');

Line 195: l_transaction_status_code := cse_datastructures_pub.G_COMPLETE;

191: IF l_depreciable = 'Y' THEN
192: l_transaction_status_code := cse_datastructures_pub.G_PENDING;
193: debug(' depreciable item');
194: ELSIF l_depreciable = 'N' THEN
195: l_transaction_status_code := cse_datastructures_pub.G_COMPLETE;
196: debug(' normal item');
197: END IF;
198:
199: l_location_id := cse_util_pkg.get_dflt_project_location_id;

Line 244: l_instance_query_rec.instance_usage_code := cse_datastructures_pub.g_in_process;

240: l_instance_query_rec.serial_number := NVL(x_rcv_txn_tbl(i).serial_number,g_miss_char);
241: l_instance_query_rec.lot_number := NVL(x_rcv_txn_tbl(i).lot_number,g_miss_char);
242: l_instance_query_rec.pa_project_id := x_rcv_txn_tbl(i).project_id;
243: l_instance_query_rec.pa_project_task_id := x_rcv_txn_tbl(i).task_id;
244: l_instance_query_rec.instance_usage_code := cse_datastructures_pub.g_in_process;
245: ELSE
246: l_instance_query_rec.inventory_item_id := x_rcv_txn_tbl(i).inventory_item_id;
247: l_instance_query_rec.serial_number := NVL(x_rcv_txn_tbl(i).serial_number,g_miss_char);
248: END IF;

Line 293: l_instance_rec.instance_usage_code := cse_datastructures_pub.g_in_process;

289: l_instance_rec.mfg_serial_number_flag := 'N';
290: l_instance_rec.location_id := l_Location_Id;
291: l_instance_rec.location_type_code := l_Location_Type;
292: l_instance_rec.last_po_po_line_id := x_Rcv_txn_Tbl(i).PO_Line_Id; --5184815
293: l_instance_rec.instance_usage_code := cse_datastructures_pub.g_in_process;
294: l_instance_rec.version_label := 'AS-CREATED';
295: l_instance_rec.active_start_date := l_sysdate;
296: l_instance_rec.creation_complete_flag := 'Y';
297: l_instance_rec.customer_view_flag := 'N';

Line 406: l_instance_rec.instance_usage_code := cse_datastructures_pub.g_in_process;

402: l_instance_rec.Quantity := 1;
403: l_instance_rec.last_po_po_line_id := x_Rcv_txn_Tbl(i).PO_Line_Id; --5184815
404: l_instance_rec.Object_version_Number := l_instance_header_tbl_out(1).Object_Version_Number;
405: l_instance_rec.active_end_date := null;
406: l_instance_rec.instance_usage_code := cse_datastructures_pub.g_in_process;
407:
408: IF is_expired(l_instance_rec.instance_status_id) THEN
409: l_instance_rec.instance_status_id := l_dflt_inst_status_id;
410: END IF;

Line 460: l_instance_rec.instance_usage_code := cse_datastructures_pub.g_in_process;

456: l_instance_rec.last_po_po_line_id := x_Rcv_txn_Tbl(i).PO_Line_Id; --5184815
457: l_instance_rec.quantity := 1;
458: l_instance_rec.unit_of_measure := x_rcv_txn_tbl(i).uom;
459: l_instance_rec.mfg_serial_number_flag := 'Y';
460: l_instance_rec.instance_usage_code := cse_datastructures_pub.g_in_process;
461: l_instance_rec.version_label := 'AS-CREATED';
462: l_instance_rec.active_start_date := l_sysdate;
463: l_instance_rec.active_end_date := NULL;
464: l_instance_rec.creation_complete_flag := 'Y';

Line 540: x_rcv_txn_tbl OUT NOCOPY cse_datastructures_pub.rcv_txn_tbl_type,

536: END update_csi_data;
537:
538: PROCEDURE get_rcv_transaction_details(
539: p_rcv_transaction_id IN NUMBER,
540: x_rcv_txn_tbl OUT NOCOPY cse_datastructures_pub.rcv_txn_tbl_type,
541: x_return_status OUT NOCOPY varchar2,
542: x_error_message OUT NOCOPY varchar2)
543: IS
544:

Line 548: l_rcv_txn_rec cse_datastructures_pub.rcv_txn_rec_type;

544:
545: l_lot_code number;
546: l_serial_code number;
547:
548: l_rcv_txn_rec cse_datastructures_pub.rcv_txn_rec_type;
549: l_rcv_txn_tbl cse_datastructures_pub.rcv_txn_tbl_type;
550: ind binary_integer := 0;
551:
552: CURSOR rcvtxn_cur(p_rcv_txn_id IN NUMBER) IS

Line 549: l_rcv_txn_tbl cse_datastructures_pub.rcv_txn_tbl_type;

545: l_lot_code number;
546: l_serial_code number;
547:
548: l_rcv_txn_rec cse_datastructures_pub.rcv_txn_rec_type;
549: l_rcv_txn_tbl cse_datastructures_pub.rcv_txn_tbl_type;
550: ind binary_integer := 0;
551:
552: CURSOR rcvtxn_cur(p_rcv_txn_id IN NUMBER) IS
553: SELECT rt.transaction_id transaction_id,

Line 742: p_rcv_txn_tbl IN cse_datastructures_pub.Rcv_Txn_Tbl_Type,

738: x_return_status := fnd_api.g_ret_sts_success;
739: END knock_the_commitment;
740:
741: PROCEDURE interface_nl_to_pa(
742: p_rcv_txn_tbl IN cse_datastructures_pub.Rcv_Txn_Tbl_Type,
743: x_return_status OUT NOCOPY varchar2,
744: x_error_message OUT NOCOPY varchar2)
745: IS
746: l_Item_Name varchar2(40);