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.CSD_HV_WIP_JOB_PVT dependencies on CSD_HV_WIP_JOB_PVT

Line 1: PACKAGE BODY CSD_HV_WIP_JOB_PVT as

1: PACKAGE BODY CSD_HV_WIP_JOB_PVT as
2: /* $Header: csdvhvjb.pls 120.65.12020000.14 2013/04/10 01:08:37 takwong ship $ */
3: -- Start of Comments
4: -- Package name : CSD_HV_WIP_JOB_PVT
5: -- Purpose : This package is used for High Volume Repair Execution flow

Line 4: -- Package name : CSD_HV_WIP_JOB_PVT

1: PACKAGE BODY CSD_HV_WIP_JOB_PVT as
2: /* $Header: csdvhvjb.pls 120.65.12020000.14 2013/04/10 01:08:37 takwong ship $ */
3: -- Start of Comments
4: -- Package name : CSD_HV_WIP_JOB_PVT
5: -- Purpose : This package is used for High Volume Repair Execution flow
6: --
7: --
8: -- History : 05/01/2005, Created by Shiv Ragunathan

Line 16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_HV_WIP_JOB_PVT';

12: -- End of Comments
13:
14:
15: -- Define Global Variable --
16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_HV_WIP_JOB_PVT';
17:
18: -- swai: bug 6995498/7182047 wrapper function to get the default item revision
19: -- Depending on the transaction type, check the corresponding profile option
20: -- and return null if the profile is No.

Line 771: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_transactions_header.';

767:
768:
769: -- constant used for FND_LOG debug messages
770:
771: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_transactions_header.';
772:
773:
774: -- Constants Used for Inserting into mtl_transactions_interface,
775:

Line 911: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.update_transactions_header.';

907:
908:
909: -- constant used for FND_LOG debug messages
910:
911: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.update_transactions_header.';
912:
913:
914:
915:

Line 976: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_transaction_lots';

972:
973:
974: -- constant used for FND_LOG debug messages
975:
976: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_transaction_lots';
977:
978:
979: l_creation_date DATE;
980: l_last_update_date DATE;

Line 1065: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_upd_serial_numbers.';

1061:
1062:
1063: -- constant used for FND_LOG debug messages
1064:
1065: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_upd_serial_numbers.';
1066:
1067:
1068: l_creation_date DATE;
1069: l_last_update_date DATE;

Line 1175: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_transactions_header.';

1171:
1172:
1173: -- constant used for FND_LOG debug messages
1174:
1175: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_transactions_header.';
1176:
1177:
1178: -- Constants Used for Inserting into mtl_transactions_interface,
1179:

Line 1312: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_wip_move_txn';

1308:
1309:
1310: -- constant used for FND_LOG debug messages
1311:
1312: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_wip_move_txn';
1313:
1314:
1315: -- Indicates that the process Phase is Validation
1316: lc_validation_phase CONSTANT NUMBER := 1;

Line 1613: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_job_comp_txn';

1609: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_JOB_COMP_TXN';
1610: lc_api_version_number CONSTANT NUMBER := 1.0;
1611:
1612: -- constants used for FND_LOG debug messages
1613: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_job_comp_txn';
1614:
1615: l_need_details_flag VARCHAR2(1) := 'F';
1616: l_transaction_header_id NUMBER;
1617:

Line 1778: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_job_comp_txn';

1774: lc_api_name CONSTANT VARCHAR2(30) := 'INSERT_JOB_COMP_TXN';
1775: lc_api_version_number CONSTANT NUMBER := 1.0;
1776:
1777: -- constants used for FND_LOG debug messages
1778: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_job_comp_txn';
1779:
1780: lc_revision_controlled CONSTANT NUMBER := 2;
1781: lc_full_lot_control CONSTANT NUMBER := 2;
1782: lc_predefined_serial_control CONSTANT NUMBER := 2;

Line 2276: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_mti_transactions';

2272: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_MTI_TRANSACTIONS';
2273: lc_api_version_number CONSTANT NUMBER := 1.0;
2274:
2275: -- constants used for FND_LOG debug messages
2276: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_mti_transactions';
2277:
2278: lc_MTI_source_table CONSTANT NUMBER := 1;
2279:
2280: l_table NUMBER;

Line 2472: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_oper_comp_txn';

2468: lc_api_version_number CONSTANT NUMBER := 1.0;
2469:
2470: -- constants used for FND_LOG debug messages
2471:
2472: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_oper_comp_txn';
2473:
2474: -- Indicates that the process Phase is Validation
2475: -- lc_validation_phase CONSTANT NUMBER := 1;
2476:

Line 2826: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_issue_mtl_txn';

2822: lc_api_version_number CONSTANT NUMBER := 1.0;
2823:
2824: -- constants used for FND_LOG debug messages
2825:
2826: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_issue_mtl_txn';
2827:
2828:
2829: lc_revision_controlled CONSTANT NUMBER := 2;
2830: lc_full_lot_control CONSTANT NUMBER := 2;

Line 3781: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_issue_mtl_txns_lot_srl';

3777: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ISSUE_MTL_TXNS_LOT_SRL';
3778: lc_api_version_number CONSTANT NUMBER := 1.0;
3779:
3780: -- constants used for FND_LOG debug messages
3781: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_issue_mtl_txns_lot_srl';
3782:
3783: BEGIN
3784: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3785: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 3929: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.update_mtl_txns_lot_srl';

3925: lc_api_name CONSTANT VARCHAR2(30) := 'UPDATE_MTL_TXNS_LOT_SRL';
3926: lc_api_version_number CONSTANT NUMBER := 1.0;
3927:
3928: -- constants used for FND_LOG debug messages
3929: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.update_mtl_txns_lot_srl';
3930:
3931: lc_revision_controlled CONSTANT NUMBER := 2;
3932: lc_full_lot_control CONSTANT NUMBER := 2;
3933: lc_predefined_serial_control CONSTANT NUMBER := 2;

Line 4131: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_transact_res_txn';

4127: lc_api_version_number CONSTANT NUMBER := 1.0;
4128:
4129: -- constants used for FND_LOG debug messages
4130:
4131: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_transact_res_txn';
4132:
4133:
4134: -- Constants Used for Inserting into wip_job_schedule_interface,
4135: -- and details interface tables

Line 4650: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_save_mtl_txn_dtls';

4646: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_SAVE_CSD_MTL_TXN_DTLS';
4647: lc_api_version_number CONSTANT NUMBER := 1.0;
4648:
4649: -- constants used for FND_LOG debug messages
4650: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_save_mtl_txn_dtls';
4651:
4652: -- Constants Used for Inserting into wip_job_schedule_interface,
4653: -- These are the values needed for WIP Mass Load to pick up the records
4654:

Line 6326: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.create_wip_job';

6322:
6323:
6324: -- COnstants used for FND_LOG debug messages
6325:
6326: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.create_wip_job';
6327:
6328:
6329:
6330: l_user_id NUMBER;

Line 6341: l_mtl_txn_dtls_tbl CSD_HV_WIP_JOB_PVT.MTL_TXN_DTLS_TBL_TYPE;

6337:
6338: --*****Below are the code to Default Repair Item as Material on Job**********
6339: l_default_ro_item VARCHAR2(1);
6340: -- l_wip_entity_id NUMBER;
6341: l_mtl_txn_dtls_tbl CSD_HV_WIP_JOB_PVT.MTL_TXN_DTLS_TBL_TYPE;
6342: l_op_created VARCHAR2(10);
6343: l_num_other_jobs NUMBER :=0; -- swai: bug 7477845/7483291
6344:
6345:

Line 6777: CSD_HV_WIP_JOB_PVT.PROCESS_SAVE_MTL_TXN_DTLS

6773: end if;
6774: --*****End of the code to Default Repair Item as Material on Job**********
6775:
6776: -- call API to create Repair Actuals header
6777: CSD_HV_WIP_JOB_PVT.PROCESS_SAVE_MTL_TXN_DTLS
6778: ( p_api_version_number => 1.0,
6779: p_init_msg_list => 'T',
6780: p_commit => 'F',
6781: p_validation_level => 1,

Line 7078: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.generate_wip_jobs_from_scs';

7074: lc_service_code CONSTANT VARCHAR2(30) := 'SERVICE_CODE';
7075:
7076:
7077: -- Constants used for FND_LOG debug messages
7078: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.generate_wip_jobs_from_scs';
7079:
7080: l_object_version_number NUMBER;
7081: l_user_id NUMBER;
7082: l_repair_xref_id NUMBER;

Line 7151: l_mtl_txn_dtls_tbl CSD_HV_WIP_JOB_PVT.MTL_TXN_DTLS_TBL_TYPE;

7147:
7148: --*****Below are the code to Default Repair Item as Material on Job**********
7149: l_default_ro_item VARCHAR2(1);
7150: -- l_wip_entity_id NUMBER;
7151: l_mtl_txn_dtls_tbl CSD_HV_WIP_JOB_PVT.MTL_TXN_DTLS_TBL_TYPE;
7152: l_op_created VARCHAR2(10);
7153: l_num_other_jobs NUMBER :=0; -- swai: bug 7477845/7483291
7154:
7155:

Line 7668: CSD_HV_WIP_JOB_PVT.PROCESS_SAVE_MTL_TXN_DTLS

7664:
7665: --*****End of the code to Default Repair Item as Material on Job**********
7666:
7667: if (l_mtl_txn_dtls_tbl.count) > 0 then
7668: CSD_HV_WIP_JOB_PVT.PROCESS_SAVE_MTL_TXN_DTLS
7669: (p_api_version_number => 1.0,
7670: p_init_msg_list => 'T',
7671: p_commit => 'F',
7672: p_validation_level => 1,

Line 8001: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_auto_issue_mtl_txn';

7997: ) IS
7998: -- constants used for FND_LOG debug messages
7999: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_AUTO_ISSUE_MTL_TXN';
8000: lc_api_version_number CONSTANT NUMBER := 1.0;
8001: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_auto_issue_mtl_txn';
8002:
8003: CURSOR get_wip_operation_mtls (p_wip_entity_id number, p_operation_seq_num number) is
8004: SELECT * FROM
8005: ( SELECT

Line 8220: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_auto_transact_res_txn';

8216: ) IS
8217: -- constants used for FND_LOG debug messages
8218: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_AUTO_TRANSACT_RES_TXN';
8219: lc_api_version_number CONSTANT NUMBER := 1.0;
8220: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_auto_transact_res_txn';
8221:
8222: CURSOR get_wip_operation_res (p_wip_entity_id number, p_operation_seq_num number) is
8223: SELECT * FROM
8224: ( SELECT

Line 8228: + csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )

8224: ( SELECT
8225: WTD.WIP_TRANSACTION_DETAIL_ID,
8226: ROUND(WOR.USAGE_RATE_OR_AMOUNT * DECODE(WOR.BASIS_TYPE,1, WO.SCHEDULED_QUANTITY,1), 6) required_quantity,
8227: decode (( WOR.APPLIED_RESOURCE_UNITS
8228: + csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )
8229: ) , 0 , to_number(null) ,
8230: ( WOR.APPLIED_RESOURCE_UNITS
8231: + csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )
8232: ) ) QUANTITY_APPLIED,

Line 8231: + csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )

8227: decode (( WOR.APPLIED_RESOURCE_UNITS
8228: + csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )
8229: ) , 0 , to_number(null) ,
8230: ( WOR.APPLIED_RESOURCE_UNITS
8231: + csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )
8232: ) ) QUANTITY_APPLIED,
8233: null pending_quantity,
8234: wdj.start_quantity,
8235: wo.scheduled_quantity op_scheduled_quantity,

Line 8246: - csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )

8242: WOR.OPERATION_SEQ_NUM,
8243: nvl( WTD.TRANSACTION_QUANTITY,
8244: decode ( sign (( WOR.USAGE_RATE_OR_AMOUNT * DECODE(WOR.BASIS_TYPE,1, WO.SCHEDULED_QUANTITY,1) )
8245: - WOR.APPLIED_RESOURCE_UNITS
8246: - csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )
8247: ) , 1 ,
8248: round ((( WOR.USAGE_RATE_OR_AMOUNT * DECODE(WOR.BASIS_TYPE,1, WO.SCHEDULED_QUANTITY,1) )
8249: - WOR.APPLIED_RESOURCE_UNITS
8250: - csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )

Line 8250: - csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )

8246: - csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )
8247: ) , 1 ,
8248: round ((( WOR.USAGE_RATE_OR_AMOUNT * DECODE(WOR.BASIS_TYPE,1, WO.SCHEDULED_QUANTITY,1) )
8249: - WOR.APPLIED_RESOURCE_UNITS
8250: - csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )
8251: ), 6 ), 0 )
8252: ) TRANSACTION_QUANTITY,
8253: nvl ( WTD.TRANSACTION_UOM , WOR.UOM_CODE) transaction_uom, -- transaction uom
8254: WOR.UOM_CODE,

Line 8443: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_auto_oper_comp_txn';

8439:
8440: -- constants used for FND_LOG debug messages
8441: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_AUTO_OPER_COMP_TXN';
8442: lc_api_version_number CONSTANT NUMBER := 1.0;
8443: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_auto_oper_comp_txn';
8444:
8445: CURSOR get_wip_operation (p_wip_entity_id number, p_operation_seq_num number) is
8446: SELECT
8447: we.wip_entity_name,

Line 8605: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_time_clock_res_txn';

8601: ) IS
8602: -- constants used for FND_LOG debug messages
8603: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_TIME_CLOCK_RES_TXN';
8604: lc_api_version_number CONSTANT NUMBER := 1.0;
8605: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_time_clock_res_txn';
8606:
8607: l_wip_entity_id NUMBER;
8608: l_operation_seq_num NUMBER;
8609: l_employee_id NUMBER;

Line 8684: + csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id,

8680: ROUND(WOR.USAGE_RATE_OR_AMOUNT * DECODE(WOR.BASIS_TYPE,1, WO.SCHEDULED_QUANTITY,1), 6) required_quantity,
8681: WO.SCHEDULED_QUANTITY op_scheduled_quantity,
8682: ROUND( decode (
8683: ( WOR.APPLIED_RESOURCE_UNITS
8684: + csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id,
8685: wor.operation_seq_num,
8686: wor.resource_seq_num,
8687: WOR.UOM_CODE ) ) , 0 ,
8688: to_number(null) ,

Line 8690: + csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id,

8686: wor.resource_seq_num,
8687: WOR.UOM_CODE ) ) , 0 ,
8688: to_number(null) ,
8689: ( WOR.APPLIED_RESOURCE_UNITS
8690: + csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id,
8691: wor.operation_seq_num,
8692: wor.resource_seq_num,
8693: WOR.UOM_CODE ) )
8694: ), 2

Line 8699: - csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )

8695: ) APPLIED_QUANTITY, -- quantity applied
8696: NVL( WTD.TRANSACTION_QUANTITY,
8697: decode ( sign (( WOR.USAGE_RATE_OR_AMOUNT * DECODE(WOR.BASIS_TYPE,1, WO.SCHEDULED_QUANTITY,1) )
8698: - WOR.APPLIED_RESOURCE_UNITS
8699: - csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )
8700: ) , 1 ,
8701: round ((( WOR.USAGE_RATE_OR_AMOUNT * DECODE(WOR.BASIS_TYPE,1, WO.SCHEDULED_QUANTITY,1) )
8702: - WOR.APPLIED_RESOURCE_UNITS
8703: - csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )

Line 8703: - csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )

8699: - csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )
8700: ) , 1 ,
8701: round ((( WOR.USAGE_RATE_OR_AMOUNT * DECODE(WOR.BASIS_TYPE,1, WO.SCHEDULED_QUANTITY,1) )
8702: - WOR.APPLIED_RESOURCE_UNITS
8703: - csd_hv_wip_job_pvt.get_pending_quantity ( wor.wip_entity_id, wor.operation_seq_num, wor.resource_seq_num, WOR.UOM_CODE )
8704: ), 6 ), 0 )
8705: ) TRANSACTION_QUANTITY,
8706: nvl ( WTD.TRANSACTION_UOM , WOR.UOM_CODE) transaction_uom, -- transaction uom
8707: WOR.UOM_CODE,

Line 8988: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_comp_work_ro_status';

8984: ) IS
8985: -- constants used for FND_LOG debug messages
8986: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_COMP_WORK_RO_STATUS';
8987: lc_api_version_number CONSTANT NUMBER := 1.0;
8988: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_comp_work_ro_status';
8989:
8990: cursor c_get_repair_info is
8991: select repair_type_id, flow_status_id, object_version_number
8992: from csd_repairs

Line 9164: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_delete_mtl_txn_dtl';

9160: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_DELETE_MTL_TXN_DTL';
9161: lc_api_version_number CONSTANT NUMBER := 1.0;
9162:
9163: -- constants used for FND_LOG debug messages
9164: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_delete_mtl_txn_dtl';
9165:
9166: -- Constants Used for Inserting into wip_job_schedule_interface,
9167: -- These are the values needed for WIP Mass Load to pick up the records
9168:

Line 9455: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.is_delete_wip_op_valid';

9451: and wip.quantity_issued > 0
9452: and rownum = 1;
9453:
9454:
9455: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.is_delete_wip_op_valid';
9456: lc_valid CONSTANT VARCHAR2(1) := 'Y';
9457: lc_not_valid CONSTANT VARCHAR2(1) := 'N';
9458: l_return_status VARCHAR2(1);
9459: l_error_message VARCHAR2(2000);

Line 9581: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_delete_op_dtl';

9577: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_DELETE_OP_DTL';
9578: lc_api_version_number CONSTANT NUMBER := 1.0;
9579:
9580: -- constants used for FND_LOG debug messages
9581: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.process_delete_op_dtl';
9582:
9583:
9584: l_return_status VARCHAR2(1);
9585: l_error_message VARCHAR2(2000);

Line 9869: lc_mod_name CONSTANT VARCHAR2(60) := 'csd.plsql.csd_hv_wip_job_pvt.update_mat_issue_quantities';

9865: )
9866: IS
9867: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_DELETE_OP_DTL';
9868: lc_api_version_number CONSTANT NUMBER := 1.0;
9869: lc_mod_name CONSTANT VARCHAR2(60) := 'csd.plsql.csd_hv_wip_job_pvt.update_mat_issue_quantities';
9870: l_transaction_type_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
9871: l_transaction_quantities JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
9872: l_wip_transaction_detail_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
9873:

Line 10334: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.generate_estimate_from_wip';

10330: lc_api_name CONSTANT VARCHAR2(30) := 'GENERATE_ESTIMATE_FROM_WIP';
10331: lc_api_version_number CONSTANT NUMBER := 1.0;
10332:
10333: -- constants used for FND_LOG debug messages
10334: lc_mod_name VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.generate_estimate_from_wip';
10335:
10336: l_repair_type_id NUMBER;
10337: l_business_process_id NUMBER;
10338: l_currency_code VARCHAR2(3);

Line 10489: END CSD_HV_WIP_JOB_PVT;

10485: 'OTHERS Exception');
10486: END IF;
10487: END generate_estimate_from_wip;
10488:
10489: END CSD_HV_WIP_JOB_PVT;