APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_WORKORDER_TXNS

Line 3047: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Insert into AHL_WORKORDER_TXNS' );

3043: p_x_prd_workorder_rec.ATTRIBUTE15
3044: );
3045:
3046: IF ( G_DEBUG = 'Y' ) THEN
3047: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Insert into AHL_WORKORDER_TXNS' );
3048: END IF;
3049:
3050: INSERT INTO AHL_WORKORDER_TXNS
3051: (

Line 3050: INSERT INTO AHL_WORKORDER_TXNS

3046: IF ( G_DEBUG = 'Y' ) THEN
3047: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Insert into AHL_WORKORDER_TXNS' );
3048: END IF;
3049:
3050: INSERT INTO AHL_WORKORDER_TXNS
3051: (
3052: WORKORDER_TXN_ID,
3053: OBJECT_VERSION_NUMBER,
3054: LAST_UPDATE_DATE,

Line 3088: AHL_WORKORDER_TXNS_S.NEXTVAL,

3084: ATTRIBUTE14,
3085: ATTRIBUTE15
3086: ) VALUES
3087: (
3088: AHL_WORKORDER_TXNS_S.NEXTVAL,
3089: p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER,
3090: p_x_prd_workorder_rec.LAST_UPDATE_DATE,
3091: p_x_prd_workorder_rec.LAST_UPDATED_BY,
3092: p_x_prd_workorder_rec.CREATION_DATE,

Line 3813: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Inserting into AHL_WORKORDER_TXNS' );

3809: RAISE FND_API.G_EXC_ERROR;
3810: END IF;
3811:
3812: IF ( G_DEBUG = 'Y' ) THEN
3813: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Inserting into AHL_WORKORDER_TXNS' );
3814: END IF;
3815:
3816: INSERT INTO AHL_WORKORDER_TXNS
3817: (

Line 3816: INSERT INTO AHL_WORKORDER_TXNS

3812: IF ( G_DEBUG = 'Y' ) THEN
3813: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Inserting into AHL_WORKORDER_TXNS' );
3814: END IF;
3815:
3816: INSERT INTO AHL_WORKORDER_TXNS
3817: (
3818: WORKORDER_TXN_ID,
3819: OBJECT_VERSION_NUMBER,
3820: LAST_UPDATE_DATE,

Line 3838: AHL_WORKORDER_TXNS_S.NEXTVAL,

3834: COMPLETION_LOCATOR_ID,
3835: HOLD_REASON_CODE
3836: ) VALUES
3837: (
3838: AHL_WORKORDER_TXNS_S.NEXTVAL,
3839: NVL(p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER,1),
3840: NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
3841: NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
3842: NVL(p_x_prd_workorder_rec.CREATION_DATE,SYSDATE),