APPS.AHL_PRD_MTLTXN_PVT dependencies on DUAL

Line 1570: select AHL_WORKORDER_MTL_TXNS_S.currval into p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id from dual;

1566: X_LAST_UPDATE_DATE => SYSDATE,
1567: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1568: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1569:
1570: select AHL_WORKORDER_MTL_TXNS_S.currval into p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id from dual;
1571: -- p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id:=x_ahl_mtl_txn_id;
1572:
1573: IF G_DEBUG='Y' THEN
1574: AHL_DEBUG_PUB.debug('Entered p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id='||p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id);

Line 3110: FROM DUAL;

3106: --Item is under Lot and Serial Control
3107: --Generate serial transaction Temp id.
3108: SELECT Mtl_Material_Transactions_S.nextval
3109: INTO l_Srl_Txn_Tmp_Id
3110: FROM DUAL;
3111:
3112:
3113:
3114: l_mtlt_rec.Transaction_Temp_Id := x_Txn_Tmp_Id;

Line 3569: FROM DUAL;

3565:
3566: IF(p_x_txn_hdr_id IS NULL) THEN
3567: SELECT Mtl_Material_Transactions_S.nextval
3568: INTO p_x_txn_hdr_id
3569: FROM DUAL;
3570: IF G_DEBUG='Y' THEN
3571: AHL_DEBUG_PUB.debug('Header id created..['||p_x_txn_hdr_id||']');
3572: END IF;
3573: END IF;

Line 3581: FROM DUAL;

3577: WHILE (l_loop_count < p_x_ahl_mtl_txn_rec.Quantity) LOOP
3578:
3579: SELECT Mtl_Material_Transactions_S.nextval
3580: INTO p_x_txn_intf_id
3581: FROM DUAL;
3582:
3583: IF G_DEBUG='Y' THEN
3584: AHL_DEBUG_PUB.debug('Interface id created..['||p_x_txn_intf_id||']');
3585: END IF;

Line 3713: FROM DUAL;

3709:
3710: IF(p_x_ahl_mtl_txn_rec.Serial_Number IS NOT NULL) THEN
3711: SELECT Mtl_Material_Transactions_S.nextval
3712: INTO l_txn_tmp_id
3713: FROM DUAL;
3714: ELSE
3715: l_txn_tmp_id := p_x_txn_intf_id;
3716: END IF;
3717: