DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on CSD_WIP_TRANSACTION_DTLS_PKG

Line 3439: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');

3435:
3436: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3437: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
3438: lc_mod_name||'beforecallupdaterow',
3439: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');
3440: END IF;
3441:
3442: -- yvchen: bug 13258460
3443: -- 12.1.3+ adding DFFs - instead of deleting the row, update it

Line 3447: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row(

3443: -- 12.1.3+ adding DFFs - instead of deleting the row, update it
3444: -- so that the the DFFs are not deleted.
3445: -- null out transaction qty, uom, serial number, revision, and reason id
3446: -- table handler uses g_miss to indicate nulling out
3447: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row(
3448: p_WIP_TRANSACTION_DETAIL_ID => p_mtl_txn_dtls_tbl(mtl_ctr).WIP_TRANSACTION_DETAIL_ID
3449: ,p_CREATED_BY => null
3450: ,p_CREATION_DATE => null
3451: ,p_LAST_UPDATED_BY => l_last_updated_by

Line 3478: CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row(

3474: ,p_OBJECT_VERSION_NUMBER => p_mtl_txn_dtls_tbl(mtl_ctr).object_version_number
3475: ,p_CREATE_RO_FLAG => nvl(p_mtl_txn_dtls_tbl(mtl_ctr).CREATE_RO_FLAG, FND_API.G_MISS_CHAR) -- bug#13698799 auto create ro, parent ro
3476: );
3477: /*
3478: CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row(
3479: p_WIP_TRANSACTION_DETAIL_ID => p_mtl_txn_dtls_tbl(mtl_ctr).WIP_TRANSACTION_DETAIL_ID );
3480: */
3481: end if;
3482:

Line 4436: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row');

4432:
4433: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4434: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
4435: lc_mod_name||'beforecallupdaterow',
4436: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row');
4437: END IF;
4438:
4439: -- swai: bug 15955754 (FP of bug 14823164)
4440: -- 12.1.3+ adding DFFs - instead of deleting the row, update it

Line 4444: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row(

4440: -- 12.1.3+ adding DFFs - instead of deleting the row, update it
4441: -- so that the the DFFs are not deleted.
4442: -- null out transaction qty, uom
4443: -- table handler uses g_miss to indicate nulling out
4444: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row(
4445: p_WIP_TRANSACTION_DETAIL_ID => p_res_txn_dtls_tbl(res_ctr).WIP_TRANSACTION_DETAIL_ID
4446: ,p_CREATED_BY => null
4447: ,p_CREATION_DATE => null
4448: ,p_LAST_UPDATED_BY => l_last_updated_by

Line 4476: CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row(

4472: ,p_CREATE_RO_FLAG => null
4473: );
4474:
4475: /*
4476: CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row(
4477: p_WIP_TRANSACTION_DETAIL_ID => p_res_txn_dtls_tbl(res_ctr).WIP_TRANSACTION_DETAIL_ID );
4478: */
4479: end if;
4480:

Line 5255: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Insert_Row');

5251: If p_mtl_txn_dtls_tbl(mtl_ctr).WIP_TRANSACTION_DETAIL_ID is null then
5252: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5253: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
5254: lc_mod_name||'beforecallinsertrow',
5255: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Insert_Row');
5256: END IF;
5257:
5258: l_WIP_TRANSACTION_DETAIL_ID := null;
5259:

Line 5260: CSD_WIP_TRANSACTION_DTLS_PKG.Insert_Row(

5256: END IF;
5257:
5258: l_WIP_TRANSACTION_DETAIL_ID := null;
5259:
5260: CSD_WIP_TRANSACTION_DTLS_PKG.Insert_Row(
5261: px_WIP_TRANSACTION_DETAIL_ID => l_WIP_TRANSACTION_DETAIL_ID
5262: ,p_CREATED_BY => l_created_by
5263: ,p_CREATION_DATE => l_creation_date
5264: ,p_LAST_UPDATED_BY => l_last_updated_by

Line 5312: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');

5308:
5309: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5310: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
5311: lc_mod_name||'beforecallupdaterow',
5312: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');
5313: END IF;
5314:
5315: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row(
5316: p_WIP_TRANSACTION_DETAIL_ID => p_mtl_txn_dtls_tbl(mtl_ctr).WIP_TRANSACTION_DETAIL_ID

Line 5315: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row(

5311: lc_mod_name||'beforecallupdaterow',
5312: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');
5313: END IF;
5314:
5315: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row(
5316: p_WIP_TRANSACTION_DETAIL_ID => p_mtl_txn_dtls_tbl(mtl_ctr).WIP_TRANSACTION_DETAIL_ID
5317: ,p_CREATED_BY => null
5318: ,p_CREATION_DATE => null
5319: ,p_LAST_UPDATED_BY => l_last_updated_by

Line 5719: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Insert_Row');

5715:
5716: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5717: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
5718: lc_mod_name||'beforecallinsertrow',
5719: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Insert_Row');
5720: END IF;
5721:
5722: l_WIP_TRANSACTION_DETAIL_ID := null;
5723:

Line 5724: CSD_WIP_TRANSACTION_DTLS_PKG.Insert_Row(

5720: END IF;
5721:
5722: l_WIP_TRANSACTION_DETAIL_ID := null;
5723:
5724: CSD_WIP_TRANSACTION_DTLS_PKG.Insert_Row(
5725: px_WIP_TRANSACTION_DETAIL_ID => l_WIP_TRANSACTION_DETAIL_ID
5726: ,p_CREATED_BY => l_created_by
5727: ,p_CREATION_DATE => l_creation_date
5728: ,p_LAST_UPDATED_BY => l_last_updated_by

Line 5775: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');

5771:
5772: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5773: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
5774: lc_mod_name||'beforecallupdaterow',
5775: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');
5776: END IF;
5777:
5778:
5779: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row(

Line 5779: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row(

5775: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');
5776: END IF;
5777:
5778:
5779: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row(
5780: p_WIP_TRANSACTION_DETAIL_ID => p_res_txn_dtls_tbl(res_ctr).WIP_TRANSACTION_DETAIL_ID
5781: ,p_CREATED_BY => null
5782: ,p_CREATION_DATE => null
5783: ,p_LAST_UPDATED_BY => l_last_updated_by

Line 6119: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Insert_Row');

6115: If p_op_dtls_tbl(op_ctr).WIP_TRANSACTION_DETAIL_ID is null then
6116: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6117: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
6118: lc_mod_name||'beforecallinsertrow',
6119: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Insert_Row');
6120: END IF;
6121:
6122: l_WIP_TRANSACTION_DETAIL_ID := null;
6123:

Line 6124: CSD_WIP_TRANSACTION_DTLS_PKG.Insert_Row(

6120: END IF;
6121:
6122: l_WIP_TRANSACTION_DETAIL_ID := null;
6123:
6124: CSD_WIP_TRANSACTION_DTLS_PKG.Insert_Row(
6125: px_WIP_TRANSACTION_DETAIL_ID => l_WIP_TRANSACTION_DETAIL_ID
6126: ,p_CREATED_BY => l_created_by
6127: ,p_CREATION_DATE => l_creation_date
6128: ,p_LAST_UPDATED_BY => l_last_updated_by

Line 6175: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');

6171: else
6172: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6173: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
6174: lc_mod_name||'beforecallupdaterow',
6175: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');
6176: END IF;
6177:
6178: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row(
6179: p_WIP_TRANSACTION_DETAIL_ID => p_op_dtls_tbl(op_ctr).WIP_TRANSACTION_DETAIL_ID

Line 6178: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row(

6174: lc_mod_name||'beforecallupdaterow',
6175: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');
6176: END IF;
6177:
6178: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row(
6179: p_WIP_TRANSACTION_DETAIL_ID => p_op_dtls_tbl(op_ctr).WIP_TRANSACTION_DETAIL_ID
6180: ,p_CREATED_BY => null
6181: ,p_CREATION_DATE => null
6182: ,p_LAST_UPDATED_BY => l_last_updated_by

Line 9348: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row');

9344: If l_wip_transaction_detail_id is not null then
9345: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
9346: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
9347: lc_mod_name||'beforecallinsertrow',
9348: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row');
9349: END IF;
9350:
9351: CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row(
9352: p_WIP_TRANSACTION_DETAIL_ID => l_WIP_TRANSACTION_DETAIL_ID);

Line 9351: CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row(

9347: lc_mod_name||'beforecallinsertrow',
9348: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row');
9349: END IF;
9350:
9351: CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row(
9352: p_WIP_TRANSACTION_DETAIL_ID => l_WIP_TRANSACTION_DETAIL_ID);
9353:
9354: end if;
9355:

Line 9719: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');

9715: if (l_required_quantity is not null) then
9716: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
9717: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
9718: lc_mod_name,
9719: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');
9720: END IF;
9721:
9722: -- update the material transaction qty for the first operation on the job
9723: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row (

Line 9723: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row (

9719: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row');
9720: END IF;
9721:
9722: -- update the material transaction qty for the first operation on the job
9723: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row (
9724: p_WIP_TRANSACTION_DETAIL_ID => l_txn_detail_id
9725: ,p_CREATED_BY => null
9726: ,p_CREATION_DATE => null
9727: ,p_LAST_UPDATED_BY => fnd_global.user_id

Line 9777: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row');

9773: /** DELETE CSD_WIP_TRANSACTION_DETAILS ROW for the deleted operation **/
9774: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
9775: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
9776: lc_mod_name,
9777: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row');
9778: END IF;
9779: -- remove the row in CSD table.
9780: -- should have been taken care of in WIP Delete_Operation API
9781: CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row(

Line 9781: CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row(

9777: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row');
9778: END IF;
9779: -- remove the row in CSD table.
9780: -- should have been taken care of in WIP Delete_Operation API
9781: CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row(
9782: p_WIP_TRANSACTION_DETAIL_ID => wip_txn_detail_rec.WIP_TRANSACTION_DETAIL_ID);
9783:
9784: END LOOP;
9785: