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 WIP_COST_TXN_INTERFACE

Line 68: wip_cost_txn_interface wcti

64:
65: Cursor get_pending_qty_uom is
66: select wcti.transaction_quantity,
67: wcti.transaction_uom from
68: wip_cost_txn_interface wcti
69: where
70: wcti.wip_entity_id = p_wip_entity_id and
71: wcti.operation_seq_num = p_operation_seq_num and
72: wcti.resource_seq_num = p_resource_seq_num and

Line 1126: p_wip_cost_txn_interface_rec IN wip_cost_txn_interface%ROWTYPE,

1122:
1123:
1124: PROCEDURE insert_wip_cost_txn
1125: (
1126: p_wip_cost_txn_interface_rec IN wip_cost_txn_interface%ROWTYPE,
1127: x_return_status OUT NOCOPY VARCHAR2
1128: )
1129: IS
1130:

Line 1189: --insert into table wip_cost_txn_interface

1185: l_last_updated_by_name := fnd_global.user_name;
1186: l_last_update_login := fnd_global.login_id;
1187:
1188:
1189: --insert into table wip_cost_txn_interface
1190: BEGIN
1191:
1192: INSERT INTO wip_cost_txn_interface
1193: (last_updated_by_name,

Line 1192: INSERT INTO wip_cost_txn_interface

1188:
1189: --insert into table wip_cost_txn_interface
1190: BEGIN
1191:
1192: INSERT INTO wip_cost_txn_interface
1193: (last_updated_by_name,
1194: last_updated_by,
1195: last_update_date,
1196: last_update_login,

Line 1223: p_wip_cost_txn_interface_rec.operation_seq_num,

1219: l_last_update_date,
1220: l_last_update_login,
1221: l_created_by_name,
1222: l_creation_date, -- sysdate,
1223: p_wip_cost_txn_interface_rec.operation_seq_num,
1224: p_wip_cost_txn_interface_rec.organization_id,
1225: p_wip_cost_txn_interface_rec.organization_code,
1226: l_process_phase,
1227: l_process_status,

Line 1224: p_wip_cost_txn_interface_rec.organization_id,

1220: l_last_update_login,
1221: l_created_by_name,
1222: l_creation_date, -- sysdate,
1223: p_wip_cost_txn_interface_rec.operation_seq_num,
1224: p_wip_cost_txn_interface_rec.organization_id,
1225: p_wip_cost_txn_interface_rec.organization_code,
1226: l_process_phase,
1227: l_process_status,
1228: p_wip_cost_txn_interface_rec.resource_seq_num,

Line 1225: p_wip_cost_txn_interface_rec.organization_code,

1221: l_created_by_name,
1222: l_creation_date, -- sysdate,
1223: p_wip_cost_txn_interface_rec.operation_seq_num,
1224: p_wip_cost_txn_interface_rec.organization_id,
1225: p_wip_cost_txn_interface_rec.organization_code,
1226: l_process_phase,
1227: l_process_status,
1228: p_wip_cost_txn_interface_rec.resource_seq_num,
1229: p_wip_cost_txn_interface_rec.transaction_date,

Line 1228: p_wip_cost_txn_interface_rec.resource_seq_num,

1224: p_wip_cost_txn_interface_rec.organization_id,
1225: p_wip_cost_txn_interface_rec.organization_code,
1226: l_process_phase,
1227: l_process_status,
1228: p_wip_cost_txn_interface_rec.resource_seq_num,
1229: p_wip_cost_txn_interface_rec.transaction_date,
1230: p_wip_cost_txn_interface_rec.transaction_quantity,
1231: p_wip_cost_txn_interface_rec.transaction_type,
1232: p_wip_cost_txn_interface_rec.transaction_uom,

Line 1229: p_wip_cost_txn_interface_rec.transaction_date,

1225: p_wip_cost_txn_interface_rec.organization_code,
1226: l_process_phase,
1227: l_process_status,
1228: p_wip_cost_txn_interface_rec.resource_seq_num,
1229: p_wip_cost_txn_interface_rec.transaction_date,
1230: p_wip_cost_txn_interface_rec.transaction_quantity,
1231: p_wip_cost_txn_interface_rec.transaction_type,
1232: p_wip_cost_txn_interface_rec.transaction_uom,
1233: p_wip_cost_txn_interface_rec.wip_entity_name,

Line 1230: p_wip_cost_txn_interface_rec.transaction_quantity,

1226: l_process_phase,
1227: l_process_status,
1228: p_wip_cost_txn_interface_rec.resource_seq_num,
1229: p_wip_cost_txn_interface_rec.transaction_date,
1230: p_wip_cost_txn_interface_rec.transaction_quantity,
1231: p_wip_cost_txn_interface_rec.transaction_type,
1232: p_wip_cost_txn_interface_rec.transaction_uom,
1233: p_wip_cost_txn_interface_rec.wip_entity_name,
1234: p_wip_cost_txn_interface_rec.wip_entity_id,

Line 1231: p_wip_cost_txn_interface_rec.transaction_type,

1227: l_process_status,
1228: p_wip_cost_txn_interface_rec.resource_seq_num,
1229: p_wip_cost_txn_interface_rec.transaction_date,
1230: p_wip_cost_txn_interface_rec.transaction_quantity,
1231: p_wip_cost_txn_interface_rec.transaction_type,
1232: p_wip_cost_txn_interface_rec.transaction_uom,
1233: p_wip_cost_txn_interface_rec.wip_entity_name,
1234: p_wip_cost_txn_interface_rec.wip_entity_id,
1235: p_wip_cost_txn_interface_rec.employee_id,

Line 1232: p_wip_cost_txn_interface_rec.transaction_uom,

1228: p_wip_cost_txn_interface_rec.resource_seq_num,
1229: p_wip_cost_txn_interface_rec.transaction_date,
1230: p_wip_cost_txn_interface_rec.transaction_quantity,
1231: p_wip_cost_txn_interface_rec.transaction_type,
1232: p_wip_cost_txn_interface_rec.transaction_uom,
1233: p_wip_cost_txn_interface_rec.wip_entity_name,
1234: p_wip_cost_txn_interface_rec.wip_entity_id,
1235: p_wip_cost_txn_interface_rec.employee_id,
1236: p_wip_cost_txn_interface_rec.employee_num,

Line 1233: p_wip_cost_txn_interface_rec.wip_entity_name,

1229: p_wip_cost_txn_interface_rec.transaction_date,
1230: p_wip_cost_txn_interface_rec.transaction_quantity,
1231: p_wip_cost_txn_interface_rec.transaction_type,
1232: p_wip_cost_txn_interface_rec.transaction_uom,
1233: p_wip_cost_txn_interface_rec.wip_entity_name,
1234: p_wip_cost_txn_interface_rec.wip_entity_id,
1235: p_wip_cost_txn_interface_rec.employee_id,
1236: p_wip_cost_txn_interface_rec.employee_num,
1237: l_entity_type

Line 1234: p_wip_cost_txn_interface_rec.wip_entity_id,

1230: p_wip_cost_txn_interface_rec.transaction_quantity,
1231: p_wip_cost_txn_interface_rec.transaction_type,
1232: p_wip_cost_txn_interface_rec.transaction_uom,
1233: p_wip_cost_txn_interface_rec.wip_entity_name,
1234: p_wip_cost_txn_interface_rec.wip_entity_id,
1235: p_wip_cost_txn_interface_rec.employee_id,
1236: p_wip_cost_txn_interface_rec.employee_num,
1237: l_entity_type
1238: ) ;

Line 1235: p_wip_cost_txn_interface_rec.employee_id,

1231: p_wip_cost_txn_interface_rec.transaction_type,
1232: p_wip_cost_txn_interface_rec.transaction_uom,
1233: p_wip_cost_txn_interface_rec.wip_entity_name,
1234: p_wip_cost_txn_interface_rec.wip_entity_id,
1235: p_wip_cost_txn_interface_rec.employee_id,
1236: p_wip_cost_txn_interface_rec.employee_num,
1237: l_entity_type
1238: ) ;
1239:

Line 1236: p_wip_cost_txn_interface_rec.employee_num,

1232: p_wip_cost_txn_interface_rec.transaction_uom,
1233: p_wip_cost_txn_interface_rec.wip_entity_name,
1234: p_wip_cost_txn_interface_rec.wip_entity_id,
1235: p_wip_cost_txn_interface_rec.employee_id,
1236: p_wip_cost_txn_interface_rec.employee_num,
1237: l_entity_type
1238: ) ;
1239:
1240:

Line 3705: -- Constants used for inserting into wip_cost_txn_interface

3701: lc_load_res_type CONSTANT NUMBER := 1;
3702: lc_substitution_change_type CONSTANT NUMBER := 3;
3703:
3704:
3705: -- Constants used for inserting into wip_cost_txn_interface
3706:
3707: lc_res_transaction_type CONSTANT NUMBER := 1;
3708:
3709:

Line 3711: -- and wip_cost_txn_interface data

3707: lc_res_transaction_type CONSTANT NUMBER := 1;
3708:
3709:
3710: -- Records to hold the Job header,details
3711: -- and wip_cost_txn_interface data
3712:
3713: l_wip_cost_txn_interface_rec wip_cost_txn_interface%ROWTYPE;
3714: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
3715: l_job_details_rec wip_job_dtls_interface%ROWTYPE;

Line 3713: l_wip_cost_txn_interface_rec wip_cost_txn_interface%ROWTYPE;

3709:
3710: -- Records to hold the Job header,details
3711: -- and wip_cost_txn_interface data
3712:
3713: l_wip_cost_txn_interface_rec wip_cost_txn_interface%ROWTYPE;
3714: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
3715: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
3716:
3717:

Line 3824: l_wip_cost_txn_interface_rec.transaction_date := sysdate;

3820: FND_MSG_PUB.ADD;
3821: RAISE FND_API.G_EXC_ERROR;
3822: end if; */
3823:
3824: l_wip_cost_txn_interface_rec.transaction_date := sysdate;
3825: l_wip_cost_txn_interface_rec.transaction_type := lc_res_transaction_type;
3826:
3827:
3828: -- Get the Group_id to be used for WIP Mass Load,

Line 3825: l_wip_cost_txn_interface_rec.transaction_type := lc_res_transaction_type;

3821: RAISE FND_API.G_EXC_ERROR;
3822: end if; */
3823:
3824: l_wip_cost_txn_interface_rec.transaction_date := sysdate;
3825: l_wip_cost_txn_interface_rec.transaction_type := lc_res_transaction_type;
3826:
3827:
3828: -- Get the Group_id to be used for WIP Mass Load,
3829:

Line 3843: l_wip_cost_txn_interface_rec.operation_seq_num := p_res_txn_dtls_tbl(res_ctr).operation_seq_num;

3839: FOR res_ctr in p_res_txn_dtls_tbl.FIRST.. p_res_txn_dtls_tbl.LAST
3840:
3841: LOOP
3842:
3843: l_wip_cost_txn_interface_rec.operation_seq_num := p_res_txn_dtls_tbl(res_ctr).operation_seq_num;
3844: l_wip_cost_txn_interface_rec.organization_id := p_res_txn_dtls_tbl(res_ctr).organization_id;
3845: l_wip_cost_txn_interface_rec.organization_code := p_res_txn_dtls_tbl(res_ctr).organization_code;
3846: l_wip_cost_txn_interface_rec.resource_seq_num := p_res_txn_dtls_tbl(res_ctr).resource_seq_num;
3847: l_wip_cost_txn_interface_rec.transaction_quantity := p_res_txn_dtls_tbl(res_ctr).transaction_quantity;

Line 3844: l_wip_cost_txn_interface_rec.organization_id := p_res_txn_dtls_tbl(res_ctr).organization_id;

3840:
3841: LOOP
3842:
3843: l_wip_cost_txn_interface_rec.operation_seq_num := p_res_txn_dtls_tbl(res_ctr).operation_seq_num;
3844: l_wip_cost_txn_interface_rec.organization_id := p_res_txn_dtls_tbl(res_ctr).organization_id;
3845: l_wip_cost_txn_interface_rec.organization_code := p_res_txn_dtls_tbl(res_ctr).organization_code;
3846: l_wip_cost_txn_interface_rec.resource_seq_num := p_res_txn_dtls_tbl(res_ctr).resource_seq_num;
3847: l_wip_cost_txn_interface_rec.transaction_quantity := p_res_txn_dtls_tbl(res_ctr).transaction_quantity;
3848:

Line 3845: l_wip_cost_txn_interface_rec.organization_code := p_res_txn_dtls_tbl(res_ctr).organization_code;

3841: LOOP
3842:
3843: l_wip_cost_txn_interface_rec.operation_seq_num := p_res_txn_dtls_tbl(res_ctr).operation_seq_num;
3844: l_wip_cost_txn_interface_rec.organization_id := p_res_txn_dtls_tbl(res_ctr).organization_id;
3845: l_wip_cost_txn_interface_rec.organization_code := p_res_txn_dtls_tbl(res_ctr).organization_code;
3846: l_wip_cost_txn_interface_rec.resource_seq_num := p_res_txn_dtls_tbl(res_ctr).resource_seq_num;
3847: l_wip_cost_txn_interface_rec.transaction_quantity := p_res_txn_dtls_tbl(res_ctr).transaction_quantity;
3848:
3849: If l_wip_cost_txn_interface_rec.transaction_quantity = 0 then

Line 3846: l_wip_cost_txn_interface_rec.resource_seq_num := p_res_txn_dtls_tbl(res_ctr).resource_seq_num;

3842:
3843: l_wip_cost_txn_interface_rec.operation_seq_num := p_res_txn_dtls_tbl(res_ctr).operation_seq_num;
3844: l_wip_cost_txn_interface_rec.organization_id := p_res_txn_dtls_tbl(res_ctr).organization_id;
3845: l_wip_cost_txn_interface_rec.organization_code := p_res_txn_dtls_tbl(res_ctr).organization_code;
3846: l_wip_cost_txn_interface_rec.resource_seq_num := p_res_txn_dtls_tbl(res_ctr).resource_seq_num;
3847: l_wip_cost_txn_interface_rec.transaction_quantity := p_res_txn_dtls_tbl(res_ctr).transaction_quantity;
3848:
3849: If l_wip_cost_txn_interface_rec.transaction_quantity = 0 then
3850: FND_MESSAGE.SET_NAME('CSD','CSD_TRX_QTY_ZERO');

Line 3847: l_wip_cost_txn_interface_rec.transaction_quantity := p_res_txn_dtls_tbl(res_ctr).transaction_quantity;

3843: l_wip_cost_txn_interface_rec.operation_seq_num := p_res_txn_dtls_tbl(res_ctr).operation_seq_num;
3844: l_wip_cost_txn_interface_rec.organization_id := p_res_txn_dtls_tbl(res_ctr).organization_id;
3845: l_wip_cost_txn_interface_rec.organization_code := p_res_txn_dtls_tbl(res_ctr).organization_code;
3846: l_wip_cost_txn_interface_rec.resource_seq_num := p_res_txn_dtls_tbl(res_ctr).resource_seq_num;
3847: l_wip_cost_txn_interface_rec.transaction_quantity := p_res_txn_dtls_tbl(res_ctr).transaction_quantity;
3848:
3849: If l_wip_cost_txn_interface_rec.transaction_quantity = 0 then
3850: FND_MESSAGE.SET_NAME('CSD','CSD_TRX_QTY_ZERO');
3851: FND_MSG_PUB.ADD;

Line 3849: If l_wip_cost_txn_interface_rec.transaction_quantity = 0 then

3845: l_wip_cost_txn_interface_rec.organization_code := p_res_txn_dtls_tbl(res_ctr).organization_code;
3846: l_wip_cost_txn_interface_rec.resource_seq_num := p_res_txn_dtls_tbl(res_ctr).resource_seq_num;
3847: l_wip_cost_txn_interface_rec.transaction_quantity := p_res_txn_dtls_tbl(res_ctr).transaction_quantity;
3848:
3849: If l_wip_cost_txn_interface_rec.transaction_quantity = 0 then
3850: FND_MESSAGE.SET_NAME('CSD','CSD_TRX_QTY_ZERO');
3851: FND_MSG_PUB.ADD;
3852: RAISE FND_API.G_EXC_ERROR;
3853: end if;

Line 3855: l_wip_cost_txn_interface_rec.transaction_uom := p_res_txn_dtls_tbl(res_ctr).transaction_uom;

3851: FND_MSG_PUB.ADD;
3852: RAISE FND_API.G_EXC_ERROR;
3853: end if;
3854:
3855: l_wip_cost_txn_interface_rec.transaction_uom := p_res_txn_dtls_tbl(res_ctr).transaction_uom;
3856: l_wip_cost_txn_interface_rec.wip_entity_name := p_res_txn_dtls_tbl(res_ctr).wip_entity_name;
3857: l_wip_cost_txn_interface_rec.wip_entity_id := p_res_txn_dtls_tbl(res_ctr).wip_entity_id;
3858:
3859: -- l_wip_cost_txn_interface_rec.employee_id := p_res_txn_dtls_tbl(res_ctr).employee_id;

Line 3856: l_wip_cost_txn_interface_rec.wip_entity_name := p_res_txn_dtls_tbl(res_ctr).wip_entity_name;

3852: RAISE FND_API.G_EXC_ERROR;
3853: end if;
3854:
3855: l_wip_cost_txn_interface_rec.transaction_uom := p_res_txn_dtls_tbl(res_ctr).transaction_uom;
3856: l_wip_cost_txn_interface_rec.wip_entity_name := p_res_txn_dtls_tbl(res_ctr).wip_entity_name;
3857: l_wip_cost_txn_interface_rec.wip_entity_id := p_res_txn_dtls_tbl(res_ctr).wip_entity_id;
3858:
3859: -- l_wip_cost_txn_interface_rec.employee_id := p_res_txn_dtls_tbl(res_ctr).employee_id;
3860:

Line 3857: l_wip_cost_txn_interface_rec.wip_entity_id := p_res_txn_dtls_tbl(res_ctr).wip_entity_id;

3853: end if;
3854:
3855: l_wip_cost_txn_interface_rec.transaction_uom := p_res_txn_dtls_tbl(res_ctr).transaction_uom;
3856: l_wip_cost_txn_interface_rec.wip_entity_name := p_res_txn_dtls_tbl(res_ctr).wip_entity_name;
3857: l_wip_cost_txn_interface_rec.wip_entity_id := p_res_txn_dtls_tbl(res_ctr).wip_entity_id;
3858:
3859: -- l_wip_cost_txn_interface_rec.employee_id := p_res_txn_dtls_tbl(res_ctr).employee_id;
3860:
3861: l_wip_cost_txn_interface_rec.employee_id := p_res_txn_dtls_tbl(res_ctr).employee_id;

Line 3859: -- l_wip_cost_txn_interface_rec.employee_id := p_res_txn_dtls_tbl(res_ctr).employee_id;

3855: l_wip_cost_txn_interface_rec.transaction_uom := p_res_txn_dtls_tbl(res_ctr).transaction_uom;
3856: l_wip_cost_txn_interface_rec.wip_entity_name := p_res_txn_dtls_tbl(res_ctr).wip_entity_name;
3857: l_wip_cost_txn_interface_rec.wip_entity_id := p_res_txn_dtls_tbl(res_ctr).wip_entity_id;
3858:
3859: -- l_wip_cost_txn_interface_rec.employee_id := p_res_txn_dtls_tbl(res_ctr).employee_id;
3860:
3861: l_wip_cost_txn_interface_rec.employee_id := p_res_txn_dtls_tbl(res_ctr).employee_id;
3862: l_wip_cost_txn_interface_rec.employee_num := p_res_txn_dtls_tbl(res_ctr).employee_num;
3863:

Line 3861: l_wip_cost_txn_interface_rec.employee_id := p_res_txn_dtls_tbl(res_ctr).employee_id;

3857: l_wip_cost_txn_interface_rec.wip_entity_id := p_res_txn_dtls_tbl(res_ctr).wip_entity_id;
3858:
3859: -- l_wip_cost_txn_interface_rec.employee_id := p_res_txn_dtls_tbl(res_ctr).employee_id;
3860:
3861: l_wip_cost_txn_interface_rec.employee_id := p_res_txn_dtls_tbl(res_ctr).employee_id;
3862: l_wip_cost_txn_interface_rec.employee_num := p_res_txn_dtls_tbl(res_ctr).employee_num;
3863:
3864: --insert into table wip_cost_txn_interface
3865:

Line 3862: l_wip_cost_txn_interface_rec.employee_num := p_res_txn_dtls_tbl(res_ctr).employee_num;

3858:
3859: -- l_wip_cost_txn_interface_rec.employee_id := p_res_txn_dtls_tbl(res_ctr).employee_id;
3860:
3861: l_wip_cost_txn_interface_rec.employee_id := p_res_txn_dtls_tbl(res_ctr).employee_id;
3862: l_wip_cost_txn_interface_rec.employee_num := p_res_txn_dtls_tbl(res_ctr).employee_num;
3863:
3864: --insert into table wip_cost_txn_interface
3865:
3866: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3864: --insert into table wip_cost_txn_interface

3860:
3861: l_wip_cost_txn_interface_rec.employee_id := p_res_txn_dtls_tbl(res_ctr).employee_id;
3862: l_wip_cost_txn_interface_rec.employee_num := p_res_txn_dtls_tbl(res_ctr).employee_num;
3863:
3864: --insert into table wip_cost_txn_interface
3865:
3866: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3867: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
3868: lc_mod_name||'beforecallinsertwipcosttxn',

Line 3879: to_unit => l_wip_cost_txn_interface_rec.transaction_uom ,

3875: item_id => 0,
3876: precision => 38,
3877: from_quantity => 1,
3878: from_unit => p_res_txn_dtls_tbl(res_ctr).uom_code,
3879: to_unit => l_wip_cost_txn_interface_rec.transaction_uom ,
3880: from_name => NULL,
3881: to_name => NULL);
3882:
3883:

Line 3892: insert_wip_cost_txn( p_wip_cost_txn_interface_rec => l_wip_cost_txn_interface_rec,

3888: -- res_transactions_uom.conversion_rate;
3889:
3890:
3891:
3892: insert_wip_cost_txn( p_wip_cost_txn_interface_rec => l_wip_cost_txn_interface_rec,
3893: x_return_status => x_return_status );
3894:
3895:
3896: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN