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.

[Home] [Help]

APPS.CSD_BULK_RECEIVE_UTIL dependencies on CSD_BULK_RECEIVE_ITEMS_B

Line 943: Select * from csd_bulk_receive_items_b

939: IS
940:
941: -- Cursor to derive Bulk Receive record
942: Cursor c_create_blkrcv_ro(p_bulk_receive_id Number) IS
943: Select * from csd_bulk_receive_items_b
944: where bulk_receive_id = p_bulk_receive_id;
945:
946: -- Cursor to derive item attributes
947: Cursor c_get_item_attributes(p_inventory_item_id number) IS

Line 1033: l_blkrcv_rec csd_bulk_receive_items_b%ROWTYPE;

1029: l_instance_id Number;
1030: l_revision_qty_control_code Number;
1031: l_install_base_flag Varchar2(1);
1032: l_repln_rec csd_repairs_pub.repln_rec_type;
1033: l_blkrcv_rec csd_bulk_receive_items_b%ROWTYPE;
1034: c_non_serialized CONSTANT Number := 1;
1035: l_instance_rec csd_mass_rcv_pvt.instance_rec_type;
1036: l_revision Varchar2(30);
1037: l_party_site_use_id Number;

Line 1081: from csd_bulk_receive_items_b

1077: -- BR ER FP changes, subhat.
1078: begin
1079: select item_revision,lot_number
1080: into l_revision,l_lot_num
1081: from csd_bulk_receive_items_b
1082: where bulk_receive_id = p_bulk_receive_id;
1083:
1084: exception
1085: when no_data_found then

Line 1437: select * from csd_bulk_receive_items_b

1433: IS
1434:
1435: -- Cursor to derive Bulk Receive record
1436: Cursor c_create_blkrcv_prod_txn(p_bulk_receive_id Number) IS
1437: select * from csd_bulk_receive_items_b
1438: where bulk_receive_id = p_bulk_receive_id;
1439:
1440: -- Local variables
1441: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_BLKRCV_DEFAULT_PROD_TXN';

Line 1443: l_blkrcv_rec csd_bulk_receive_items_b%ROWTYPE;

1439:
1440: -- Local variables
1441: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_BLKRCV_DEFAULT_PROD_TXN';
1442: l_api_version CONSTANT NUMBER := 1.0;
1443: l_blkrcv_rec csd_bulk_receive_items_b%ROWTYPE;
1444:
1445: BEGIN
1446:
1447: savepoint create_blkrcv_default_prod_txn;

Line 1540: l_blkrcv_rec csd_bulk_receive_items_b%ROWTYPE;

1536: l_instance_party_id Number;
1537: l_object_version_number Number;
1538: l_api_name CONSTANT Varchar(30) := 'CHANGE_BLKRCV_IB_OWNER';
1539: l_api_version CONSTANT Number := 1.0;
1540: l_blkrcv_rec csd_bulk_receive_items_b%ROWTYPE;
1541: l_instance_account_id Number;
1542: l_inst_party_obj_ver_num Number;
1543: l_inst_acct_obj_ver_num Number;
1544: l_instance_id Number;

Line 1567: select * from csd_bulk_receive_items_b

1563: where instance_id = p_instance_id;
1564:
1565: -- Cursor to derive the Bulk Receive rec
1566: Cursor c_bulk_receive_items(p_bulk_receive_id Number) IS
1567: select * from csd_bulk_receive_items_b
1568: where bulk_receive_id = p_bulk_receive_id;
1569:
1570: -- Cursor to derive the Instance Account Id
1571: Cursor c_instance_account(p_instance_party_id number) is

Line 1999: Update csd_bulk_receive_items_b

1995: -- Update all the auto receive records to error
1996: For i in 1..p_bulk_autorcv_tbl.count
1997: Loop
1998:
1999: Update csd_bulk_receive_items_b
2000: set status = 'ERRORED'
2001: where bulk_receive_id = p_bulk_autorcv_tbl(i).bulk_receive_id;
2002:
2003: End loop;

Line 2059: Update csd_bulk_receive_items_b

2055: End Loop;
2056:
2057: If (l_errored) then
2058:
2059: Update csd_bulk_receive_items_b
2060: set status = 'ERRORED'
2061: where bulk_receive_id = p_bulk_autorcv_tbl(i).bulk_receive_id;
2062:
2063: Else

Line 2066: -- Update csd_bulk_receive_items_b

2062:
2063: Else
2064:
2065: -- fix for bug 5227347
2066: -- Update csd_bulk_receive_items_b
2067: -- set status = 'PROCESSED'
2068: -- where bulk_receive_id = p_bulk_autorcv_tbl(i).bulk_receive_id;
2069: -- 12.2 changes, subhat
2070: if nvl(p_bulk_autorcv_tbl(i).under_receipt_flag,'N') = 'Y' then

Line 2107: Update csd_bulk_receive_items_b

2103: Close c_get_prod_txn_status;
2104:
2105: If ( l_prod_txn_status = 'RECEIVED' ) then
2106:
2107: Update csd_bulk_receive_items_b
2108: set status = 'PROCESSED'
2109: where bulk_receive_id = p_bulk_autorcv_tbl(i).bulk_receive_id;
2110:
2111: End if;

Line 2125: Update csd_bulk_receive_items_b

2121: -- Unexpected/Internal Error
2122: For i in 1..p_bulk_autorcv_tbl.count
2123: Loop
2124:
2125: Update csd_bulk_receive_items_b
2126: set status = 'ERRORED'
2127: where bulk_receive_id = p_bulk_autorcv_tbl(i).bulk_receive_id;
2128:
2129: End loop;

Line 2140: -- Update csd_bulk_receive_items_b

2136: For i in 1..p_bulk_autorcv_tbl.count
2137: Loop
2138:
2139: -- fix for bug 5227347
2140: -- Update csd_bulk_receive_items_b
2141: -- set status = 'PROCESSED'
2142: -- where bulk_receive_id = p_bulk_autorcv_tbl(i).bulk_receive_id;
2143:
2144: -- 12.2 changes,subhat.

Line 2184: Update csd_bulk_receive_items_b

2180: Close c_get_prod_txn_status;
2181:
2182: If ( l_prod_txn_status = 'RECEIVED' ) then
2183:
2184: Update csd_bulk_receive_items_b
2185: set status = 'PROCESSED'
2186: where bulk_receive_id = p_bulk_autorcv_tbl(i).bulk_receive_id;
2187:
2188: End if;

Line 2316: from csd_bulk_receive_items_b

2312:
2313: -- Cursor to get the Bulk Receive record
2314: Cursor c_get_bulk_receive(p_transaction_number in number) is
2315: Select *
2316: from csd_bulk_receive_items_b
2317: where transaction_number = p_transaction_number;
2318:
2319: -- Cursor to get Incident number
2320: Cursor c_get_sr_details(p_incident_id in number) is

Line 2675: from csd_bulk_receive_items_b

2671: -- and concurrent manager is processing them.
2672: begin
2673: select repair_line_id
2674: bulk collect into l_in_progress_ro
2675: from csd_bulk_receive_items_b
2676: where transaction_number in
2677: (
2678: select argument1
2679: from fnd_concurrent_requests fcr,

Line 3415: from csd_bulk_receive_items_b where bulk_receive_id in

3411: -- matching for them
3412: if p_mode = 'UPDATE' then
3413: l_count := 1;
3414: for k in (select bulk_receive_id,serial_number,inventory_item_id,quantity
3415: from csd_bulk_receive_items_b where bulk_receive_id in
3416: (select * from table(cast(get_num_in_list(l_bulk_receive_ids)as JTF_NUMBER_TABLE)) ) )
3417: LOOP
3418: if (k.bulk_receive_id = x_sr_ro_rma_tbl(l_count).bulk_receive_id and
3419: nvl(k.serial_number,1) = nvl(x_sr_ro_rma_tbl(l_count).serial_number,1) and

Line 3600: from csd_bulk_receive_items_b cbr,

3596: cbr.rcv_attribute14,
3597: cbr.rcv_attribute15
3598: bulk collect into
3599: l_bulk_autorcv_tbl
3600: from csd_bulk_receive_items_b cbr,
3601: csd_product_transactions cpt,
3602: cs_estimate_details ced
3603: where cbr.transaction_number = p_transaction_number
3604: and cbr.repair_line_id = cpt.repair_line_id

Line 3650: Update csd_bulk_receive_items_b

3646: lc_api_name,
3647: 'Header error, updating all the records to errored ');
3648: End if;
3649: -- Update all the auto receive records to error
3650: Update csd_bulk_receive_items_b
3651: set status = 'ERRORED'
3652: where transaction_number = p_transaction_number;
3653:
3654:

Line 3714: Update csd_bulk_receive_items_b

3710: fnd_log.STRING (fnd_log.level_procedure,
3711: lc_api_name,
3712: 'Bulk receive line ['||l_bulk_autorcv_tbl(i).bulk_receive_id||' ] is errored');
3713: End if;
3714: Update csd_bulk_receive_items_b
3715: set status = 'ERRORED'
3716: where bulk_receive_id = l_bulk_autorcv_tbl(i).bulk_receive_id;
3717:
3718: Else

Line 3773: Update csd_bulk_receive_items_b

3769: Close c_get_prod_txn_status;
3770:
3771: If ( l_prod_txn_status = 'RECEIVED' ) then
3772:
3773: Update csd_bulk_receive_items_b
3774: set status = 'PROCESSED'
3775: where bulk_receive_id = l_bulk_autorcv_tbl(i).bulk_receive_id;
3776:
3777: End if;

Line 3840: Update csd_bulk_receive_items_b

3836: lc_api_name,
3837: 'No errors during receiving,update the line as processed: id = '||l_bulk_autorcv_tbl(i).bulk_receive_id);
3838: End if;
3839:
3840: Update csd_bulk_receive_items_b
3841: set status = 'PROCESSED'
3842: where bulk_receive_id = l_bulk_autorcv_tbl(i).bulk_receive_id;
3843:
3844: End if;

Line 3855: update csd_bulk_receive_items_b

3851: -- those records would be stuck in NEW status.
3852: -- We need to make sure that the records, which were never passed to receiving
3853: -- interface are marked as error too (since they failed validation).
3854:
3855: update csd_bulk_receive_items_b
3856: set status = 'ERRORED'
3857: where transaction_number = p_transaction_number
3858: and status = 'NEW';
3859: