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.CSI_MASS_EDIT_PUB dependencies on CSI_WEBADI_STAGING

Line 336: from csi_mass_edit_entries_vl cmeev, CSI_WEBADI_STAGING cws

332: IF(p_entry_id IS NOT NULL) THEN
333: BEGIN
334: Select 'Y' INTO l_dummy from dual where
335: EXISTS( select 'Y'
336: from csi_mass_edit_entries_vl cmeev, CSI_WEBADI_STAGING cws
337: WHERE cmeev.ENTRY_ID = cws.BATCH_ID
338: AND cmeev.STATUS_CODE IN ('SUCCESSFUL', 'FAILED')
339: AND cmeev.BATCH_TYPE = 'WBADI'
340: AND nvl(cws.PROCESSING_STATUS, 'N') <> 'P'

Line 3032: UPDATE CSI_WEBADI_STAGING

3028: debug('Start procedure: Process_webadi_batch');
3029: -- Setting the Batch Status to 'Processing'
3030:
3031: BEGIN
3032: UPDATE CSI_WEBADI_STAGING
3033: SET PROCESSING_STATUS = 'P'
3034: WHERE BATCH_ID = p_entry_id;
3035:
3036: UPDATE csi_mass_edit_entries_b

Line 3055: FROM CSI_WEBADI_STAGING

3051: p_Entry_id => p_Entry_id
3052: );
3053:
3054: SELECT Count(*) INTO l_crt_count
3055: FROM CSI_WEBADI_STAGING
3056: where BATCH_ID = p_entry_id
3057: and INSTANCE_ID is null;
3058:
3059: SELECT Count(*) INTO l_updt_count

Line 3060: FROM CSI_WEBADI_STAGING

3056: where BATCH_ID = p_entry_id
3057: and INSTANCE_ID is null;
3058:
3059: SELECT Count(*) INTO l_updt_count
3060: FROM CSI_WEBADI_STAGING
3061: where BATCH_ID = p_entry_id
3062: and INSTANCE_ID is NOT null;
3063:
3064: l_inst_count := l_crt_count + l_updt_count;

Line 3350: FROM CSI_WEBADI_STAGING

3346: ATTRIBUTE27,
3347: ATTRIBUTE28,
3348: ATTRIBUTE29,
3349: ATTRIBUTE30
3350: FROM CSI_WEBADI_STAGING
3351: where BATCH_ID = p_entry_id
3352: and INSTANCE_ID is null;
3353:
3354: c_instance_tbl csi_datastructures_pub.instance_tbl;

Line 4159: FROM CSI_WEBADI_STAGING

4155: END IF;
4156: END IF;
4157:
4158: SELECT Count(*) INTO l_crt_count
4159: FROM CSI_WEBADI_STAGING
4160: where BATCH_ID = p_entry_id
4161: and INSTANCE_ID is null;
4162:
4163: debug_out(' ');

Line 4579: FROM CSI_WEBADI_STAGING

4575: ATTRIBUTE27,
4576: ATTRIBUTE28,
4577: ATTRIBUTE29,
4578: ATTRIBUTE30
4579: FROM CSI_WEBADI_STAGING
4580: where BATCH_ID = p_entry_id
4581: and INSTANCE_ID is not null;
4582:
4583:

Line 5817: FROM CSI_WEBADI_STAGING

5813: END IF;
5814: END IF;
5815:
5816: SELECT Count(*) INTO l_updt_count
5817: FROM CSI_WEBADI_STAGING
5818: where BATCH_ID = p_entry_id
5819: and INSTANCE_ID is NOT null;
5820:
5821: debug_out(' ');

Line 5911: from CSI_WEBADI_STAGING

5907: FOR inst_tab_row IN l_instance_split_tbl.FIRST .. l_instance_split_tbl.LAST
5908: LOOP
5909: Select QUANTITY, SPLIT_QTY
5910: INTO l_quantity, l_splitqty
5911: from CSI_WEBADI_STAGING
5912: where BATCH_ID = p_Entry_id
5913: and INSTANCE_ID = l_instance_split_tbl(inst_tab_row).instance_id;
5914:
5915: IF(l_quantity < l_splitqty) THEN

Line 6188: UPDATE CSI_WEBADI_STAGING

6184: END IF;
6185:
6186: IF(p_reupld_batch_id is not null) THEN
6187: --Updating the new records with the new batch Id
6188: UPDATE CSI_WEBADI_STAGING
6189: SET BATCH_ID = p_reupld_batch_id,
6190: BATCH_NAME = l_mass_edit_rec.name
6191: WHERE nvl(PROCESSING_STATUS, 'N') <> 'P'
6192: AND BATCH_ID = p_entry_id;

Line 6216: UPDATE csi_webadi_staging cws SET LAST_VLD_ORGANIZATION_ID =

6212: BEGIN
6213:
6214: --LAST_VLD_ORGANIZATION_ID
6215: BEGIN
6216: UPDATE csi_webadi_staging cws SET LAST_VLD_ORGANIZATION_ID =
6217: (
6218: SELECT O.ORGANIZATION_ID
6219: FROM HR_ALL_ORGANIZATION_UNITS O, HR_ALL_ORGANIZATION_UNITS_TL OTL
6220: WHERE O.ORGANIZATION_ID = OTL.ORGANIZATION_ID

Line 6236: UPDATE csi_webadi_staging cws SET INSTANCE_ID =

6232: END;
6233:
6234: --INSTANCE_ID
6235: BEGIN
6236: UPDATE csi_webadi_staging cws SET INSTANCE_ID =
6237: (
6238: SELECT INSTANCE_ID FROM csi_item_instances cii
6239: WHERE cii.instance_number = cws.PRODUCT_NUMBER
6240: )

Line 6252: UPDATE csi_webadi_staging cws SET ITEM_ID =

6248: END;
6249:
6250: --ITEM_ID
6251: BEGIN
6252: UPDATE csi_webadi_staging cws SET ITEM_ID =
6253: (
6254: SELECT m2.inventory_item_id
6255: FROM mtl_system_items_kfv m2,
6256: mtl_system_items m1,

Line 6286: UPDATE csi_webadi_staging cws SET OWNER_ID =

6282: END;
6283:
6284: --OWNER_ID
6285: BEGIN
6286: UPDATE csi_webadi_staging cws SET OWNER_ID =
6287: (
6288: decode(cws.OWNER_PARTY_TYPE,
6289: 'HZ_PARTIES',
6290: (SELECT party_id FROM hz_parties WHERE party_number = cws.OWNER_PARTY_NUM),

Line 6314: UPDATE csi_webadi_staging cws SET ASSOCIATE_BILL_TO_PARTY_ID =

6310: END;
6311:
6312: --ASSOCIATE_BILL_TO_PARTY_ID
6313: BEGIN
6314: UPDATE csi_webadi_staging cws SET ASSOCIATE_BILL_TO_PARTY_ID =
6315: (
6316: decode(cws.ASSOCIATE_BILL_TO_PARTY_TYPE,
6317: 'HZ_PARTIES',
6318: (SELECT party_id FROM hz_parties

Line 6344: UPDATE csi_webadi_staging cws SET ASSOCIATE_SHIP_TO_PARTY_ID =

6340: END;
6341:
6342: --ASSOCIATE_SHIP_TO_PARTY_ID
6343: BEGIN
6344: UPDATE csi_webadi_staging cws SET ASSOCIATE_SHIP_TO_PARTY_ID =
6345: (
6346: decode(cws.ASSOCIATE_SHIP_TO_PARTY_TYPE,
6347: 'HZ_PARTIES',
6348: (SELECT party_id FROM hz_parties

Line 6374: UPDATE csi_webadi_staging cws SET OWNER_ACCOUNT_ID =

6370: END;
6371:
6372: --OWNER_ACCOUNT_ID
6373: BEGIN
6374: UPDATE csi_webadi_staging cws SET OWNER_ACCOUNT_ID =
6375: (
6376: SELECT CUST_ACCOUNT_ID FROM hz_cust_accounts
6377: WHERE status = 'A'
6378: AND sysdate between nvl(ACCOUNT_ACTIVATION_DATE,sysdate) and nvl(ACCOUNT_TERMINATION_DATE ,sysdate)

Line 6394: UPDATE csi_webadi_staging cws SET ASSOCIATE_BILL_TO_ACCT_ID =

6390: END;
6391:
6392: --ASSOCIATE_BILL_TO_ACCT_ID
6393: BEGIN
6394: UPDATE csi_webadi_staging cws SET ASSOCIATE_BILL_TO_ACCT_ID =
6395: (
6396: SELECT CUST_ACCOUNT_ID FROM hz_cust_accounts
6397: WHERE status = 'A'
6398: AND sysdate between nvl(ACCOUNT_ACTIVATION_DATE,sysdate) and nvl(ACCOUNT_TERMINATION_DATE ,sysdate)

Line 6414: UPDATE csi_webadi_staging cws SET ASSOCIATE_SHIP_TO_ACCT_ID =

6410: END;
6411:
6412: -- ASSOCIATE_SHIP_TO_ACCT_ID
6413: BEGIN
6414: UPDATE csi_webadi_staging cws SET ASSOCIATE_SHIP_TO_ACCT_ID =
6415: (
6416: SELECT CUST_ACCOUNT_ID FROM hz_cust_accounts
6417: WHERE status = 'A'
6418: AND sysdate between nvl(ACCOUNT_ACTIVATION_DATE,sysdate) and nvl(ACCOUNT_TERMINATION_DATE ,sysdate)

Line 6434: UPDATE csi_webadi_staging cws SET ASSOCIATE_CONTRACT_ID =

6430: END;
6431:
6432: --ASSOCIATE_CONTRACT_ID
6433: BEGIN
6434: UPDATE csi_webadi_staging cws SET ASSOCIATE_CONTRACT_ID =
6435: (
6436: SELECT okch.id ContractId
6437: FROM okc_k_headers_all_b okch, okc_statuses_b sts, okc_k_party_roles_b k_party
6438: WHERE okch.sts_code = sts.code

Line 6468: UPDATE csi_webadi_staging cws SET ASSOCIATE_SERVICE_LINE_ID =

6464: END;
6465:
6466: --ASSOCIATE_SERVICE_LINE_ID
6467: BEGIN
6468: UPDATE csi_webadi_staging cws SET ASSOCIATE_SERVICE_LINE_ID =
6469: (
6470: SELECT okl.id
6471: FROM okc_k_lines_b okl, okc_k_items oki,
6472: mtl_system_items_kfv mtl, okc_k_headers_all_b okh

Line 6495: UPDATE csi_webadi_staging cws SET OLD_PARENT_INSTANCE =

6491: END;
6492:
6493: --OLD_PARENT_INSTANCE
6494: BEGIN
6495: UPDATE csi_webadi_staging cws SET OLD_PARENT_INSTANCE =
6496: (
6497: select cii.instance_number
6498: from csi_ii_relationships cir, csi_item_instances cii
6499: where cir.subject_id = cws.INSTANCE_ID

Line 6514: UPDATE csi_webadi_staging cws SET SYSTEM_ID =

6510: END;
6511:
6512: --SYSTEM_ID
6513: BEGIN
6514: UPDATE csi_webadi_staging cws SET SYSTEM_ID =
6515: (
6516: select s.SYSTEM_ID
6517: FROM CSI_LOOKUPS LK, csi_systems_v s
6518: WHERE s.SYSTEM_TYPE_CODE = LK.LOOKUP_CODE(+)