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_PROCESS_PVT dependencies on CSD_REPAIRS

Line 867: FROM csd_repairs cr,

863: SELECT cr.serial_number,
864: wdd.delivery_detail_id,
865: wdd.requested_quantity,
866: mtl.serial_number_control_code
867: FROM csd_repairs cr,
868: mtl_system_items_b mtl,
869: cs_estimate_details ced,
870: wsh_delivery_details wdd,
871: --Changed to view from table, bug: 4341784

Line 2344: FROM cs_incidents_all_b cs, csd_repairs csd

2340:
2341: -- swai: bug 6001057
2342: CURSOR sr_account_cu (l_repair_line_id NUMBER) is
2343: SELECT account_id
2344: FROM cs_incidents_all_b cs, csd_repairs csd
2345: WHERE cs.incident_id = csd.incident_id
2346: AND repair_line_id = l_repair_line_id;
2347:
2348: --R12 Development Changes Begin

Line 2468: -- Validate the repair line ID if it exists in csd_repairs

2464: p_api_name => l_api_name);
2465:
2466: Debug('Validate repair line id', l_mod_name, 1);
2467:
2468: -- Validate the repair line ID if it exists in csd_repairs
2469: IF NOT
2470: (Csd_Process_Util.Validate_rep_line_id(p_repair_line_id => x_product_txn_rec.repair_line_id))
2471: THEN
2472: RAISE Fnd_Api.G_EXC_ERROR;

Line 2559: -- Get service request from csd_repairs table

2555: RAISE Fnd_Api.G_EXC_ERROR;
2556: END;
2557: END IF;
2558:
2559: -- Get service request from csd_repairs table
2560: -- using repair order
2561: BEGIN
2562: SELECT incident_id,
2563: original_source_reference,

Line 2570: FROM csd_repairs

2566: INTO l_incident_id,
2567: l_orig_src_reference,
2568: l_orig_src_header_id,
2569: l_orig_src_line_id
2570: FROM csd_repairs
2571: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
2572: EXCEPTION
2573: WHEN OTHERS THEN
2574: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');

Line 3017: UPDATE csd_repairs

3013: x_product_txn_rec.PRODUCT_TRANSACTION_ID,
3014: l_mod_name,
3015: 1);
3016:
3017: UPDATE csd_repairs
3018: SET ro_txn_status = 'CHARGE_ENTERED'
3019: WHERE repair_line_id = x_product_txn_rec.REPAIR_LINE_ID;
3020: IF SQL%NOTFOUND
3021: THEN

Line 3146: UPDATE csd_repairs

3142: Fnd_Msg_Pub.ADD;
3143: RAISE CREATE_ORDER;
3144: END IF;
3145:
3146: UPDATE csd_repairs
3147: SET ro_txn_status = 'OM_SUBMITTED'
3148: WHERE repair_line_id =
3149: x_product_txn_rec.REPAIR_LINE_ID;
3150: IF SQL%NOTFOUND

Line 3484: --Update csd_repairs with status

3480: -- Fix for bug#4020651
3481: Csd_Update_Programs_Pvt.prod_txn_status_upd(p_repair_line_id => x_product_txn_rec.repair_line_id,
3482: p_commit => Fnd_Api.g_false);
3483:
3484: --Update csd_repairs with status
3485: UPDATE csd_repairs
3486: SET ro_txn_status = 'OM_BOOKED'
3487: WHERE repair_line_id =
3488: x_product_txn_rec.REPAIR_LINE_ID;

Line 3485: UPDATE csd_repairs

3481: Csd_Update_Programs_Pvt.prod_txn_status_upd(p_repair_line_id => x_product_txn_rec.repair_line_id,
3482: p_commit => Fnd_Api.g_false);
3483:
3484: --Update csd_repairs with status
3485: UPDATE csd_repairs
3486: SET ro_txn_status = 'OM_BOOKED'
3487: WHERE repair_line_id =
3488: x_product_txn_rec.REPAIR_LINE_ID;
3489: IF SQL%NOTFOUND

Line 3739: UPDATE csd_repairs

3735: RAISE RELEASE_ORDER;
3736: END IF;
3737: END IF;
3738:
3739: UPDATE csd_repairs
3740: SET ro_txn_status = 'OM_RELEASED'
3741: WHERE repair_line_id =
3742: x_product_txn_rec.REPAIR_LINE_ID;
3743: IF SQL%NOTFOUND

Line 3774: UPDATE csd_repairs

3770: RAISE RELEASE_ORDER;
3771: END IF;
3772: END IF;
3773:
3774: UPDATE csd_repairs
3775: SET ro_txn_status = 'OM_BOOKED'
3776: WHERE repair_line_id =
3777: x_product_txn_rec.REPAIR_LINE_ID;
3778: IF SQL%NOTFOUND

Line 3880: UPDATE csd_repairs

3876: RAISE SHIP_ORDER;
3877: END IF;
3878: END IF;
3879:
3880: UPDATE csd_repairs
3881: SET ro_txn_status = 'OM_SHIPPED'
3882: WHERE repair_line_id =
3883: x_product_txn_rec.REPAIR_LINE_ID;
3884: IF SQL%NOTFOUND

Line 3937: UPDATE csd_repairs

3933: -- swai: bug 5931926 - 12.0.2 added 3rd party action type
3934: IF (x_product_txn_rec.action_type IN ('RMA', 'WALK_IN_RECEIPT', 'RMA_THIRD_PTY')) AND
3935: (x_product_txn_rec.action_code = 'CUST_PROD')
3936: THEN
3937: UPDATE csd_repairs
3938: SET auto_process_rma = 'N'
3939: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
3940: END IF;
3941: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 3959: UPDATE csd_repairs

3955: -- swai: bug 5931926 - 12.0.2 added 3rd party action type
3956: IF (x_product_txn_rec.action_type IN ('RMA', 'WALK_IN_RECEIPT', 'RMA_THIRD_PTY')) AND
3957: (x_product_txn_rec.action_code = 'CUST_PROD')
3958: THEN
3959: UPDATE csd_repairs
3960: SET auto_process_rma = 'N'
3961: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
3962: END IF;
3963: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 4161: -- Validate the repair line ID if it exists in csd_repairs

4157: THEN
4158: Csd_Gen_Utility_Pvt.ADD('Validate repair line id');
4159: END IF;
4160:
4161: -- Validate the repair line ID if it exists in csd_repairs
4162: IF NOT
4163: (Csd_Process_Util.Validate_rep_line_id(p_repair_line_id => x_product_txn_rec.repair_line_id))
4164: THEN
4165: RAISE Fnd_Api.G_EXC_ERROR;

Line 4246: -- Get service request id from csd_repairs table

4242: RAISE Fnd_Api.G_EXC_ERROR;
4243: END;
4244: END IF;
4245:
4246: -- Get service request id from csd_repairs table
4247: -- using repair order
4248: BEGIN
4249: SELECT incident_id
4250: INTO l_incident_id

Line 4251: FROM csd_repairs

4247: -- using repair order
4248: BEGIN
4249: SELECT incident_id
4250: INTO l_incident_id
4251: FROM csd_repairs
4252: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
4253: EXCEPTION
4254: WHEN OTHERS THEN
4255: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');

Line 4507: UPDATE csd_repairs

4503: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
4504: Csd_Gen_Utility_Pvt.ADD('REPAIR_ORDER_ID =' ||
4505: x_product_txn_rec.repair_line_id);
4506:
4507: UPDATE csd_repairs
4508: SET ro_txn_status = 'OM_SUBMITTED'
4509: WHERE repair_line_id = x_product_txn_rec.REPAIR_LINE_ID;
4510: IF SQL%NOTFOUND
4511: THEN

Line 7178: l_ro_rec Csd_Repairs_Pub.REPLN_Rec_Type;

7174: l_msg_index NUMBER;
7175: l_return_status VARCHAR2(3);
7176: l_validate_flag BOOLEAN;
7177: l_grp_rec Csd_Repair_Groups_Pvt.REPAIR_ORDER_GROUP_REC;
7178: l_ro_rec Csd_Repairs_Pub.REPLN_Rec_Type;
7179: l_open_ro_cnt NUMBER;
7180: l_repair_group_id NUMBER;
7181: l_grp_count NUMBER;
7182: l_status VARCHAR2(10) := 'CLOSED';

Line 7207: FROM csd_repairs

7203: AND crog.incident_id = p_incident_id;
7204:
7205: CURSOR get_ro_order(p_repair_group_id IN NUMBER) IS
7206: SELECT repair_line_id
7207: FROM csd_repairs
7208: WHERE repair_group_id = p_repair_group_id;
7209:
7210: BEGIN
7211: --------------------------------------

Line 7299: FROM csd_repairs

7295:
7296: BEGIN
7297: SELECT object_version_number
7298: INTO l_ro_obj_version_number
7299: FROM csd_repairs
7300: WHERE repair_line_id = ro.repair_line_id;
7301: EXCEPTION
7302: WHEN OTHERS THEN
7303: RAISE Fnd_Api.G_EXC_ERROR;

Line 7315: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,

7311: Csd_Gen_Utility_Pvt.ADD('Update Repair Line Id =' ||
7312: ro.repair_line_id);
7313: END IF;
7314:
7315: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,
7316: P_Init_Msg_List => 'T',
7317: P_Commit => 'F',
7318: p_validation_level => 0,
7319: p_REPAIR_LINE_ID => ro.repair_line_id,

Line 7393: FROM csd_repairs

7389:
7390: BEGIN
7391: SELECT object_version_number
7392: INTO l_ro_obj_version_number
7393: FROM csd_repairs
7394: WHERE repair_line_id = ro.repair_line_id;
7395: EXCEPTION
7396: WHEN OTHERS THEN
7397: RAISE Fnd_Api.G_EXC_ERROR;

Line 7409: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,

7405: Csd_Gen_Utility_Pvt.ADD('Update Repair Line Id =' ||
7406: ro.repair_line_id);
7407: END IF;
7408:
7409: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,
7410: P_Init_Msg_List => 'T',
7411: P_Commit => 'F',
7412: p_validation_level => 0,
7413: p_REPAIR_LINE_ID => ro.repair_line_id,

Line 7482: FROM csd_repairs

7478: BEGIN
7479:
7480: SELECT COUNT(*)
7481: INTO l_open_ro_cnt
7482: FROM csd_repairs
7483: WHERE incident_id = p_incident_id
7484: AND status <> 'C';
7485:
7486: EXCEPTION

Line 7616: FROM csd_repairs

7612:
7613: BEGIN
7614: SELECT object_version_number
7615: INTO l_ro_obj_version_number
7616: FROM csd_repairs
7617: WHERE repair_line_id = p_repair_line_id;
7618: EXCEPTION
7619: WHEN OTHERS THEN
7620: RAISE Fnd_Api.G_EXC_ERROR;

Line 7627: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,

7623: l_ro_rec.object_version_number := l_ro_obj_version_number;
7624: l_ro_rec.status := 'C';
7625:
7626: -- Update the Repair Order
7627: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,
7628: P_Init_Msg_List => 'T',
7629: P_Commit => 'F',
7630: p_validation_level => 0,
7631: p_REPAIR_LINE_ID => p_repair_line_id,

Line 7649: FROM csd_repairs

7645: BEGIN
7646:
7647: SELECT repair_group_id, incident_id
7648: INTO l_repair_group_id, l_incident_id
7649: FROM csd_repairs
7650: WHERE repair_line_id = p_repair_line_id;
7651:
7652: IF (l_repair_group_id IS NOT NULL)
7653: THEN

Line 7656: FROM csd_repairs

7652: IF (l_repair_group_id IS NOT NULL)
7653: THEN
7654: SELECT COUNT(*)
7655: INTO l_grp_count
7656: FROM csd_repairs
7657: WHERE status = 'C'
7658: AND repair_group_id = l_repair_group_id;
7659: END IF;
7660:

Line 7716: FROM csd_repairs

7712: BEGIN
7713:
7714: SELECT COUNT(*)
7715: INTO l_open_ro_cnt
7716: FROM csd_repairs
7717: WHERE incident_id = l_incident_id
7718: AND status <> 'C';
7719:
7720: EXCEPTION

Line 7893: FROM CSD_REPAIRS

7889:
7890: --Cursor to get the count of repair orders for the given SR
7891: CURSOR RO_CUR(p_incident_Id NUMBER) IS
7892: SELECT COUNT(*) ro_count
7893: FROM CSD_REPAIRS
7894: WHERE INCIDENT_ID = p_incident_Id;
7895:
7896: BEGIN
7897:

Line 8420: FROM csd_repairs

8416: -- get the incident id for the repair line
8417: BEGIN
8418: SELECT incident_id
8419: INTO l_incident_id
8420: FROM csd_repairs
8421: WHERE repair_line_id = l_repair_line_id;
8422: EXCEPTION
8423: WHEN NO_DATA_FOUND THEN
8424: Fnd_Message.set_name('CSD', 'CSD_API_INV_REP_LINE_ID');

Line 8676: update csd_repairs

8672: END IF;
8673: /****************************
8674: RO is not udpated as it is does not make sense to update RO record
8675: when ever its product transactions are released. Not applicable to internal ROs.
8676: update csd_repairs
8677: set ro_txn_status = 'OM_RELEASED' ,
8678: object_version_number = Object_Version_Number + 1,
8679: Last_Update_Date = Sysdate,
8680: Last_Updated_By = Fnd_Global.User_Id,

Line 8866: Update csd_repairs

8862: No need to update repairs block when ever its product transaction
8863: line is shipped. One repair order line can have more then one product
8864: transaction line and if we update RO when ever it is released or
8865: shipped then ro_txn_Status will not be of much use.
8866: Update csd_repairs
8867: Set ro_txn_status = 'OM_SHIPPED' ,
8868: object_version_number = Object_Version_Number + 1,
8869: Last_Update_Date = Sysdate,
8870: Last_Updated_By = Fnd_Global.User_Id,

Line 9052: Csd_Gen_Utility_Pvt.ADD('Querying csd_repairs_v view');

9048: END IF;
9049: BEGIN
9050: IF (g_debug > 0)
9051: THEN
9052: Csd_Gen_Utility_Pvt.ADD('Querying csd_repairs_v view');
9053: END IF;
9054: SELECT dra.status,
9055: dra.Quantity,
9056: dra.Inventory_Item_Id,

Line 9066: FROM csd_repairs dra, fnd_lookups fndl2, csd_repair_types_vl drtvl

9062: l_Inventory_Item_id,
9063: l_RO_Repair_Type_Ref,
9064: l_RO_Number,
9065: l_RO_Status_Meaning
9066: FROM csd_repairs dra, fnd_lookups fndl2, csd_repair_types_vl drtvl
9067: WHERE repair_line_id = p_Repair_line_id
9068: and dra.repair_type_id = drtvl.repair_type_id
9069: and dra.status = fndl2.lookup_code
9070: and fndl2.lookup_type = 'CSD_REPAIR_STATUS';

Line 9122: FROM mtl_system_items_vl items, csd_repairs dra

9118: WHEN NO_DATA_FOUND THEN
9119: -- Get Item Name
9120: SELECT items.concatenated_segments
9121: INTO l_Item_Name
9122: FROM mtl_system_items_vl items, csd_repairs dra
9123: WHERE dra.repair_line_id = p_Repair_Line_Id
9124: and dra.inventory_item_id = items.inventory_item_id
9125: and items.organization_id = cs_std.get_item_valdn_orgzn_id;
9126: