APPS.AHL_MM_MTL_MGT_PVT dependencies on AHL_MM_TXN_INTERFACE_S

Line 2449: --L_TRANSACTION_ID := AHL_MM_TXN_INTERFACE_S.CURRVAL;

2445: end if;
2446:
2447:
2448: -- Insert details into AHL_MM_TXN_INTERFACE table
2449: --L_TRANSACTION_ID := AHL_MM_TXN_INTERFACE_S.CURRVAL;
2450: FORALL X IN P_FM_SERIAL_NUM_TBL.FIRST .. P_FM_SERIAL_NUM_TBL.LAST
2451: INSERT
2452: INTO AHL_MM_TXN_INTERFACE
2453: (

Line 2466: AHL_MM_TXN_INTERFACE_S.NEXTVAL,

2462: PROCESSING_DATE
2463: )
2464: VALUES
2465: (
2466: AHL_MM_TXN_INTERFACE_S.NEXTVAL,
2467: X_REQUISITION_HDR_ID,
2468: 'ISO',
2469: 'S',
2470: X_RESERVATION_ID,

Line 2515: L_MM_TXN_INTERFACE_S_CURVAL := AHL_MM_TXN_INTERFACE_S.CURRVAL;

2511: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2512: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, ' L_ERROR_MESSAGE: '|| L_ERROR_MESSAGE);
2513: END IF;
2514:
2515: L_MM_TXN_INTERFACE_S_CURVAL := AHL_MM_TXN_INTERFACE_S.CURRVAL;
2516: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_FAIL');
2517: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2518: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2519: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );

Line 2526: --UPDATE AHL_MM_TXN_INTERFACE SET TXN_STATUS = 'E' WHERE TRANSACTION_ID = L_TRANSACTION_ID;

2522: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2523: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, ' L_ERROR_MESSAGE: '|| L_ERROR_MESSAGE);
2524: end if;
2525:
2526: --UPDATE AHL_MM_TXN_INTERFACE SET TXN_STATUS = 'E' WHERE TRANSACTION_ID = L_TRANSACTION_ID;
2527: --FORALL X IN P_FM_SERIAL_NUM_TBL.FIRST .. P_FM_SERIAL_NUM_TBL.LAST
2528: UPDATE AHL_MM_TXN_INTERFACE
2529: SET TXN_STATUS = 'E', ERROR_MESSAGE = L_ERROR_MESSAGE
2530: WHERE TRANSACTION_ID BETWEEN (L_MM_TXN_INTERFACE_S_CURVAL - P_QUANTITY + 1) AND L_MM_TXN_INTERFACE_S_CURVAL;